Nagios Support Forum

Hello,

Thanks. There is no special symbol in password and permission is also OK. I know skip-networking parameter cause this issue but I don’t remove or disable it.
I want to monitor MySQL database in Nagios with skip-networking option.

Is there a reason you want to run with "skip-networking" enabled? If the check works locally, skip-networking should not be an issue though. How is the command defined in the remote host's nrpe.cfg?

Hello,

This server is my client server and it is in production. For security purpose my customer define this option in my.cnf file.

command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -H localhost -u xyz -p user_password

since you do not want to bind to a network interface, have you specified a local unix file socket for mysql, and have you attempted to specify this in the -H parameter of check_mysql?

Hello,

Yes, You are correct....

So what happens when you use the socket file as a host parameter? Does it allow a connection or not? I would also suggest testing this locally on the nrpe server, opposed to testing via nagios server with nrpe connection.

Hello All,

Thanks... Finally, I have resolved the mentioned issue.

What was the solution? (for future forum searchers)

Hello,

Please find the Nrpe and Nagios current setting.

NRPE Setting:-
command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -H localhost -u mysql_user -p mysql_password

Nagios Setting:-
check_command check_mysql!mysql_user!mysql_password change to

check_command check_nrpe!check_mysql!mysql_user!mysql_password

and it works fine.

Thanks!