Différences

Ci-dessous, les différences entre deux révisions de la page.

--- linux:zabbix [03-11-2014 10:37] – edmc73
+++ linux:zabbix [14-10-2025 09:34] (Version actuelle) – edmc73
@@ Ligne 1: / Ligne 1: @@
 ====== Zabbix ======
 ===== Installation =====
@@ Ligne 42: / Ligne 43: @@
 Et ajouter un media email à votre profil.
+==== Upgrade ====
+Si vous avez un message du genre
+  The Zabbix database version does not match current requirements. Your database version: 6010048. Required version: 7020000.
+  sudo mysql -u root -p
+<code>
+MariaDB [(none)]> SHOW VARIABLES LIKE 'log_bin_trust_function_creators';
++---------------------------------+-------+
+| Variable_name                   | Value |
++---------------------------------+-------+
+| log_bin_trust_function_creators | OFF   |
++---------------------------------+-------+
+row in set (0,001 sec)
+MariaDB [(none)]> SET GLOBAL log_bin_trust_function_creators = 1;
+Query OK, 0 rows affected (0,002 sec)
+MariaDB [(none)]>
+MariaDB [(none)]> SHOW VARIABLES LIKE 'log_bin_trust_function_creators';
++---------------------------------+-------+
+| Variable_name                   | Value |
++---------------------------------+-------+
+| log_bin_trust_function_creators | ON    |
++---------------------------------+-------+
+row in set (0,001 sec)
+MariaDB [(none)]> ^C
+MariaDB [(none)]> ^DBye
+root@:~# systemctl restart zabbix-server.service
+root@:~# vi /var/log/zabbix/zabbix_server.log
+:20251014:113001.933 starting automatic database upgrade
+:20251014:113002.052 completed 2% of database upgrade
+:20251014:113002.078 completed 4% of database upgrade
+...
+:20251014:113003.978 completed 98% of database upgrade
+:20251014:113003.980 completed 100% of database upgrade
+:20251014:113003.980 database upgrade fully completed
+</code>
 ===== Agent Zabbix =====

Outils pour utilisateurs

Outils du site

Différences

Outils de la page