Check_mssql.sh problem running in Nagios but runs fine on command line

[Marc Powell]

> -----Original Message-----
> From: nagios-users-admin at lists.sourceforge.net [mailto:nagios-users-
> admin at lists.sourceforge.net] On Behalf Of Rimbert Rivera
> Sent: Monday, April 25, 2005 3:32 PM
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] Check_mssql.sh problem running in Nagios but
runs
> fine on command line
> 
> I'm trying to run check_mssql.sh in Nagios but I get "Error connecting
to
> server running on ##.##.##.##" where ##.##.##.## is the IP address of
the
> MSSQL server which is correct.
> 
> When I try to run the plugin from a command prompt, it executes fine:
> Check_mssql.sh servername username userpassword => "Users = 813 Age In
> Minutes Of Oldest User = 55390584 Max CPU User = 7192945 Max IO User =
> 214744 TotalBlocks = 0"

To start, I haven't used this plugin. However, most often discrepancies
such as this are the result of running the command as root and not as
the nagios user. Did you perform your test as the Nagios user?

> 
> Here's the relevant entry in checkcommands.cfg:
> # 'check_mssql.sh' command definition
> define command{
>         command_name    check_mssql.sh
>         command_line    $USER1$/check_mssql.sh $HOSTADDRESS$ username
> userpassword
>         }

The version of check_mssql.sh included in the 1.4 release of the plugins
appears to be different than what you are using. The error message above
isn't in the code at all and it expects 4 arguments on the command line
--

You did not supply enough arguments. 
Usage: ./check_mssql.sh <host> <username> <password> <version>

Perhaps there have been some modifications that will help you.

--
Marc


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null