Plugin check_mssql.sh

[Giliardo Carlos Freitas]

Tom, 

I solve the problem, but i dont discover the cause of the problem. I change 
the follows lines in the check_mssql.sh 

tsqlcmd=`which tsql`
catcmd=`which cat`
grepcmd=`which grep`
rmcmd=`which rm`
... 

to 

tsqlcmd="/usr/local/bin/tsql"
catcmd=`which cat`
grepcmd=`which grep`
rmcmd=`which rm`
... 

When i use tsqlcmd=`which tsql` the variable below that line dont keep ours 
values(i debuged them), but if i change the line to 
tsqlcmd="/usr/local/bin/tsql" all variables work fine.Very strange, no? 


Giliardo 


Tom Welsh writes: 

>  
> 
> Hi Gillardo, 
> 
> Can you post the command line you are using from shell and the output and
> also your nagios check_command for your mssql check. 
> 
> Cheers 
> 
> Tom 
> 
> -----Original Message-----
> From: nagios-users-admin at lists.sourceforge.net
> [mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Giliardo
> Carlos Freitas
> Sent: 15 June 2004 18:57
> To: Tom Welsh
> Cc: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] Re: Plugin check_mssql.sh 
> 
> Hi Tom,  
> 
> I executed the plugin as nagios user and as root user, both in shell and 
> both work fine. But in the nagios(web) the script don't work. I pretended 
> that the variables in the script do not keep our values when the script is 
> executed in nagios(web). I tried change the permissions, but the problem has 
> 
> go on.  
> 
> Giliardo  
> 
> Tom Welsh writes:  
> 
>> Hi Gillardo,  
>> 
>> Are you executing the plugin on the command line as the Nagios user? If
> not
>> that will be why it works one place and not the other.  
>> 
>> Cheers  
>> 
>> Tom Welsh  
>> 
>>   
>> 
>> -----Original Message-----
>> From: nagios-users-admin at lists.sourceforge.net
>> [mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Giliardo
>> Carlos Freitas
>> Sent: 15 June 2004 14:24
>> To: nagios-users at lists.sourceforge.net
>> Subject: [Nagios-users] Plugin check_mssql.sh  
>> 
>> Hello!   
>> 
>> I am using puglin check_mssql.sh to verify the status of a MS SqlServer. 
>> When i execute the plugin in the shell i get the follow message:   
>> 
>> 
>>>> OK - MS SQL Server 2000 has 21 user(s) connected: 9 xxxx, 1 xxxx, 2 xxx,
>> 1 sa, 4 xxx, 2 xxxx, 2 xxx.  
>> 
>> But in Nagios i get the follow message:   
>> 
>> 
>>>> OK - MS SQL Server 2000 has 0 user(s) connected.
>> 
>> This occur in all servers i tested. In nagios the number of users
> connected 
>> is not correct. Someone can help me?   
>> 
>> Giliardo   
>> 
>>   
>> 
>> -------------------------------------------------------
>> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
>> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
>> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
>> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
>> _______________________________________________
>> 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  
>> 
>>   
>> 
>   
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> 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 
> 
>  
> 
>  
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> 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
 


-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
_______________________________________________
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