Hi,
I want to set a nagios alert whenever the count(*) of a specific table in
test DB (MySQL) on a specific host crosses 200000 using mysql_check_query
plugin
I have referred to http://nagiosplugins.org/man/check_mysql_query for -w and
-c option
which says -w, --warning=RANGE Warning range (format: start:end). Alert if
outside this range
-c, --critical=RANGE
How can i set this in nagios(nrpe.cfg) on the remote host.
Any example would be really helpful
I have set it like the below in the nrpe.cfg file
command[check_mysql_query]=/usr/nagios/libexec/check_mysql_query -q "Select
count(*) from table" -w1:5 -H localhost -P 3306 -d test -u test -p example
command[check_mysql_query]=/usr/nagios/libexec/check_mysql_query -q "Select
count(*) from table" -c200000 -H localhost -P 3306 -d test -u test -p
example
Not sure if the above command is right.
Any ideas
Thanks and Regards
Kaushal
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
