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

[Tom DE BLENDE (GCC)]

Don't get me wrong. Nagios can do all NetSaint could, and more. So yes, 
you can do the customization you suggested. However, I'd advise you to 
try the plugin as it was downloaded and see if that works before trying 
to customize it.

Alexander Brian C wrote:

>Check_mssql.sh uses tsql to do the actual check and tsql accepts a -p
>parameter to specifiy the port, so I just added that to the
>check_mssql.sh file as well as the ones below.  I'll pull it all out and
>go back to the default and see if it works.  It's a little disappointing
>that Nagios has lost Net Saint's ability to accept customizations.  It
>was one of the great things about it.
>
>-----Original Message-----
>From: Tom DE BLENDE (GCC) [mailto:Tom.DeBlende at dhl.com] 
>Sent: Friday, October 29, 2004 2:25 AM
>To: Alexander Brian C
>Cc: nagiosplug-help at lists.sourceforge.net
>Subject: Re: [Nagiosplug-help] check_mssql.sh - (No output returned from
>plugin)
>
>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
>>
>>
>> 
>>
>>    
>>
>
>
>
>
>
>-----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 Newsletter Sponsored by: Macrovision 
>For reliable Linux application installations, use the industry's leading
>setup authoring tool, InstallShield X. Learn more and evaluate 
>today. http://clk.atdmt.com/MSI/go/ins0030000001msi/direct/01/
>_______________________________________________
>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
>  
>