<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<p>
Quoting Matty Sarro <msarro@gmail.com>:<br />
<br />
>>> >>> Hey everyone,<br />
>>> >>> I am still a newbie to nagios, so please bear with me. I am trying to<br />
>>> >>> find a plugin that will monitor the contents of a particular DB table.<br />
>>> >>> If certain status codes show up, then generate an alert. Is there<br />
>>> >>> something available off the shelf that can do this?<br />
<br />
<br />
FWIW, you might be looking at the wrong end of the problem.<br />
<br />
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.<br />
<br />
It's much more efficient to work with the actual data at the source, than to keep watching from the outside.<br />
<br />
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html<br />
<br />
Terry<br />
<br />
<br />
</p>
<p class="imp-signature"></p>
<p>
<br />
</p>
</body>
</html>