Hello!

Currently you can use OLD_MODE: https://mariadb.com/kb/en/old-mode/

Kind regards,
Alexey.

Currently MariaDB 10.6 is not supported by Zabbix. See https://www.zabbix.com/documentation/current/manual/installation/requirements#required_software for more details.

Resolved in features/ZBXNEXT-6820

Released ZBXNEXT-6820 in:

• pre-5.0.16rc1 b3c0264f89
• pre-5.4.5rc1 75444d3bb8
• pre-6.0.0alpha2 696f6d4775

Documentation updated:

• What's new in 5.0.16
• What's new in 5.4.5
• Requirements in 5.4 and 6.0

Hi

i have also already written it in ZBXNEXT-6850
Apparently the zabbix-proxy in version 5.0.17 does not yet run cleanly with MariaDB 10.6 in utf8mb3 or utf8mb4 charset Mode.

Kind regards

EDIT: https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
https://jira.mariadb.org/browse/MDEV-8334

"The utf8mb3 character set is deprecated and you should expect it to be removed in a future MySQL release. Please use utf8mb4 instead. utf8 is currently an alias for utf8mb3...."

andris Hi again =) In ZBX-17357 we talked a lot about your great db charset/collation conversion script (https://www.zabbix.com/documentation/current/manual/appendix/install/db_charset_coll)).
With the help of this script, we switched to utf8 & utf8_bin for the Zabbix 5.x era.

It seems that with Zabbix 6.0+ and MariaDB 10.6+, this change won't be enough to be future proof. I feel like there will be another DB conversion necessary in the near future.

If I compare the setup instruction from Zabbix 5.4 vs 6.0, we can clearly see a change in the charset/collation command.
(https://www.zabbix.com/documentation/5.4/manual/appendix/install/db_scripts VS. https://www.zabbix.com/documentation/6.0/manual/appendix/install/db_scripts)

mysql> create database zabbix character set utf8 collate utf8_bin;
VS.
mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;

Add this to the notes gerry just posted above me, that utf8 (aka utf8mb3) will be deprecated and we all might have a lot of work to do.

So my questions are:

1. Will Zabbix provide a second conversion script, to continue the work you have already started? You helped us to switch from the old 2.x standards, to the new 5.x standards. Now seems to be the time to provide a script to convert from 5.x to 6.x DB standards, and to be future proof for upcoming MySQL and MariaDB changes. Because otherwise, Zabbix 6.4 (or any other future version) might switch it's recommended MariaDB version to 10.7 or 10.8 (or any other future version) and utf8 (aka utf8mb3) would stop working suddenly?
2. Or can we just use the very same script, and change utf8 to utf8mb4 & utf8_bin to utf8mb4_bin and let it run once more?

Thank you very much for feedback. I have the strong feeling, this will become a big topic, as soon as Zabbix and MySQL/MariaDB remove the deprecated ut8 support.

(Maybe this topic needs a separate ZBX issue?)