SQL Server monitoring

[Rex Wickham]

Hi Jason				



I used the check_mssql plugin from the source contrib directory.



however I found i had to change a couple of things to get it to
 work on my box.



1: In lines 20-28 the "which" commands didn't work for me. I entered
 the commands directly, and so then had to change the back ticks
 (`) to forward ticks (') otherwise it started executing these commands!



2: on line 68

$tsqlcmd -S $hostname -U $usr -P $pswd < $tmpfile 2>$errorfile >
 $resultfile

I changed this to

$tsqlcmd -H $hostname -U $usr -P $pswd -p 1433 < $tmpfile 2>$errorfile
 > $resultfile



The login you create on your SQL server will need public access
 to the Master database in order to read the sysprocesses table.



When you run the command, don't put in -H etc.

Just the host, username, password and server version (2000 or 7).
 eg: ./check_mssql.sh xxx.xxx.xxx.xxx username password 2000



Hope that helps.







- Rex Wickham (2020media)



-----------------------

This thread is located in the archive at this URL:

http://www.nagiosexchange.org/nagios-users.34.0.html?&tx_maillisttofaq_pi
1[showUid]=13788

					


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
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