The lines are:<br><br><span style="font-family:courier new,monospace"># $data_source="DBI:Sybase:host=$dbhost;port=$port;encryptPassword=1";</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace"> $data_source="DBI:Sybase:server=$dbhost;port=$port;encryptPassword=1";</span><br style="font-family:courier new,monospace">
<br>host= use hostname (doesn't seem to work in my setup)<br>server= use freetds config<br><br>Steve<br><br><br><br><div class="gmail_quote">On 27 February 2012 15:19, Venkatesh Subbaramu <span dir="ltr"><<a href="mailto:Venkatesh_S04@infosys.com">Venkatesh_S04@infosys.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks Steve .The line numbers in my code is a bit off as I had added a couple of lines to include libraries in the start of the code .Could you please provide the code in 1169 that needs to be commented .I am attaching the screen shot <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><img src="cid:image001.png@01CCF591.3DD6C490" height="800" width="1280"></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Steven Carr [mailto:<a href="mailto:sjcarr@gmail.com" target="_blank">sjcarr@gmail.com</a>] <br>
<b>Sent:</b> Monday, February 27, 2012 8:33 PM<br><b>To:</b> Venkatesh Subbaramu<br><b>Cc:</b> <a href="mailto:xymon@xymon.com" target="_blank">xymon@xymon.com</a><br><b>Subject:</b> Re: [Xymon] Xymon SQL Server dbcheck error<u></u><u></u></span></p>
</div><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="margin-bottom:12.0pt">Found the issue, lines 1169 and 1170 in <a href="http://dbcheck.pl" target="_blank">dbcheck.pl</a> - hash out 1169 and unhash 1170.<br>
<br>Default setup is to connect to a host instead of using the freetds.conf settings.<br><br>Steve<br><br><br><u></u><u></u></p><div><p class="MsoNormal">On 27 February 2012 13:07, Venkatesh Subbaramu <<a href="mailto:Venkatesh_S04@infosys.com" target="_blank">Venkatesh_S04@infosys.com</a>> wrote:<u></u><u></u></p>
<div><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I have been getting the following message when trying to monitor SQL Server </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Venky</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:13.5pt">Mon Feb 27 16:40:15 2012 OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (44)</span></b><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Server , database </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Message String: Server name not found in configuration files.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (45)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Server , database </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Message String: Unknown host machine name.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><a href="http://dbcheck.pl" target="_blank">dbcheck.pl</a> version 1.09 - column ChkConn lifetime 60, tested in ~ 00:00:10 (max 00:00:20)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">The following are the contents of the configurationfiles</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:16.0pt;font-family:"Courier New"">Hosts.cfg</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">group Operating system</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">10.66.106.319 dossf_syb # bbd <a href="http://dossf_syb/" target="_blank">http://dossf_syb/</a></span><u></u><u></u></p><p class="MsoNormal">
<span style="font-size:10.0pt;font-family:"Courier New"">10.66.106.91 infy-x08vcanbsp</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">group SQL Server</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">10.66.106.91 SQLDB # noconn dbcheck NS:win-xp</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">DBCheck.ini</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"># Sql server definition using the default password defined in default section</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">[SQLDB]</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">dbtype = SQLServer</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">hostname = SQLDB</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">port = 1041</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">username = uid</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">password = Kolaveri</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ftds.conf</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"># A typical Sybase server</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">[SQLDB]</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> host = 10.66.106.91</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> port = 1041</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> tds version = 7.0</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span><u></u><u></u></p>
</div></div><table border="0" cellpadding="0"><tbody><tr><td style="background:white;padding:.75pt .75pt .75pt .75pt"><pre><span style>**************** CAUTION - Disclaimer *****************<u></u><u></u></span></pre><pre>
<span style>This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely <u></u><u></u></span></pre><pre><span style>for the use of the addressee(s). If you are not the intended recipient, please <u></u><u></u></span></pre>
<pre><span style>notify the sender by e-mail and delete the original message. Further, you are not <u></u><u></u></span></pre><pre><span style>to copy, disclose, or distribute this e-mail or its contents to any other person and <u></u><u></u></span></pre>
<pre><span style>any such actions are unlawful. This e-mail may contain viruses. Infosys has taken <u></u><u></u></span></pre><pre><span style>every reasonable precaution to minimize this risk, but is not liable for any damage <u></u><u></u></span></pre>
<pre><span style>you may sustain as a result of any virus in this e-mail. You should carry out your <u></u><u></u></span></pre><pre><span style>own virus checks before opening the e-mail or attachment. Infosys reserves the <u></u><u></u></span></pre>
<pre><span style>right to monitor and review the content of all messages sent to or from this e-mail <u></u><u></u></span></pre><pre><span style>address. Messages sent to or from this e-mail address may be stored on the <u></u><u></u></span></pre>
<pre><span style>Infosys e-mail system.<u></u><u></u></span></pre><pre><span style>***INFOSYS******** End of Disclaimer ********INFOSYS***<u></u><u></u></span></pre></td></tr></tbody></table><p class="MsoNormal" style="margin-bottom:12.0pt">
<br>_______________________________________________<br>Xymon mailing list<br><a href="mailto:Xymon@xymon.com" target="_blank">Xymon@xymon.com</a><br><a href="http://lists.xymon.com/mailman/listinfo/xymon" target="_blank">http://lists.xymon.com/mailman/listinfo/xymon</a><u></u><u></u></p>
</div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></blockquote></div><br>