Check database query by JDBC connection on Oracle, MySQL and SqlServer

1. Introduction

I've develped my own Nagios CheckByJdbc plugin allows you to check a SQL query from a script file on database ( Oracle, Microsoft SqlServer, Mysql ) by a JDBC connection.

2. Download Plugin

Download plugin here:

• https://bitbucket.org/josemarsilva/checkbyjdbc

3. Installing Plugin

Unzip CheckByJdbc.zip and follow 'read-me.txt'  instructions

Your command.cfg should be like this

# 'check_by_jdbc' command definition
define command{
             command_name    check_by_jdbc
             command_line    java -cp $USER1$/CheckByJdbc/.:$USER1$/CheckByJdbc/$ARG1$ CheckByJdbc -d $ARG2$ -H $ARG3$ -p $ARG4$ -s $ARG5$ -l $ARG6$ -x $ARG7$ -m $ARG8$ -f $USER1$/CheckByJdbc/$ARG9$ -R "$ARG10$" -w $ARG11$ -c $ARG12$ -M "$ARG13$" -v $ARG14$
             }

Your localost.cfg should be like this:

# define a service to be checked by CheckByJdbc

define service{

        use                             local-service

        host_name                       vmwsrv01

        service_description             CheckByJdbc Oracle Tablespaces

        check_command                   check_by_jdbc!classes12.jar!orcl!192.168.133.2!1521!orcl!nagios!nagios!f!sqlfile1.sql!!80!90!CheckByJdbcTablespaces!0

        check_interval                  1

        retry_interval                  1

       }

define service{

        use                             local-service

        host_name                       vmwsrv01

        service_description             CheckByJdbc Oracle Invalid Objects

        check_command                   check_by_jdbc!classes12.jar!orcl!192.168.133.2!1521!orcl!nagios!nagios!f!sqlfile2.sql!&OWNERLIST='MANAGER','RM'!0!0!CheckByJdbc Invalid Objects!0

        check_interval                  1

        retry_interval                  1

       }

define service{

        use                             local-service

        host_name                       vmwsrv01

        service_description             CheckByJdbc Oracle LongTimeUserQuery

        check_command                   check_by_jdbc!classes12.jar!orcl!192.168.133.2!1521!orcl!nagios!nagios!f!sqlfile3.sql!!300!900!CheckByJdbc OrclLongTimeUserQuery!0

        check_interval                  15

        retry_interval                  15

       }

4. References

• http://exchange.nagios.org/directory/Plugins/Databases/CheckByJdbc/details