Upgraded to Zabbix 5 and now my DB isn't working

[plattnat]

I upgraded to 5 using all the instructions on the zabbix site, now i get this;

Database error

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

So i looked at the logs and found this;

[root@zabbix ~]# tail -f /var/log/zabbix/zabbix_server.log
1613:20200914:123320.095 VMware monitoring: YES
1613:20200914:123320.095 SMTP authentication: YES
1613:20200914:123320.095 ODBC: YES
1613:20200914:123320.095 SSH support: YES
1613:20200914:123320.095 IPv6 support: YES
1613:20200914:123320.095 TLS support: YES
1613:20200914:123320.095 ******************************
1613:20200914:123320.095 using configuration file: /etc/zabbix/zabbix_server.conf
1613:20200914:123320.101 [Z3005] query failed: [1932] Table 'zabbix.users' doesn't exist in engine [select userid from users limit 1]
1613:20200914:123320.101 cannot use database "zabbix": database is not a Zabbix database

It just repeats and repeats but i can't seem to get it to run.

PHP 7.2.33
Centos 7
10.5.5-MariaDB MariaDB Server

I did get this error before when i first booted the new server but i left it upgrading and now i get this, any ideas?

[Gutsycat]

I upgraded to 5 using all the instructions on the zabbix site, now i get this;
1613:20200914:123320.101 [Z3005] query failed: [1932] Table 'zabbix.users' doesn't exist in engine [select userid from users limit 1]
1613:20200914:123320.101 cannot use database "zabbix": database is not a Zabbix database

If you use all instructions on zabbix site you must have database backup, aren't you? You coul simply restore users table or if you do not have database backup you could try to get zabbix.users schema from /usr/share/doc/zabbix-server-mysql*/create.sql.gz and restore it. Next register all your users again.

[plattnat]

I ended up giving up and re-installing from scatch but now its Zabbix agent is not available (or nodata for 30m) on the machines that it used to monitor in 4, nothing has changed on the original hosts

[the.monitor]

Did you update the Zabbix-agents? It states in the documentation that you must update your agents to 5.0 as older versions are not compatible with the new version.

(this is where i'm stuck in planning for 5.0 - I need an automation tool to handle this haha too many hosts to update)