Arch Linux

geekinthesticks

Member

From: England

Registered: 2011-09-21

Posts: 143

Website

[solved]Connecting to Zabbix mysql UTF8 Errors.

I have installled and configured Zabbix as per the wiki. I am getting the following errors when trying to connect to the database:

Jul 27 14:36:41 blacky.wilkesley.net zabbix_server[14986]: cannot set MySQL character set to "utf8"
Jul 27 14:36:41 blacky.wilkesley.net zabbix_server[14986]: database is down: reconnecting in 10 seconds

I dropped that database and recreated it using the latest script from Zabbix with the same result:

mysql> create database zabbix character set utf8 collate utf8_bin;

Here are the relevant bits of my.cnf;

[client]
#password       = your_password
port            = 3306
socket          = /run/mysqld/mysqld.sock
default-character-set = utf8mb4

[mysqld]
collation_server = utf8mb4_unicode_ci
character_set_client = utf8mb4
character_set_server = utf8mb4

[mysql]
no-auto-rehash
default-character-set = utf8mb4

Last edited by geekinthesticks (2017-07-28 13:22:36)

geekinthesticks

Member

From: England

Registered: 2011-09-21

Posts: 143

Website

Re: [solved]Connecting to Zabbix mysql UTF8 Errors.

Somehow the setup hadn't put the password for the mysql server in zabbix_server.conf!