Nagios and SQL databases
Paul Bourgeau
psbourgeau at mpccorp.com
Tue Feb 15 16:53:04 CET 2005
Thanks for the info. I was able to install SQSH just fine and I can
connect to the SQL server (and database). But now I am at a loss as to
how to translate everything into Nagios. I am not exactly sure how to
pull the Dbase values (size, users, etc...) in. Every time I try to set
the check command I get the "Return code of 127" error. This is how my
entry looks:
# 'check_mssql_DBInfoSize' command definition
define command{
command_name check_mssql_DBInfoSize
command_line $USER1$/sqsh -H $HOSTADDRESS$ -U sa -P
xxxxxxxxxx. -o .1.3.6.1.4.1.311.1.4.1.1.6.1.5 -l 'Database Info Size
(KB)'
}
I have also tried:
# 'check_mssql_DBInfoSize' command definition
define command{
command_name check_mssql_DBInfoSize
command_line $USER1$/check_mssql $HOSTADDRESS$ -o
.1.3.6.1.4.1.311.1.4.1.1.6.1.5 -l 'Database Info Size (KB)'
}
I am fairly new to dealing with SQL and I am looking to see what the
possibilities are for my customer. Any help would be appreciated.
Thank You,
Paul Bourgeau
Ph: 262-523-3300 x60279
Fx: 208-898-2371
psbourgeau at mpccorp.com
-----Original Message-----
From: Hendrik "Boomer" Baecker [mailto:b00mer at gmx.net]
Sent: Thursday, February 10, 2005 12:24 AM
To: Paul Bourgeau
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Nagios and SQL databases
Paul Bourgeau schrieb:
>I tried to search, but I did not see anything dealing with exactlly
what I needed. I know that you are able to monitor TCP ports, services
and drive utilization, but I wanted to know how (if at all) to set up
Nagios to monitor SQL databases themselves. I am currently watching the
SQL server services (mssql), but that's it.
>
>Can you monitor each individual database(size of, activity, health,
etc..)?
>
>
Yes. There exist a Nagios Plugin called "check_mssql.sh" -->
http://www.nagios.org/faqs/viewfaq.php?faq_id=156
>Can you monitor who accesses the databases, number of users?
>
>
Long time ago since I've played with it but I think with a little bit of
work you can do whatever you want with.
Hope this helps.
>I'm guessing that I just need to add entries to the checkcommand.cfg
file with SQL OID's, right? Or is there a bit more to setup?
>
>I am running ver 1.2 on redhat 8 (2.4.18-19.8.0) Any help would be
appreciated.
>
>Thanks,
>Paul
>
>Disclaimer: 9/2/2005
>
>MPC Computers is providing the following information in compliance with
federal regulations:
>
>MPC Computers, LLC
>906 E. Karcher Road
>Nampa, Idaho 83687
>1-888-224-4247
>http://www.mpccorp.com
>
>To discontinue receiving e-mail communications from MPC in the future,
please go to:
>http://www.mpccorp.com/email/manage.html and follow the instructions.
>
>
>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real
users.
>Discover which products truly live up to the hype. Start reading now.
>http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
>_______________________________________________
>Nagios-users mailing list
>Nagios-users at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/nagios-users
>::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
>::: Messages without supporting info will risk being sent to /dev/null
>
>
>
>
Disclaimer: 15/2/2005
MPC Computers is providing the following information in compliance with federal regulations:
MPC Computers, LLC
906 E. Karcher Road
Nampa, Idaho 83687
1-888-224-4247
http://www.mpccorp.com
To discontinue receiving e-mail communications from MPC in the future, please go to:
http://www.mpccorp.com/email/manage.html and follow the instructions.
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null
More information about the Users
mailing list