Xymon Mailing List Archive search

Xymon SQL Server dbcheck error

list Steven Carr
Mon, 27 Feb 2012 15:03:12 +0000
Message-Id: <user-2a86971b8b17@xymon.invalid>

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 <user-836ee4520eff@xymon.invalid>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***