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?



the status of the plugin depends on the return code of the plugin, not from the output.
What are you returning on the different situations?