Nagios Support Forum

Dear Team,

I tried to monitor MySQL 5.7 but the Status is Unknow and all are working as expected.

Nagios Core is installed in CentOS 7 with check_mysql_health plugin.

Command.cfg file

define command{
command_name check_mysql_health
command_line $USER1$/check_mysql_health -H $ARG4$ --username $ARG1$ --password $ARG2$ --port $ARG5$ --mode $ARG3$
}

localhost.cfg file

define service{
use local-service
host_name ubuntu
service_description MySQL slave-sql-running
check_command check_mysql_health!nagios!nagios!slave-sqlrunning!A.B.C.D!3306!
}

MySQL is installed in Ubuntu 16.04 with the check_mysql plugin.

User for nagios in MySQL
grant all privileges on *.* to 'nagios'@'Nagios-Server-IP-Address' identified by 'nagios';

Please let me know, What is wrong or need to do some extra tasks.

Thanks in advanced
Somnath Pandey

What are the results if you try running the command from the command line:

/usr/local/nagios/libexec/check_mysql_health -H A.B.C.D --username nagios --password nagios --port 3306 --mode slave-sqlrunning

Hi cdienger,

Please check the Output(error) of the /usr/local/nagios/libexec/check_mysql_health -H A.B.C.D --username nagios --password nagios --port 3306 --mode slave-sql-running

[root@localhost objects]# /usr/local/nagios/libexec/check_mysql_health -H A.B.C.D --username nagios--password nagios --port 3306 --mode slave-sql-running
CRITICAL - unable to get replication info


Firewall disable on BOTH SYSTEM

Ubuntu Client

root@Ubuntu-MySQL-Server:~# netstat -at | grep nrpe
tcp 0 0 *:nrpe *:* LISTEN
tcp6 0 0 [::]:nrpe [::]:* LISTEN

CentOS Server

[root@localhost libexec]# netstat -at | grep nrpe
tcp6 0 0 [::]:nrpe [::]:* LISTEN

Thanks
Somnath Pandey

Is the Ubuntu machine listening for remote connections on 3306?

cssp wrote:MySQL is installed in Ubuntu 16.04 with the check_mysql plugin.

check_mysql_health doesn't use additional plugins, it connects directly to the server on 3306

Hi Scottwilkerson,

root@Ubuntu-MySQL-Server:~# netstat -lnp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1269/mysqld

Also, I can able to connect MySQL server with MySQL Workbench(which is installed on my Windows 10 machine).

Please help me with this issue.

Thanks.

Can you run any of the other modes?

Hi scottwilkerson,

You want to say with other user or something different?

cssp@Ubuntu-MySQL-Server:~$ netstat -lnp | grep 3306
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

Please check and update me.

Thanks

cssp wrote:You want to say with other user or something different?

With a different mode, such as the following (changing our A.B.C.D and the username/password)

Yes, I already checked but the error is showing same.

CRITICAL - unable to get replication info

cssp wrote:Yes, I already checked but the error is showing same.

CRITICAL - unable to get replication info

It doesn't make sense that you are getting a replication info error when asking for uptime.

Are you sure this is the error you received?