I am trying to set up a zabbix server, but I get an error when importing the database as follows：
# cat /usr/share/zabbix-sql-scripts/mysql/proxy.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix_proxy
Enter password:
ERROR 1071 (42000) at line 8: Specified key was too long; max key length is 767 bytes
Later, when I try to start zabbix-proxy.service, it fails to start.
The following message was recorded in the zabbix logs.
[Z3005] query failed: [1146] Table 'zabbix_proxy.users' doesn't exist [select userid from users limit 1]
cannot use database "zabbix_proxy": database is not a Zabbix database
So, how should I solve this problem at the moment?
# cat /usr/share/zabbix-sql-scripts/mysql/proxy.sql | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix_proxy
Enter password:
ERROR 1071 (42000) at line 8: Specified key was too long; max key length is 767 bytes
Later, when I try to start zabbix-proxy.service, it fails to start.
The following message was recorded in the zabbix logs.
[Z3005] query failed: [1146] Table 'zabbix_proxy.users' doesn't exist [select userid from users limit 1]
cannot use database "zabbix_proxy": database is not a Zabbix database
So, how should I solve this problem at the moment?
Attached Files