[Nagiosplug-devel] nagios external plugin for mysql

[Md Hasnain]

Thank you so much for that I will review it and I will let you know.

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 6:16 PM
To: Nagios Plugin Development Mailing List
Subject: Re: [Nagiosplug-devel] nagios external plugin for mysql


I think you need to look into using Nagios NSCA, see
http://www.nagios.org/download/

When properly configured you'd have nagios plugins run on regular 
intervals (through cron) and use NSCA client to report their status
back to nagios.

On Mon, 14 May 2007, Md Hasnain wrote:

> 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.

------------------------------------------------------------------------
-
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