[Nagiosplug-help] check_mssql.sh - (No output returned from plugin)

[Tom DE BLENDE (GCC)]

Hi Alexa

Alexander Brian C wrote:

>I have check_mssql.sh running fine from the command line, but I get (No
>output returned from plugin) in the status information on Nagios.  The
>status is OK, but the details are missing.
>
>Here are some details:
>
>
>COMMAND LINE: 
>
>[nagios at bugs plugins]$ check_mssql.sh hubble nagios foo 2000 1433
>OK - MS SQL Server 2000 has 15 user(s) connected:  12 covivr, 1 nagios,
>2 maj.
>  
>
No need to specify the port here. That is done in freetds.conf. So you get:

check_mssql.sh hubble nagios foo 2000

COMMAND.CFG

># 'check_mssql.sh' command definition
>define command{
>        command_name    check_mssql
>        command_line    /usr/lib/nagios/plugins/check_mssql.sh -S $ARG1$
>-U $ARG2$ -P $ARG3$ $ARG4$ -p $ARG5$
>        }
>
>  
>
Then this should look like this:

# 'check_mssql.sh' command definition
define command{
        command_name    check_mssql
        command_line    /usr/lib/nagios/plugins/check_mssql.sh $ARG1$ $ARG2$ $ARG3$ $ARG4$
        }


>SERVICES.CFG
>
>
>
>define service{
>        use                             generic-service         ; Name
>of service template to use
>
>        host_name                       hubble
>        service_description             SQL monitor
>        is_volatile                     0
>        check_period                    24x7
>        max_check_attempts              3
>        normal_check_interval           3
>        retry_check_interval            1
>        contact_groups                  admins
>        notification_interval           120
>        notification_period             24x7
>        notification_options            w,u,c,r
>        check_command
>check_mssql!hubble!nagios!foo!2000!1433
>        register                        1
>        }
>

And finally:

define service{
        use                             generic-service         ; Name
of service template to use

        host_name                       hubble
        service_description             SQL monitor
        is_volatile                     0
        check_period                    24x7
        max_check_attempts              3
        normal_check_interval           3
        retry_check_interval            1
        contact_groups                  admins
        notification_interval           120
        notification_period             24x7
        notification_options            w,u,c,r
        check_command			check_mssql!hubble!nagios!foo!2000
        register                        1
        }


Try this ;-)

Tom