check_odbc

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 <CRIT
CRIT=CRITICAL >=count(nr)

example
Serviceoutput: SQL CRITICAL - query = 2<br>0001 [Nr: 1 Error: Text1]<br>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]