Upgrade issue help

[vedranOP]

Hello!

Please help, I upgraded from 3.2 to 3.4 but now i have a following error:

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

Can someone guide me how to fix it? How to upgrade database?
I am not a linux user, more of a basic user...

Bg,

V

[LenR]

You need to start your server first. It will upgrade the database, then your frontend will be happy.

From server log:

21295:20170823:230709.776 using configuration file: /etc/zabbix/zabbix_server.conf
121295:20170823:230709.849 current database version (mandatory/optional): 03000000/03000000
121295:20170823:230709.849 required mandatory version: 03040000
121295:20170823:230709.849 starting automatic database upgrade
121295:20170823:230710.094 completed 0% of database upgrade
121295:20170823:230712.423 completed 1% of database upgrade
121295:20170823:230735.434 slow query: 23.011263 sec, "alter table history_text drop column id"
121295:20170823:230744.823 slow query: 9.387150 sec, "alter table triggers add recovery_mode integer default '0' not null"
121295:20170823:230752.731 slow query: 7.906211 sec, "alter table triggers add recovery_expression varchar(2048) default '' not null"
121295:20170823:230752.733 completed 2% of database upgrade
121295:20170823:230752.779 completed 3% of database upgrade
............
121295:20170824:000107.106 completed 99% of database upgrade
121295:20170824:000107.113 completed 100% of database upgrade
121295:20170824:000107.113 database upgrade fully completed

[vedranOP]

Hi, thank you for your answer but when I run service zabbix-server status


Output is:

zabbix-server.service - Zabbix Server
Loaded: loaded (/lib/systemd/system/zabbix-server.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2017-08-28 21:23:24 CEST; 10h ago


Any other suggestion or any input what did I do wrong in this step?

Cheers

[vedranOP]

Had to change the pass in conf file because it was access denied in server log.

[allexpetrov]

Try to check if the variables in zabbix.conf.php ( /etc/zabbix/web/ ) are correct. I had zabbix/zabbix , but my dbname and dbuser aren't like default.

Regards,
Alex!