From: Renaud Allard <renaud@allard.it>
Subject: net/zabbix server readme
To: ports <ports@openbsd.org>
Cc: robert@openbsd.org
Date: Wed, 11 Sep 2024 16:29:16 +0200

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