Status is showing Unknown when monitoring MySQL 5.7

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
cssp
Posts: 21
Joined: Thu May 17, 2018 10:31 pm

Re: Status is showing Unknown when monitoring MySQL 5.7

Post by cssp »

Sorry for my mistake.

Please check and update me.

[root@localhost ~]# /usr/local/nagios/libexec/check_mysql_health -H 192.168.0.116 --username nagios --password nagios --port 3306 --mode uptime
CRITICAL - database is up since 4 minutes | uptime=294s

After stop firewall, it's showing below details

[root@localhost ~]# /usr/local/nagios/libexec/check_mysql_health -H 192.168.0.116 --username nagios --password nagios --port 3306 --mode uptime
OK - database is up since 11 minutes | uptime=668s
[root@localhost ~]#

Thanks
cssp
Posts: 21
Joined: Thu May 17, 2018 10:31 pm

Re: Status is showing Unknown when monitoring MySQL 5.7

Post by cssp »

Sorry for my mistake.

[root@localhost ~]# /usr/local/nagios/libexec/check_mysql_health -H 192.168.0.116 --username nagios --password nagios --port 3306 --mode uptime
OK - database is up since 11 minutes | uptime=668s
[root@localhost ~]#

Please check and update.

Thanks
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Status is showing Unknown when monitoring MySQL 5.7

Post by scottwilkerson »

Ok, so this show that the plugin is working.

Are you sure your MySQL server is in a replication group?
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
cssp
Posts: 21
Joined: Thu May 17, 2018 10:31 pm

Re: Status is showing Unknown when monitoring MySQL 5.7

Post by cssp »

Thank you so much for your awesome support. :D

Now I can able to monitor MySQL server in most of the modes.

Sorry for the delayed replay, I just want to monitor Apache Tomcat 9 so I have done with check_tomcat.pl and its working fine. :D

Once again thank you and you can lock.
Locked