Xymon SQL Server dbcheck error

5 messages in this thread

list Venkatesh Subbaramu · Mon, 27 Feb 2012 18:37:26 +0530 ·

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***

list Steven Carr · Mon, 27 Feb 2012 15:03:12 +0000 ·

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

▸ quoted from Venkatesh Subbaramu



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***

list Venkatesh Subbaramu · Mon, 27 Feb 2012 20:49:04 +0530 ·

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 01CCF591.3DD6C490]

From: Steven Carr [mailto:user-923b20c0d620@xymon.invalid]
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<http://dbcheck.pl>; - hash out 1169 and unhash 1170.

▸ quoted from Steven Carr


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<mailto: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<http://dbcheck.pl>; version 1.09 - column ChkConn lifetime 60, tested in ~ 00:00:10 (max 00:00:20)

▸ quoted from Steven Carr



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***

Attachments (1)

attachment.png image/png · 58.8 KB

list Steven Carr · Mon, 27 Feb 2012 15:28:53 +0000 ·

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

▸ quoted from Venkatesh Subbaramu



On 27 February 2012 15:19, Venkatesh Subbaramu <user-836ee4520eff@xymon.invalid>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:user-923b20c0d620@xymon.invalid]
*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 <user-836ee4520eff@xymon.invalid>

▸ quoted from Venkatesh Subbaramu

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*******


** **

list Venkatesh Subbaramu · Tue, 28 Feb 2012 10:51:35 +0530 ·

Thanks Steve ! That did the trick .

You are great , as always !

Regards,
Venkatesh

▸ quoted from Steven Carr


From: Steven Carr [mailto:user-923b20c0d620@xymon.invalid]
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 <user-836ee4520eff@xymon.invalid<mailto:user-836ee4520eff@xymon.invalid>> 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]

▸ quoted from Steven Carr


From: Steven Carr [mailto:user-923b20c0d620@xymon.invalid<mailto:user-923b20c0d620@xymon.invalid>]
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 <user-836ee4520eff@xymon.invalid<mailto: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<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 SQL Server dbcheck error 🔗 link

Xymon SQL Server dbcheck error