Newbie Question

[Terry Carmen]

Quoting Matty Sarro <msarro at gmail.com>:

>>> >>> Hey everyone,
>>> >>> I am still a newbie to nagios, so please bear with me. I am trying to
>>> >>> find a plugin that will monitor the contents of a particular DB table.
>>> >>> If certain status codes show up, then generate an alert. Is there
>>> >>> something available off the shelf that can do this?

FWIW, you might be looking at the wrong end of the problem.

Instead of having Nagios constantly query the database for your status codes, why don't you add a trigger on the table to do what you want when the record is updated. This could include generating a trap or notifying Nagios though another method.

It's much more efficient to work with the actual data at the source, than to keep watching from the outside.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

Terry

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110517/1d9bc002/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at 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