Failure to import initial schema and data

[VV666]

Hello, I'm following this documentation : https://www.zabbix.com/download?zabb...uster&db=mysql

I'm blocking at step C : "On Zabbix server host initial import schema and data. You will be prompted to enter your newly created password."

$ zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix2 -p zabbix
Enter password:
ERROR 1071 (42000) at line 357: Specified key was too long; max key length is 1000 bytes

All I find as a solution on the Internet is to change the snack to ut8_bin, but it's already the case.
Why do I have this error?

I'm running Debian 10 and MariaDB 10.3.27.
Thank you, Best.

[Patacas]

Hello, I'm following this documentation : https://www.zabbix.com/download?zabb...uster&db=mysql

I'm blocking at step C : "On Zabbix server host initial import schema and data. You will be prompted to enter your newly created password."

$ zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix2 -p zabbix
Enter password:
ERROR 1071 (42000) at line 357: Specified key was too long; max key length is 1000 bytes

All I find as a solution on the Internet is to change the snack to ut8_bin, but it's already the case.
Why do I have this error?

I'm running Debian 10 and MariaDB 10.3.27.
Thank you, Best.

The problem is in the way you created the database, for sure you put something like this "create database data_zabbix character set utf8mb4 collate utf8mb4_bin;"
You must use the utf8 collate utf8_bin so that the import of the schema work.

SOLUCION:
create database database_zabbix character set utf8 collate utf8_bin;


Best regrads,
LM