I have a backup of a Zabbix 4.0.13 system that has issues. I've setup a new server with 5.2 and have imported the DB into mysql. When finishing the GUI setup I get the message "The Zabbix database version does not match current requirements. Your database version: 4000000. Required version: 5020000. Please contact your system administrator.". I am missing a DB schema upgrade. Can anyone tell me where the scripts are at for updating the DB schema? If there's directions for running the schema scripts please let me know. I've been unable to find any info on running the db upgrade manually.
-
-
Did you restart the zabbix-server daemon (not the gui)? It will upgrade the db automatically upon start. Also, check the logfile for output of the process and any error messages. -
I got everything resolved. This is the steps that I took.
Used these diretions to downgrade to v4 (I'm using debian)
https://www.zabbix.com/download?zabb...debian&os_vers ion=10_buster&db=mysql&ws=apache
Got the interface setup using the first run setup in the web gui
I then upgraded following these instructions
I ran into a few issues. They were
1) The date needed setup in PHP. I did not record how I did this but I uncommented a line in php.ini and set it to America/New_York
2) The user accuont needed setup for the right permissions in mysql: alter user 'zabbix'@'localhost' identified with mysql_native_password by '$yourpasswordgoeshere';
3) The zabbix.conf file the password was lost during the upgrade. I had to put the password back in. Remember that if you're typing it in don't put a space between the = and the password. I got stuck on that one for a little bit. The command is DBPassword=$yourpasswordgoeshere
The upgrade of the DB schema started after all of the above was corrected and zabbix-server was restarted. The upgrade status shows up in /var/log/zabbix/zabbix_server.logComment
Comment