Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
check_mysql_count
Current Version
0.02
Last Release Date
2011-11-21
Compatible With
- Nagios 2.x
- Nagios 3.x
Owner
License
GPL
Hits
104363
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
Check row count in table. Possible to specify WHERE conditionals and CRIT and WARN count.
Reviews (1)
This script has fulfilled a check we need so I thought I'd share a slight addition:
after the line
$status = "Rows $state - $count rows\n";
add
if ($count =~ m/\D/) { $state = "CRITICAL"; $status = "$count \n"; }
This returns the MySql error (if there is one) rather than just returning OK when unable to connect to the server or the check is not correct...
Also the condition needs to be an escaped string - ie.
host=\"localhost\" or if using NagiosQL to configure Nagios: host=\\\"localhost\\\"
after the line
$status = "Rows $state - $count rows\n";
add
if ($count =~ m/\D/) { $state = "CRITICAL"; $status = "$count \n"; }
This returns the MySql error (if there is one) rather than just returning OK when unable to connect to the server or the check is not correct...
Also the condition needs to be an escaped string - ie.
host=\"localhost\" or if using NagiosQL to configure Nagios: host=\\\"localhost\\\"
