Configure UserParameter=mysql.optima,echo 'mysql_request' | mysql -N -uzabbix -p12365 | wc -l on the host 10.10.0.2 and local test like zabbix_agentd -t mysql.optima work fine:
zabbix_agentd -t mysql.optima
mysql.optima [t|54]
but from zabbix server command zabbix_get -s 10.10.0.2 -k mysql.optima returns 0 and on host 10.10.0.2 in /var/log/zabbix-agent/zabbix_agentd.log - "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)" I already create mysql user zabbix, zabbix user has 777 on /var/lib/mysql/mysql.sock file. Dont know what to do, please help.
zabbix_agentd -t mysql.optima
mysql.optima [t|54]
but from zabbix server command zabbix_get -s 10.10.0.2 -k mysql.optima returns 0 and on host 10.10.0.2 in /var/log/zabbix-agent/zabbix_agentd.log - "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)" I already create mysql user zabbix, zabbix user has 777 on /var/lib/mysql/mysql.sock file. Dont know what to do, please help.
Comment