We're doing MsSQL checks (wrote our own checker). It's not much, but
all it does is checks to see what the srvname from the sysservers table
in the "master" database is set to:
select srvname from sysservers where srvid = 0
It should return the name of the server and the main DB name, so like
this:
HOSTNAME\DB_NAME
HOSTNAME is the host, and DB_NAME is the actual Database.
We run it on Solaris as a remote test and use the Sybase Perl DBD/DBI
module.
---Eric
-----Original Message-----
From: L.M.J. [mailto:user-78bb6d5d9024@xymon.invalid]
Sent: Tuesday, December 04, 2007 07:41
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] dbcheck.pl + MsSQL monitoring
Hello guys,
I'm wondering if someone already checking MsSQL databases. I'm curious
about each step to monitor it. I've installed freetds and wrote that :
[myMySQL_DB]
host = bahia.latecoere.gl.local
port = 1433
tds version = 7.0
Netapp.ini:
[myMySQL_DB]
dbtype = SQLServer
hostname = MsSQLServer1
port = 1433
username = hobbit
password = hobbitpwd
bb-hosts
group MsSQL
0.0.0.0 myMySQL_DB # noconn noping dbcheck NAME:"CE"
DESCR:"MsSQLServer1:"
But it doesn't work, I have this error :
Connection failed with unknown error for
"DBI:Sybase:host=bahia;port=1433;encryptPassword=1"!
Anyone could have an idea why ?