- Nagios Network Monitoring
- General Information and TidBits
- Installation Tips & Tricks
- Addons, Plugins, Tweaks & Customizations
- Checking Drupal Status with Nagios and WebInject
- AddOn - NRPE / NSClient
- AddOn - Nagios Event Log aka NagEventLog
- Addon - Nagios Passive Checks with NSCA
- Nagios Custom Object Variables
- Nagios Event Handler - Restart Remote Service
- Nagios Event Handler - Restarting a Local Service
- Plugin: check_dns_secondary - Checking NS Servers
- Plugin: check_http_requisites - Page Size, Files, and Loadtime
- Plugin: check_mem - Linux Memory Usage
- Plugin: check_sql - Check MSSQL and MYSQL servers
- Plugin: check_svn - Check Subversion
- Tweak - Nagios Jabber / XMPP Notifications
- Tweak - Nagios SMS Messaging
- Tweak - check_file_age to check_file_modified
- Tweak: Using NagiosGraph's SHOW.CGI
- Tweak: check_sql - Allow decimal values
- Common Errors & Fixes
Plugin: check_sql - Check MSSQL and MYSQL servers
- References:
Ref: http://www.nagiosexchange.org/cgi-bin/page.cgi?g=Detailed%2F1435.html;d=1
Written in Perl. Requires FreeTDS to be install.
This plugin can query a Microsoft SQL Server or a MySQL Server. The plugin can also execute specific queries or stored procedures and return the results based. The results can then be compared via thresholds for numeric values or via regular expressions for string values.
Here is a good example of how I used the plugin in my blog. Count Log Entries Stored Procedure and check by Nagios.
- Printer-friendly version
- Login or register to post comments
-

Recent comments
7 weeks 4 days ago
25 weeks 3 hours ago
28 weeks 20 hours ago
38 weeks 2 hours ago
45 weeks 3 days ago
45 weeks 5 days ago
50 weeks 1 day ago
1 year 1 week ago