mySQL query help

[costanza2k1]

Hi all,

I'm trying to run a specific query given to me by one of our DBAs (I'm no DB person, not sure what I am at this point lol). Basically we have a connection between us and a vendor. We send data to the customer and they reply with an ack back. So the query we're pulling would give us a 0 or a 1, 1 is all green and good and 0 is critical meaning the bridge is down on the vendor side. Can you see if I've done something wrong with this check:

check_xi_mysql_health!--hostname=somecompany.com --port=3314 --username=user--password="password" --database=blah--mode sql --name=select%20is_bridge_up%2B0%20from%20bridge_status%20bs2%20order%20by%20last_updated_ts%20desc%20limit%201 --name2="Is Blah Bridge Up" --critical=0


for the status message when nagios xi is running this query I'm getting a 1, but the alert keeps coming back critical. Please help guide me.

[sreinhardt]

I think the critical value in this case would be the issue. Let's try changing it to "-c :0" to make it less than or equal to 0.

[costanza2k1]

Just wanted to follow up and let you know that I fixed this...the 1's and 0's from our DB and UNIX were flipped...all good!