I have written a simple check_mysql_query that will only ever return 1 value. It is working and I can run the check using the plugin on the remote device, however the nagios monitoring server says that the check is always in warning.
/usr/lib64/nagios/plugins/check_mysql_query -w 1 -c 1 -H localhost -u nagios -p nagiospassword -d mydb -q “select * from host where host.status = ‘Alert’”
QUERY WARNING: No rows returned
But in fact this is fine having no rows return as it means my host(s) are up. I just need to know if 1 goes into alert status, then get nagios to send a critical alert.
Is there a way that I can not set a warning value for this?