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

[Tom DE BLENDE (GCC)]

I don't get how you go about that. ports have to be described in 
freetds.conf, no? Anyway, try what I posted and verify freetds.conf.

Alexander Brian C wrote:

>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.
>
>
>=====
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by:
>Sybase ASE Linux Express Edition - download now for FREE
>LinuxWorld Reader's Choice Award Winner for best database on Linux.
>http://ads.osdn.com/?ad_idU88&alloc_id065&op=click
>_______________________________________________
>Nagiosplug-help mailing list
>Nagiosplug-help at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/nagiosplug-help
>::: Please include plugins version (-v) and OS when reporting any issue. 
>::: Messages without supporting info will risk being sent to /dev/null
>
>
>  
>