Advertising:
Error al actualizar zabbix de 4.4.7 a 5 (beta) (Z3005 query failed: 1091 Can't DROP ‘snmpv3 securityname’)
Jump to navigation
Jump to search
[Z3005] query failed: [1091] Can't DROP ‘snmpv3_securityname’
# systemctl stop zabbix-server ERROR en el FrontEnd : required mandatory version: 04050079
ERROR en log de Zabbix: [Z3005] query failed: [1091] Can't DROP ‘snmpv3_securityname’; check that column/key exists [alter table items drop column snmpv3_securityname]
Paso 1 Actualizar dbversion a la version que sale en el error
mysql> show databases; mysql> use zabbix; mysql> update dbversion set mandatory= 04050079;
Paso 2 Creamos la columna que falta e intentamos arrancar zabbix
mysql> use zabbix; mysql> ALTER TABLE items ADD COLUMN snmpv3_securityname INT;
# systemctl start zabbix-server # tail -f /var/log/zabbix/zabbix_server.log
Miramos el Log y vemos si arranca correctamente.