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

[Alexander Brian C]

I forgot to mention that I added at port variable into the mix here.  I
have a few boxes on non-standard ports that I'm using the port setting
to be able to monitor with the same script.

Take a look at the command line version and you'll see that it works
correctly.  Will Nagios not accept changes to the script like this?
 

-----Original Message-----
From: Tom DE BLENDE (GCC) [mailto:Tom.DeBlende at dhl.com] 
Sent: Thursday, October 28, 2004 1:58 AM
To: Alexander Brian C
Cc: nagiosplug-help at lists.sourceforge.net
Subject: Re: [Nagiosplug-help] check_mssql.sh - (No output returned from
plugin)

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




-----This electronic message transmission, including any attachments, contains information from Covantage which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited.

If you have received this electronic transmission in error, please notify the sender immediately by a "reply to sender only" message and destroy all electronic and hard copies of the communication, including attachments.


=====