Hi guys,

I am trying to set zenoss to alert me if the specific field in the database 
goes to error state (defined as 3 in the particular field).
I was able to generate a successful query to the mysql database by using 
check_mysql_query Nagios plugin as follows:

[EMAIL PROTECTED] libexec]# /opt/zenoss/libexec/check_mysql_query -q 'select 
at_status from at_servers where at_server_id=1' -H ${devname} -d at -u at -p at
QUERY OK: 'select at_status from at_servers where at_server_id=1' returned 
2.000000   (the actual value in the table is just 2)

In addition to that I have setup a datapoint gathering this output to GAUGE, 
and the related threshold to alert me if it gets the output greater then 
2.000000 (2 is an OK state/ 3 is an error state for which I want to be 
alerted).  
Unfortunately it doesn't look like anything else then QUERY results obtained by 
Zencommand work. 

Per some previous postings this might be because my output contains other 
strings and not just integer.

Does anybody knows if there is an easier way to set this up? 

Any help is greatly appreciated!
  :?




-------------------- m2f --------------------

Read this topic online here:
http://community.zenoss.com/forums/viewtopic.php?p=18900#18900

-------------------- m2f --------------------



_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users

Reply via email to