3345:20230131:105550.704 using configuration file: /etc/zabbix/zabbix_server.conf
3345:20230131:105550.715 current database version (mandatory/optional): 06000000/06000010
3345:20230131:105550.715 required mandatory version: 06000000
3345:20230131:105550.715 optional patches were found
3345:20230131:105550.715 starting automatic database upgrade
3345:20230131:105550.716 [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_creators variable) [create trigger hosts_name_upper_insert
The solution is this procedure:
systemctl stop zabbix-server
systemctl stop mysqld
Add log_bin_trust_function_creators = 1 to zabbix.cnf under /etc/my.cnf.d
systemctl start mysqld
systemctl start zabbix-server
Wait till the upgrade is completed:
tail -999f /var/log/zabbix/zabbix_server.log
(systemctl restart zabbix-server)
3345:20230131:105550.715 current database version (mandatory/optional): 06000000/06000010
3345:20230131:105550.715 required mandatory version: 06000000
3345:20230131:105550.715 optional patches were found
3345:20230131:105550.715 starting automatic database upgrade
3345:20230131:105550.716 [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_creators variable) [create trigger hosts_name_upper_insert
The solution is this procedure:
systemctl stop zabbix-server
systemctl stop mysqld
Add log_bin_trust_function_creators = 1 to zabbix.cnf under /etc/my.cnf.d
systemctl start mysqld
systemctl start zabbix-server
Wait till the upgrade is completed:
tail -999f /var/log/zabbix/zabbix_server.log
(systemctl restart zabbix-server)