Nagios and SQL databases

[Paul Bourgeau]

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