Thanks Steve ! That did the trick . You are great , as always ! Regards, Venkatesh From: Steven Carr [mailto:sjcarr at gmail.com] Sent: Monday, February 27, 2012 8:59 PM To: Venkatesh Subbaramu Cc: xymon at xymon.com Subject: Re: [Xymon] Xymon SQL Server dbcheck error The lines are: # $data_source="DBI:Sybase:host=$dbhost;port=$port;encryptPassword=1"; $data_source="DBI:Sybase:server=$dbhost;port=$port;encryptPassword=1"; host= use hostname (doesn't seem to work in my setup) server= use freetds config Steve On 27 February 2012 15:19, Venkatesh Subbaramu <Venkatesh_S04 at infosys.com<mailto:Venkatesh_S04 at infosys.com>> wrote: 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 [cid:image001.png at 01CCF606.F06BE020] From: Steven Carr [mailto:sjcarr at gmail.com<mailto:sjcarr at gmail.com>] Sent: Monday, February 27, 2012 8:33 PM To: Venkatesh Subbaramu Cc: xymon at xymon.com<mailto:xymon at xymon.com> Subject: Re: [Xymon] Xymon SQL Server dbcheck error Found the issue, lines 1169 and 1170 in dbcheck.pl<http://dbcheck.pl> - hash out 1169 and unhash 1170. Default setup is to connect to a host instead of using the freetds.conf settings. Steve On 27 February 2012 13:07, Venkatesh Subbaramu <Venkatesh_S04 at infosys.com<mailto:Venkatesh_S04 at infosys.com>> wrote: I have been getting the following message when trying to monitor SQL Server Regards, Venky Mon Feb 27 16:40:15 2012 OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (44) Server , database Message String: Server name not found in configuration files. OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (45) Server , database Message String: Unknown host machine name. dbcheck.pl<http://dbcheck.pl> version 1.09 - column ChkConn lifetime 60, tested in ~ 00:00:10 (max 00:00:20) The following are the contents of the configurationfiles Hosts.cfg group Operating system 10.66.106.319 dossf_syb # bbd http://dossf_syb/ 10.66.106.91 infy-x08vcanbsp group SQL Server 10.66.106.91 SQLDB # noconn dbcheck NS:win-xp DBCheck.ini # Sql server definition using the default password defined in default section [SQLDB] dbtype = SQLServer hostname = SQLDB port = 1041 username = uid password = Kolaveri Ftds.conf # A typical Sybase server [SQLDB] host = 10.66.106.91 port = 1041 tds version = 7.0 **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** _______________________________________________ Xymon mailing list Xymon at xymon.com<mailto:Xymon at xymon.com> http://lists.xymon.com/mailman/listinfo/xymon