Zabbix Agent can't connect to local MySQL server

[DaveyKL]

Hello, We are trying to get Zabbix and MySQL monitoring working, but we ran into some problems. It did the following steps:

1. Created a template
2. Created a item in zabbix and added a key like mysql.uptime
3. Added a include in the agent like this:

Include=/etc/zabbix/zabbix_agentd.userparams.conf

4. Added in zabbix_agentd.userparams.conf te following lines:

UserParameter=mysql.uptime,mysqladmin -u zabbix --password=(Password) status | cut -f2 -d ":" | cut -f1 -d "T" | tr -d " "

5. Added in $HOME/.my.cnf the following lines:

[client]
user                           = zabbix
password                       = (Password)
port                           = 3306

6. Added a graph based on the item.

But I get the following error in /var/log/zabbix:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/srv/mysql/data/mysql.sock' (13)

This usually means that the mysql server can not be connect. But if I login on the MySQL and try to login like this: mysql -uzabbix -p(Password) I can connect to the MySQL server succesfully.

Also if I run this command in the command line I get a valid response.

mysqladmin -u zabbix --password=(Password) status | cut -f2 -d ":" | cut -f1 -d "T" | tr -d " "

Reponse:

5052

Did I miss something? Thank you in advance.

[jan.garaj]

IMHO: you mix 2 DB connections:
1.) Zabbix agent (maybe server)
You can see in your zabbix log:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/srv/mysql/data/mysql.sock' (13)

So check DB setting of your agent or server. It looks that you didn't configure DB.

2.) UserParameter MySQL connection
When you solve 1.), then I hope, that also your UserParameter items will be collected by Zabbix without problem

[DaveyKL]

I resolved my problem. The zabbix local user (what the Zabbix Agent use) couldn't get access to /srv/mysql/data/ because of the permissions. You can fix this to set the right permission to this folder.