Bonjour,
J'ai mis à jour mon serveur Zabbix ce matin de la version 3.2 à la version 4.0 mais j'ai visiblement un petit problème de base de donnée que je n'arrive pas à résoudre...
root@SUPERVISION:~# uname -a
Linux SUPERVISION 3.16.0-7-amd64 #1 SMP Debian 3.16.59-1 (2018-10-03) x86_64 GNU/Linux
root@SUPERVISION:~# mysql -V
mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (x86_64) using readline 6.3
root@SUPERVISION:~# apache2 -v
Server version: Apache/2.4.10 (Debian)
Server built: Mar 31 2018 09:39:03
root@SUPERVISION:~# tail -f /var/log/zabbix/zabbix_server.log
10922:20181022:154911.239 SSH2 support: YES
10922:20181022:154911.239 IPv6 support: YES
10922:20181022:154911.239 TLS support: YES
10922:20181022:154911.239 ******************************
10922:20181022:154911.239 using configuration file: /etc/zabbix/zabbix_server.conf
10922:20181022:154911.243 current database version (mandatory/optional): 03050062/03050062
10922:20181022:154911.243 required mandatory version: 04000000
10922:20181022:154911.243 starting automatic database upgrade
10922:20181022:154911.244 [Z3005] query failed: [1060] Duplicate column name 'allow_traps' [alter table `items` add `allow_traps` integer default '0' not null]
10922:20181022:154911.244 database upgrade failed
11409:20181022:154921.489 Starting Zabbix Server. Zabbix 4.0.0 (revision 85308).
11409:20181022:154921.489 ****** Enabled features ******
11409:20181022:154921.489 SNMP monitoring: YES
11409:20181022:154921.489 IPMI monitoring: YES
11409:20181022:154921.489 Web monitoring: YES
11409:20181022:154921.489 VMware monitoring: YES
11409:20181022:154921.489 SMTP authentication: YES
11409:20181022:154921.489 Jabber notifications: YES
11409:20181022:154921.489 Ez Texting notifications: YES
11409:20181022:154921.489 ODBC: YES
11409:20181022:154921.489 SSH2 support: YES
11409:20181022:154921.489 IPv6 support: YES
11409:20181022:154921.489 TLS support: YES
11409:20181022:154921.489 ******************************
Mes étapes de MAJ:
wget http://repo.zabbix.com/zabbix/4.0/de...jessie_all.deb
dpkg -i zabbix-release_4.0-2+jessie_all.deb
apt-get update
apt-get upgrade
apt-get install --only-upgrade zabbix-server-mysql zabbix-agent zabbix-frontend-php
nano /etc/zabbix/zabbix_server.conf
service zabbix-server restart
Depuis cette MAJ, quand j'éssaie de me co à l'interface web j'ai le petit cadre rouge Database error avec le message:
Help please,
J'ai mis à jour mon serveur Zabbix ce matin de la version 3.2 à la version 4.0 mais j'ai visiblement un petit problème de base de donnée que je n'arrive pas à résoudre...
root@SUPERVISION:~# uname -a
Linux SUPERVISION 3.16.0-7-amd64 #1 SMP Debian 3.16.59-1 (2018-10-03) x86_64 GNU/Linux
root@SUPERVISION:~# mysql -V
mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (x86_64) using readline 6.3
root@SUPERVISION:~# apache2 -v
Server version: Apache/2.4.10 (Debian)
Server built: Mar 31 2018 09:39:03
root@SUPERVISION:~# tail -f /var/log/zabbix/zabbix_server.log
10922:20181022:154911.239 SSH2 support: YES
10922:20181022:154911.239 IPv6 support: YES
10922:20181022:154911.239 TLS support: YES
10922:20181022:154911.239 ******************************
10922:20181022:154911.239 using configuration file: /etc/zabbix/zabbix_server.conf
10922:20181022:154911.243 current database version (mandatory/optional): 03050062/03050062
10922:20181022:154911.243 required mandatory version: 04000000
10922:20181022:154911.243 starting automatic database upgrade
10922:20181022:154911.244 [Z3005] query failed: [1060] Duplicate column name 'allow_traps' [alter table `items` add `allow_traps` integer default '0' not null]
10922:20181022:154911.244 database upgrade failed
11409:20181022:154921.489 Starting Zabbix Server. Zabbix 4.0.0 (revision 85308).
11409:20181022:154921.489 ****** Enabled features ******
11409:20181022:154921.489 SNMP monitoring: YES
11409:20181022:154921.489 IPMI monitoring: YES
11409:20181022:154921.489 Web monitoring: YES
11409:20181022:154921.489 VMware monitoring: YES
11409:20181022:154921.489 SMTP authentication: YES
11409:20181022:154921.489 Jabber notifications: YES
11409:20181022:154921.489 Ez Texting notifications: YES
11409:20181022:154921.489 ODBC: YES
11409:20181022:154921.489 SSH2 support: YES
11409:20181022:154921.489 IPv6 support: YES
11409:20181022:154921.489 TLS support: YES
11409:20181022:154921.489 ******************************
Mes étapes de MAJ:
wget http://repo.zabbix.com/zabbix/4.0/de...jessie_all.deb
dpkg -i zabbix-release_4.0-2+jessie_all.deb
apt-get update
apt-get upgrade
apt-get install --only-upgrade zabbix-server-mysql zabbix-agent zabbix-frontend-php
nano /etc/zabbix/zabbix_server.conf
service zabbix-server restart
Depuis cette MAJ, quand j'éssaie de me co à l'interface web j'ai le petit cadre rouge Database error avec le message:
- The frontend does not match Zabbix database. Current database version (mandatory/optional): 3050062/3050062. Required mandatory version: 4000000. Contact your system administrator.
Help please,