check_mysql -S isn't working {Disarmed} {Fraud?}

[alexus]

ok, 'Seconds Behind Master' does have value of null, but
where and what do i need to set, in order for it to function properly?
i'm using mysql-5.0.45



On 8/2/07, Marc Powell <marc at ena.com> wrote:
>
>
>
> > -----Original Message-----
> > From: nagios-users-bounces at lists.sourceforge.net [mailto:nagios-users-
> > bounces at lists.sourceforge.net] On Behalf Of alexus
> > Sent: Thursday, August 02, 2007 2:24 PM
> > To: Nagios-users at lists.sourceforge.net
> > Subject: [Nagios-users] check_mysql -S isn't working {Disarmed}
> {Fraud?}
> >
> > # ./check_mysql -H 10.52.208.9910. <http://10.52.208.99>  -u xxxx -p
> > xxxxxxxxx -S
> > Slave IO: Yes Slave SQL: No Seconds Behind Master: (null)
> > #
> >
> > how come I get "null" in "No Seconds Behind Master?
> > anyone?
>
> Ok. I'll bite on the second time around...
>
> My GUESS- The Seconds_Behind_Master column of the of the mysql command
> 'show slave status' has the value 'null' or is empty. Connect to mysql,
> issue the 'show slave status;' command and verify if that's the case.
>
> Alternately, the version of mysql that you are using, whatever it is,
> changed that column such that the plugin can no longer parse it.
>
> Alternately, the slave is broken in some way.
>
> --
> Marc
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> 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
>



-- 
http://alexus.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070802/7fe24414/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
-------------- next part --------------
_______________________________________________
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