Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_odbc
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!
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
CRIT=CRITICAL >=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]
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
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)
bykordoch, October 25, 2017
The script works fine on windows, but on the Nagios server it always gives "SQL CRITICAL - can't open db *****
some help please?
some help please?