Page 2 of 2

Re: Status is showing Unknown when monitoring MySQL 5.7

Posted: Thu Jun 14, 2018 12:13 pm
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

Re: Status is showing Unknown when monitoring MySQL 5.7

Posted: Thu Jun 14, 2018 12:19 pm
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

Re: Status is showing Unknown when monitoring MySQL 5.7

Posted: Thu Jun 14, 2018 1:40 pm
by scottwilkerson
Ok, so this show that the plugin is working.

Are you sure your MySQL server is in a replication group?

Re: Status is showing Unknown when monitoring MySQL 5.7

Posted: Sun Jun 17, 2018 8:12 am
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.