Nagios Support Forum

Box293 wrote:When testing at the command line, are you doing it as the nagios user?

Code: Select all

su nagios
/usr/lib/nagios/plugins/check_mssql_health blah blah blah

Did you try adding sudo to your command definition as I suggested? Did that help?

yes I have tried and still have the same issue...

If you are using sudo at the command line, wouldn't your command definition also need this? command_line sudo $USER1$/check_mssql_health -usename $USER3$ -password $USER4$ -server $HOSTNAME$ -mode $ARG1 -commit I noticed your command definition has -commit at the end whereas your command line examp...

Can you provide the command definition and service definition please. Also, what are you executing at the command line when it works? When testing at the command line, are you doing it as the nagios user? su nagios /usr/lib/nagios/plugins/check_mssql_health blah blah blah I use sudo /usr/lib/nagios...

Just wonder if anyone is using the failed-jobs option for the SQL monitoring? I try to use it but it gives me an error on the nagios core web interface **ePN /usr/lib/nagios/plugins/check_mssql_health: "Use of uninitialized value $params{"lastrunstatus"} in lc at (eval 1) line 1694,&q...

sreinhardt wrote:Fantastic, nice job! Do you want us to lock this one up and call it closed?

Yes please. I am good with this issue now.

Thanks!

The problem is that you command you have defined will add additional items to the command, as you see command_line $USER1/check_mssql_health -username $USER3$ - password $USER4$ -server $HOSTNAME$ -mode $ARG1$ - name $ARG2$ -commit Will get translated to something like ./check_mssql_health -usernam...

does it have to do with the space? sorry I accidentally add the space in the post. with the command in the cfg file actually there is no space.

And also, do you have any suggestions how to break this into multiple commands?

Thanks!

it looks like when I run like this it will give me the result

./check_mssql_health -password PWD -username USERNAME - server 192.168.1.x -mode locks-deadlocks

but not on the web interface, I only get the message "CRITICAL - unable to aquire lock info"

Thanks for the quick reply. The Nagios3 core is running under Ubuntu 14.04 trying to monitor the MS SQL 2008 server. the command line that I use is as follow: define command{ command_name check_mssql_health command_line $USER1/check_mssql_health -username $USER3$ - password $USER4$ -server $HOSTNAME...

Hi All,

I have some issues working with locks-deadlocks with the status information critical - unable to aquire lock info. Does anyone have set it up before?

It looks like all other SQL monitoring services are good except for all the locks. Any help will be appreciated.

Thanks!