Hello,

With the current readme for zabbix server, it creates the MySQL database with "character set utf8", but this throws an error in zabbix "Unsupported charset or collation for tables".
This should be changed to "character set utf8mb4 collate utf8mb4_bin"
Patch attached

Best Regards
--- zabbix-server.old	Wed Sep 11 16:24:10 2024
+++ zabbix-server	Wed Sep 11 16:24:35 2024
@@ -47,7 +47,7 @@
 
     $ mysql -u root -p
     MariaDB [(none)]> create user zabbix@localhost identified by 'password';
-    MariaDB [(none)]> create database zabbix character set utf8;
+    MariaDB [(none)]> create database zabbix character set utf8mb4 collate utf8mb4_bin;
     MariaDB [(none)]> grant all privileges on zabbix.* to zabbix@localhost;
     MariaDB [(none)]> quit
 

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to