Ben,
There are a couple of ways to monitor a database. Using What's Up's
'TCP/IP Services Plugin', you can connect to the database server TCP port
and make sure that it at least connects. That is a good sign that it's up,
but it is not 100% certain. Because the protocol(s) spoken by the various
database server vendors are complicated (at a minimum) and not always
published, you would probably not be able to send an SQL string and receive
a valid response.
Some folks have had success setting up a web page that accesses the
database (using ASP, PHP, Cold Fusion, perl, or <insert web glue tool name
here>) and returns an HTML-based response that you can configure the What's
Up TCP/IP Services plugin to validate.
If you're a good C programmer, you could write your own plugin for What's
Up that uses ODBC to validate the database. This has always struck me as
the optimal approach, because (A) it's accurate and (B) it does not depend
on a webserver to act as the 'canary'. But, as with all good things, it's
not trivial.
--D
Duane Waddle
[EMAIL PROTECTED]
"With sufficient thrust, pigs fly just fine..." -- RFC1925
Ben Whittaker
<[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: [WhatsUp Forum] How
do I monitor an Oricale
switch.com database
08/23/01 10:28 AM
Please respond to
WhatsUp_Forum
I need to monior an Oricale database to make sure the
database stays up?
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
