diff options
Diffstat (limited to 'contrib')
-rwxr-xr-x | contrib/check_mssql.sh | 81 |
1 files changed, 81 insertions, 0 deletions
diff --git a/contrib/check_mssql.sh b/contrib/check_mssql.sh new file mode 100755 index 00000000..048da720 --- /dev/null +++ b/contrib/check_mssql.sh | |||
@@ -0,0 +1,81 @@ | |||
1 | #!/bin/sh | ||
2 | # This script is designed to be used by Nagios. It checks for the availability of both Microsoft SQL Server 7 and 2000. | ||
3 | # | ||
4 | # Requirements: | ||
5 | # | ||
6 | # Sqsh (http://www.sqsh.org/) | ||
7 | # FreeTDS (http://www.freetds.org/) | ||
8 | # | ||
9 | # It was written by Tom De Blende (tom.deblende@village.uunet.be) in 2003. | ||
10 | # | ||
11 | # Version 1.0. | ||
12 | # Version 1.1: rewritten the initial script so that it not only works from the CLI but also from within Nagios. Always helpful... | ||
13 | # | ||
14 | # You might want to change these values: | ||
15 | |||
16 | sqshcmd="/usr/local/bin/sqsh" | ||
17 | catcmd=`which cat` | ||
18 | grepcmd=`which grep` | ||
19 | rmcmd=`which rm` | ||
20 | mktempcmd=`which mktemp` | ||
21 | wccmd=`which wc` | ||
22 | sedcmd=`which sed` | ||
23 | trcmd=`which tr` | ||
24 | |||
25 | ################################################################################################################### | ||
26 | |||
27 | |||
28 | hostname=$1 | ||
29 | usr=$2 | ||
30 | pswd=$3 | ||
31 | srv=$4 | ||
32 | |||
33 | |||
34 | if [ ! "$#" == "4" ]; then | ||
35 | echo -e "\nYou did not supply enough arguments. \nUsage: $0 <host> <username> <password> <version> \n \n$0 checks Microsoft SQL Server connectivity. It works with versions 7 and 2000.\n\nYou need a working version of Sqhs (http://www.sqsh.org/) and FreeTDS (http://www.freetds.org/) to connect to the SQL server. \nIt was written by Tom De Blende (tom.deblende@village.uunet.be) in 2003. \n\nExample:\n $0 dbserver sa f00bar 2000\n" && exit "3" | ||
36 | |||
37 | elif [ $sqshcmd == "" ]; then | ||
38 | echo -e "Sqsh not found! Please verify you have a working version of Sqsh (http://www.sqsh.org/) and enter the full path in the script." && exit "3" | ||
39 | |||
40 | fi | ||
41 | |||
42 | exit="3" | ||
43 | |||
44 | |||
45 | # Creating the command file that contains the sql statement that has to be run on the SQL server. Normally one would use the -C parameter of sqsh, but it seems that there is a bug that doesn't allow statements with more than one blanc. | ||
46 | |||
47 | tmpfile=`$mktempcmd /tmp/$hostname.XXXXXX` | ||
48 | |||
49 | if [ $srv == "7" ]; then | ||
50 | spid=7 | ||
51 | elif [ $srv == "2000" ]; then | ||
52 | spid=50 | ||
53 | else | ||
54 | echo -e "$srv is not a supported MS SQL Server version!" && exit "3" | ||
55 | fi | ||
56 | |||
57 | echo -e "select loginame from sysprocesses where spid > $spid order by loginame asc\ngo" > $tmpfile | ||
58 | |||
59 | |||
60 | # Running sqsh to get the results back. | ||
61 | |||
62 | resultfile=`$mktempcmd /tmp/$hostname.XXXXXX` | ||
63 | $sqshcmd -S $hostname -U $usr -P $pswd -w 100000 -i $tmpfile -o $resultfile 2>/dev/null | ||
64 | |||
65 | if [ ! -s $resultfile ]; then | ||
66 | $rmcmd -f $tmpfile $resultfile; | ||
67 | echo CRITICAL - Could not make connection to SQL server.; | ||
68 | exit 2; | ||
69 | else | ||
70 | nmbr=`$catcmd $resultfile | $grepcmd -v "\-\-\-\-\-" | $grepcmd -v "loginame" | $grepcmd -v "affected" | $sedcmd '/^$/d' | $sedcmd 's/ //g' | $wccmd -l | sed 's/ //g'`; | ||
71 | users=`$catcmd $resultfile | $grepcmd -v "\-\-\-\-\-" | $grepcmd -v "loginame" | $grepcmd -v "affected" | $sedcmd '/^$/d' | $sedcmd 's/ //g' | $trcmd \\\n , | $sedcmd 's/,$/./g' | $sedcmd 's/,/, /g'`; | ||
72 | $rmcmd -f $tmpfile $resultfile; | ||
73 | echo "OK - MS SQL Server $srv has $nmbr user(s) connected: $users" | sed 's/: $/./g'; | ||
74 | exit 0; | ||
75 | fi | ||
76 | |||
77 | # Cleaning up. | ||
78 | |||
79 | $rmcmd -f $tmpfile $resultfile | ||
80 | echo $stdio | ||
81 | exit $exit | ||