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>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 ****
*From:* Steven Carr [mailto:sjcarr at gmail.com] *Sent:* Monday, February 27, 2012 8:33 PM *To:* Venkatesh Subbaramu *Cc:* xymon at xymon.com *Subject:* Re: [Xymon] Xymon SQL Server dbcheck error****
Found the issue, lines 1169 and 1170 in 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> 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 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 http://lists.xymon.com/mailman/listinfo/xymon****