Database Mandatory Version Mismatch

[Tr3nchant]

I'm running into a database version mismatch issue with Zabbix 6.0 freshly deployed on an Ubuntu 20.04LTS server.



I'm able to install all of the packages for zabbix 6.0 onto Ubuntu 20.04 LTS and get through all of the zabbix installation and configuration steps. My issues start with running the zabbix-server.service

After the apache front end is setup it shows the Zabbix Server is offline




This is confirmed from within Ubuntu


The server's log file shows an error regarding the database mandatory version (note: I'm running Mysql with MariaDB).



1914:20220524:002309.010 The server does not match Zabbix database. Current database version (mandatory/optional): 06000000/06000000. Required mandatory version: 04000000.

I found I can run this series of commands to fix the zabbix.server.service issue:

Mysql> use zabbix;
Mysql> update dbversion set mandatory=04000000;
Mysql> Flush privileges;
Mysql> quit



After adjusting the sql dbversion the zabbix-server.service is able to run without exiting


But now with the server running if I attempt to access the front end I get the error:

"The Zabbix database version does not match current requirements. Your database version: 4000000. Required version: 6000000."



So by changing the sql database mandatory version I fix the Zabbix Server service but break the front end apache.

For reference here is the server log after making the mandatory change:



1869:20220524:010745.900 Starting Zabbix Server. Zabbix 4.0.17 (revision a528a0a4bc).

1869:20220524:010745.900 ****** Enabled features ******

1869:20220524:010745.900 SNMP monitoring: YES

1869:20220524:010745.900 IPMI monitoring: YES

1869:20220524:010745.900 Web monitoring: YES

1869:20220524:010745.900 VMware monitoring: YES

1869:20220524:010745.900 SMTP authentication: YES

1869:20220524:010745.900 Jabber notifications: YES

1869:20220524:010745.900 Ez Texting notifications: YES

1869:20220524:010745.900 ODBC: YES

1869:20220524:010745.900 SSH2 support: YES

1869:20220524:010745.900 IPv6 support: YES

1869:20220524:010745.900 TLS support: YES

1869:20220524:010745.900 ******************************

1869:20220524:010745.900 using configuration file: /etc/zabbix/zabbix_server.conf

1869:20220524:010745.926 current database version (mandatory/optional): 04000000/06000000

1869:20220524:010745.927 required mandatory version: 04000000

1869:20220524:010745.929 server #0 started [main process]

1878:20220524:010745.933 server Home started [configuration syncer #1]

1878:20220524:010745.938 [Z3005] query failed: [1054] Unknown column 'refresh_unsupported' in 'field list' [select refresh_unsupported,discovery_groupid,snmptrap_log ging,severity_name_0,severity_name_1,severity_name _2,severity_name_3,severity_name_4,severity_name_5 ,hk_events_mode,hk_events_trigger,hk_events_intern al,hk_events_discovery,hk_events_autoreg,hk_servic es_mode,hk_services,hk_audit_mode,hk_audit,hk_sess ions_mode,hk_sessions,hk_history_mode,hk_history_g lobal,hk_history,hk_trends_mode,hk_trends_global,h k_trends,default_inventory_mode from config order by configid]>

zabbix_server [1878]: ERROR [file:dbconfig.c,line:5281] Something impossible has just happened.





Any help in getting this fixed would be greatly appreciated!

[Atsushi]

Your environment seems to be a mixture of Zabbix 6.0 and 4.0. If you want to use Zabbix 6.0, please reinstall zabbix-server.

[cyber]

Server binaries are definitely from 4.0.... Needs some updating..

[Tr3nchant]

Your environment seems to be a mixture of Zabbix 6.0 and 4.0. If you want to use Zabbix 6.0, please reinstall zabbix-server.

Thanks for the reply!

I followed the install instructions provided for 6.0 to get the most recent repository and package:

# wget https://repo.zabbix.com/zabbix/6.0/u...u20.04_all.deb
# dpkg -i zabbix-release_6.0-1+ubuntu20.04_all.deb

Why would a previous version have installed? Is there a method I need to follow to ensure I'm getting the server package from the above repository?

[Atsushi]

I think that the previous version was installed because the package information was not updated after installing the zabbix-release package. Therefore, the old version of Zabbix on the OS standard repository may have been installed. After installing zabbix-release package, please execute apt update to update the package information and then install Zabbix related packages. The download page has proper instructions.