Database upgrade failure during Upgrade.

[jca001]

I am running Zabbix 6.0.8 in Oracle Linux 8.7 and today the were OS and other update available so I updated everything which include Zabbix Server. Everything went fine until the Zabbix Server did a Database Upgrade. Base on the zabbix_server.log Zabbix Server got upgraded to 6.0.12 and required a database Update. It completed 46% and then got the following error:

[Z3005] query failed [1419] You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creator variable) [create trigger hosts_name_upper_insert before insert on hosts for each row set new.name_upper = upper(new.name)].

That is a lot of information, but I have no idea where to make the suggested changes.

Please advise.

[Markku]

See download+install instructions at https://www.zabbix.com/download?zabb...ysql&ws=apache:

set global log_bin_trust_function_creators = 1; in the MySQL shell.

Markku

[Markku]

It is also documented in the upgrade notes so they should be always read as well: https://www.zabbix.com/documentation...ade_notes_6011

Markku

[jca001]

Markku:
Thanks for the information. While waiting for replies I did some more Googling and found the configuration file I need to add the parameter. Did so and stopped and started the needed Services and the Database Upgrade completed.
Everything is up and working fine now.
I had not planed on upgrading Zabbix, I was upgrading the OS and other packages and did not notice Zabbix was included or I would have read the Zabbix Release Notes.