[Xymon] Xymon SQL Server dbcheck error

[Steven Carr]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20120227/de7522e0/attachment.html>