cannot import schema data

[diego527]

Whenever I try to import the schema and initial data shows me this error so I get stuck on it

[Markku]

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

set global log_bin_trust_function_creators = 1;

Also, say

drop database zabbix;

in the mysql prompt after that to delete the incomplete database that was created in your process. Then import the schema again with the zcat thing.

Edit: actually start with dropping the database and then create the database and set the log_bin_trust_function_creators etc just like instructed.

Markku

[diego527]

Thank you it worked!

But I have another question, I accidentally executed the same commands again, those here:

# wget https://repo.zabbix.com/zabbix/6.0/u...u22.04_all.deb
# dpkg -i zabbix-release_6.0-4+ubuntu22.04_all.deb
# apt update
# apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent

Could it change something from the original installation?

[Markku]

No, that's fine, installing the same packages again doesn't really do anything. If there happened to be new versions released meanwhile, then it would just upgrade the packages in-place.

Markku

[diego527]

Thank you, it worked!