[ZBX-12248] mysql.ping does not detect when mysql is down Created: 2017 Jun 01  Updated: 2017 Nov 01  Resolved: 2017 Nov 01

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G)
Affects Version/s: 3.2.6
Fix Version/s: None

Type: Problem report Priority: Minor
Reporter: Thomas MICHEL Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS 7.3

Issue Links:
Duplicate
duplicates ZBXNEXT-2410 userparameter_mysql.conf: mysql.ping ... Confirmed
is duplicated by ZBX-12969 Agent user scripts merging stderr wit... Closed

 Description   

the mysql.ping item from the template MySQL App does not do the job when MySQL is down.

The reason invoked is: Can't connect to MySQL server on '127.0.0.1' (111)'Check that mysqld is running on 127.0.0.1 and that the port is 3306.You can check this by doing 'telnet 127.0.0.1 3306

I try to monitor my MySQL instance through a TCP connection, not by socket, because it's running in a docker container.

How to solve this :
In the /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf, provided by the RPM package, the check command should the "-s" argument.

Original input:
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
Fixed input
UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin -s ping | grep -c alive

 Comments   
Comment by Manus Freedom [ 2017 Sep 19 ]

The command must be success, so must be:

UserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin -s ping | grep -c alive || true

Generated at Tue May 13 08:47:30 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.