<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Check_mssql.sh problem running in Nagios but runs fine on command line</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">When I try to run the plugin from a command prompt, it executes fine:</FONT>
<BR><FONT SIZE=2 FACE="Arial">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"</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Here's the relevant entry in checkcommands.cfg:</FONT>
<BR><FONT SIZE=2 FACE="Arial"># 'check_mssql.sh' command definition</FONT>
<BR><FONT SIZE=2 FACE="Arial">define command{</FONT>
<BR><FONT SIZE=2 FACE="Arial"> command_name check_mssql.sh</FONT>
<BR><FONT SIZE=2 FACE="Arial"> command_line $USER1$/check_mssql.sh $HOSTADDRESS$ username userpassword</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here's the relevant entry in services.cfg:</FONT>
<BR><FONT SIZE=2 FACE="Arial"># Service definition</FONT>
<BR><FONT SIZE=2 FACE="Arial">define service{</FONT>
<BR><FONT SIZE=2 FACE="Arial"> use my-template</FONT>
<BR><FONT SIZE=2 FACE="Arial"> host_name myservername</FONT>
<BR><FONT SIZE=2 FACE="Arial"> service_description SQL Connectivity</FONT>
<BR><FONT SIZE=2 FACE="Arial"> max_check_attempts 1</FONT>
<BR><FONT SIZE=2 FACE="Arial"> check_command check_mssql.sh</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
</P>
<BR>
<P><FONT COLOR="#808000" FACE="Arial">- Rim</FONT>
</P>
<P><FONT COLOR="#808000" FACE="Arial">Rimbert Rivera</FONT>
<BR><FONT COLOR="#808000" FACE="Arial">Manager, Information Technology</FONT>
<BR><FONT COLOR="#808000" FACE="Arial">COMTEX News Network</FONT>
<BR><FONT COLOR="#808000" FACE="Arial">rrivera@comtex.com</FONT>
<BR><FONT COLOR="#808000" FACE="Arial">(703) 820-2000</FONT>
<BR><FONT COLOR="#808000" FACE="Arial">Discover more about COMTEX at: </FONT><A HREF="http://www.comtex.com/"><U></U><U><FONT COLOR="#0000FF" FACE="Arial">http://www.comtex.com/</FONT></U></A>
<BR><FONT COLOR="#808000" FACE="Arial">This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material from any computer.</FONT></P>
</BODY>
</HTML>