Upgrade from 5.4 to 7.0

[morsing]

Good afternoon,

I have failed to find the (database) scripts that upgrade the database from 5.4 up to 7.0. They are not in the source, on git.zabbix.com or anywhere else I can see. I can see the scripts that create a new database, but not ones that upgrade.

Where do I find these?

Regards,
Henrik Morsing

[Julianna Wilamowska]

Hi, when you upgrade the zabbix server the Database gets upgraded automatically. If you did the upgrade and still see error "cannot connect to database, the zabbix database version does not match current requirements" please check logs as the db upgrade may still be running. You can use this command cat /var/log/zabbix/zabbix_server.log | grep database

[morsing]

Hi Julianna,

I had this message:

"Cannot connect to the database.

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

zz0.17yv64b3yt6zz"

Which persisted for weeks. There is nothing in the log when I try to connect.

I found out now that it was missing the password for the database in the Zabbix config, obviously as I spent all my time tracking down migration scripts because the documentation said I couldn't do this in one jump.

Thanks for your help, it is working now.

Regards,
Henrik Morsing

[cyber]

There is no scripts, it is in server code.

https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/libs/zbxdbupgrade

And you can upgrade 5.4 to 7 in one go if your platform supports it. By definition you could do it even with 2.0 to 7.0, but I think it is hard to find a platform that would support both of them, so you could actually run that upgrade... With a change of platform and copy of old DB it should not be a problem..