[hobbit] dbcheck.pl + MsSQL monitoring

[Eric Meddaugh]

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:linuxmasterjedi at free.fr] 
Sent: Tuesday, December 04, 2007 07:41
To: hobbit at hswn.dk
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 ?


To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk