using latest version of "linuxserver/mariadb" for my Zabbix.
Zabbix Server "zabbix/zabbix-server-mysql:latest" failed to updgrade Database
When i try to upgrade Zabbix to 6.2 from 6.0.5 docker i get below error in Zabbix Server log
from "Zabbix Server" Log:
---------------------
7:20220705:141509.188 completed 48% of database upgrade
7:20220705:141509.189 [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_insert after insert on hosts
for each row
insert into changelog (object,objectid,operation,clock)
values (1,new.hostid,1,unix_timestamp())]
7:20220705:141509.189 database upgrade failed
7:20220705:141509.191 database could be upgraded to use primary keys in history tables.
--------------------------------------------
im no db expert. so if anybody knows hoiw to fix this. never seen this problem before. i updated from 5.x to 6.0.5 with no trouble.