Databases

check_odbc

Write a Review

Description:

Is no longer supported, download is deprecrated.

Current Version

1.20101228b1

Last Release Date

2010-12-28

Compatible With

  • Nagios 3.x

Owner

Joerg Hoerter

License

GPL

Copy Page Link Recommend Contact Owner Login to Add to Favorites Login to Claim
Nagios CSP

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.

Download Now

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!
Project Notes
ODBC Nagios Check Plugin This program is free software; you can redistribute it under the GNU General Public License. Written by Joerg Hoerter (jh at jhoerter dot com), 2010 This program is a ODBC Nagios check plugin for use with NRPE_NT. Program: check_odbc.exe [PREFERENCEGROUP] -h Help -d Debug mode (test sql and create check_odbc.ini with new preference groups) check_db.ini [PREFERENCEGROUP] DB=DBNAME LOGIN=LOGINNAME PASSWORD=PASSWORD SQL=SQLSTRING (f.e. select count(nr) from table where a=1) INFOSQL=SQLSTRING (f.e. select a as Nr, b as Error from table where a=1) (Serviceoutput max 9999 lines and 9999 colums) INFOSQLCOLUM=y (y=print Colum name) WARN=WARNING >=count(nr) and =count(nr) example Serviceoutput: SQL CRITICAL - query = 2
0001 [Nr: 1 Error: Text1]
0002 [Nr: 2 Error: Text2]|'query'=1;0;1;0;0 Configuration: ============== nagios.cfg illegal_macro_output_chars=`~$&|" (without "<>" to get newline in serviceoutput) NSC.ini [NRPE_HANDLERS] check_odbc=c:/Program Files/NSCLIENT++/check_odbc.exe [PREFERENCEGROUP]
Reviews (1) Add a Review
Error in nagios Server
by kordoch, October 31, 2017
The script works fine on windows, but on the Nagios server it always gives "SQL CRITICAL - can't open db *****

some help please?
Helpful?    
Report
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Notes Reviews
Project Stats
Rating
4 (2)
Favorites
0
Views
102,684