[Nagiosplug-devel] nagios external plugin for mysql

[william(at)elan.net]

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.