[Nagiosplug-devel] nagios external plugin for mysql

[Md Hasnain]

Hi William,
Thank you so much for your reply. I am sorry I couldn't explain it to
you properly. We have got some client we are monitoring them through
Nagios. Those clients are not accessible through the net(like ping) so
what we have done we cron some script into the client site which checks
the box status and database issue and trigger an email to us where
Nagios picks(our end) those emails and check the status information and
alert us if something critical. For mailserver status it sends a email
heartbeat(every 5 mins) to Nagios which has a refreshment check period
which means if we don't receive any emails for certain mins it triggers
a critical alert that heartbeat hasn't received(box down or mailserver
down). 
We want some sort of scripts which will check every critical view of
mysql(although I am not a mysql person) and send us email from the
client end. From our end we will check the email through a postfix and
perl script and submit a status info to Nagios to trigger alert. 
So I am looking for a script which will sit into external client in
mysql server (under vpn) and send us alert accordingly. 

Thanks,
Hasnain

-----Original Message-----
From: nagiosplug-devel-bounces at lists.sourceforge.net
[mailto:nagiosplug-devel-bounces at lists.sourceforge.net] On Behalf Of
william(at)elan.net
Sent: Monday, 14 May 2007 5:49 PM
To: Nagios Plugin Development Mailing List
Subject: Re: [Nagiosplug-devel] nagios external plugin for mysql

On Mon, 14 May 2007, Md Hasnain wrote:

> Hi guyz,
>
> Do you know any plugin which will externally monitor mysql databases
and
> send reports through email and smtpreceiver will receive it and purge
it
> check if there is any problem in the database. Please let me know if
you
> know any.

I'm unclear of what you're asking. Nagios already includes plugin
for mysql and you should try using that and configure email reports 
through nagios. Personally I've written my own plugin in perl
to check mysql which I use in part because it runs faster inside
(with embedded perl) and because it also provides all the data
from "SHOW STATUS" and allows to set warnings based on if something
is out of balance there. You're welcome to try it, see
http://william.leibzon.org/nagios/plugins/check_mysqld.pl
(and if you want you maybe able to use it as base for custom perl
daemon that checks mysql and emails). Also MySQL AB provides SQLNet
as commercial application for those who buy mysql support - this is 
nagios-like monitoring system but entirely for purposes of checking
on sql databases - its very comprehensive but if you have large 
install that maybe of interest to you, see http://www.mysql.com
for more info.

-- 
William Leibzon
Elan Networks
william at elan.net

------------------------------------------------------------------------
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________________
Nagios Plugin Development Mailing List
Nagiosplug-devel at lists.sourceforge.net
Unsubscribe at
https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
::: Please include plugins version (-v) and OS when reporting any issue.

::: Messages without supporting info will risk being sent to /dev/null