[Xymon] Xymon SQL Server dbcheck error

[Venkatesh Subbaramu]

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20120228/56c4db7d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 60212 bytes
Desc: image001.png
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20120228/56c4db7d/attachment.png>