Not sure what to do: Upgrading from 6.4.2 to 7.2 Database Error no matter what options I choose.
[EDIT: RESOLVED! Answer at the bottom] So I wanted to upgrade from 6.4.2 to 7.2 today. Following the instructions at:
https://www.zabbix.com/documentation/current/en/manual/installation/upgrade/packages/debian_ubuntu
When I am all done, even if I reboot the system I am greeted with the error:
The Zabbix database version does not match current requirements. Your database version: 6050035. Required version: 7020000. Please contact your system administrator.
I am on 22.04 Ubuntu and it is fully updated. No errors. The only thing is the three questions that I am asked:
- zabbix.list <--Instructions say to say "yes"
- zabbix_server.conf <-- not clear I have done "Y" and I have done "N"
- Proxy something <-- instructions do not mention this at all. I have tried Y and N but really that is a done situation.
So I have this on a VM and I just revert the snapshot so it isn't bad to do again and again. I know that when you start back up the zabbix-server service that it is supposed to see that there is a database change and it should update but it isn't. I found one post that said something about the zabbix_server.conf file but I told it to not touch that. Also, it isn't getting login issues, it is getting database mismatch version issues. Someone else said to grab the zabbix-sql-scripts but that didn't do anything either.
I'm at a loss as to what to do. Yes, I can just forget about it but that is not what I want to do.
[Edit]
The resolution was in the "Upgrade Notes" for 7.2:
Upgrade process
To complete a successful Zabbix server upgrade on MySQL/MariaDB, you may require to set GLOBAL log_bin_trust_function_creators = 1
in MySQL if binary logging is enabled, there are no superuser privileges and log_bin_trust_function_creators = 1
is not set in MySQL configuration file.
To set the variable using the MySQL console, run:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
Once the upgrade has been successfully completed, this option can be disabled:
mysql> SET GLOBAL log_bin_trust_function_creators = 0;
What I did was after I reverted back to my snapshot I ran this command before doing anything. I then did the whole process and then when it was done it was working. I then went back and did the 2nd command.
Note: There was no "updating database" feedback or anything like I have seen in the past. It just kind of was done.
Thank you to those that attempted to help. That was a hellride. They really need to either just put that in the instructions or have instructions to manually force the database to update/upgrade or whatever. IDK.