'The frontend does not match Zabbix database' after upgrade to 5

[kvkewn]

Hi,

Upgraded from 4.4 to 5 on my RPi and everything went smoothly except when i try to access Zabbix i now get:

=============================
Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 4040000/4040000. Required mandatory version: 5000000. Contact your system administrator.
=============================

I followed the process seen here: https://www.zabbix.com/documentation.../debian_ubuntu

Had to obviously replace the package name for raspbian and the db for pgsql.

It looks like the zabbixdb is currently at version 5:

=============================
zabbix-server-pgsql is already the newest version (1:5.0.0-1+buster).
=============================

Portgresql is also running a required version:

=============================
postgres (PostgreSQL) 11.5 (Raspbian 11.5-1+deb10u1)
=============================

Any idea which component needs upgrading?

Tried a reload of the Pi but that did not help.

[tim.mooney]

The database "version" gets upgraded when zabbix_server 5.x starts and notices that the version recorded in the database doesn't match the mandatory version that 5.0.x has specified.

So, have you started zabbix_server at least once since you installed the 5.x package?

Assuming you started zabbix_server, it should have logged what it was doing to the zabbix_server.log file. Are there any messages in there indicating there was a problem with the database update?

[kvkewn]

Hi,

From the logs:

================================================== ==============
677:20200527:134516.345 Starting Zabbix Server. Zabbix 5.0.0 (revision 9665d62db0).
677:20200527:134516.353 ****** Enabled features ******
677:20200527:134516.353 SNMP monitoring: YES
677:20200527:134516.353 IPMI monitoring: YES
677:20200527:134516.353 Web monitoring: YES
677:20200527:134516.353 VMware monitoring: YES
677:20200527:134516.353 SMTP authentication: YES
677:20200527:134516.353 ODBC: YES
677:20200527:134516.353 SSH support: YES
677:20200527:134516.353 IPv6 support: YES
677:20200527:134516.353 TLS support: YES
677:20200527:134516.353 ******************************
677:20200527:134516.354 using configuration file: /etc/zabbix/zabbix_server.conf
677:20200527:134516.416 [Z3001] connection to database 'zabbix' failed: [0] fe_sendauth: no password supplied
================================================== ==============

Turns out the DBPassword line was commented out from .conf.

I ended up changing the password.

I now see:

================================================== ==============
7231:20200528:090820.451 using configuration file: /etc/zabbix/zabbix_server.conf
7231:20200528:090820.534 current database version (mandatory/optional): 04050015/04050015
7231:20200528:090820.534 required mandatory version: 05000000
7231:20200528:090820.534 starting automatic database upgrade
7231:20200528:090820.535 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: relation "media_type_message" already exists
[create table media_type_message (
mediatype_messageid bigint not null,
mediatypeid bigint not null,
eventsource integer not null,
recovery integer not null,
subject varchar(255) default '' not null,
message text default '' not null,
primary key (mediatype_messageid)
)]
7231:20200528:090820.535 database upgrade failed
================================================== ==============

[rasshiva]

I made another basic typo that i have found and solved. I apologise for wasting your time on this. Will check my stuff more thoroughly next time

[NAGIREDK]

rasshiva I am facing same issue

• The Zabbix database version does not match current requirements. Your database version: 4040000. Required version: 5000000. Please contact your system administrator.

can you please advise what you did .?

[Avinasha]

while upgrading from older versions to 5.X, you need to run a script that is available in upgrade documents. It basically extends the range of numeri values DB has. Go though the documentation here

https://www.zabbix.com/documentation/5.0/manual/installation/upgrade/packages/rhel_centos

https://www.zabbix.com/documentation/5.0/manual/installation/upgrade_notes_500#configuration_parameters

[junoon]

Check your DBPassword in zabbix_server.conf
go to # sudo nano /etc/zabbix/zabbix_server.conf
add a line under # DBPassword=
DBPassword=zabbix
save and exit
# sudo zabbix-server restart
# sudo zabbix-agent restart
# sudo systemctl restart zabbix-server zabbix-agent apache2
# sudo systemctl enable zabbix-server zabbix-agent apache2

Clear your browsing history then check your frontend