Your message dated Thu, 13 Oct 2005 02:47:09 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#278864: fixed in nagios-plugins 1.4.2-3
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 29 Oct 2004 20:04:41 +0000
>From [EMAIL PROTECTED] Fri Oct 29 13:04:41 2004
Return-path: <[EMAIL PROTECTED]>
Received: from dev.coresense.com (coresense.com) [216.130.239.171]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CNczJ-0006Up-00; Fri, 29 Oct 2004 13:04:41 -0700
Received: by coresense.com (Postfix, from userid 1000)
id A1981E6B31; Fri, 29 Oct 2004 16:03:51 -0400 (EDT)
Date: Fri, 29 Oct 2004 16:03:51 -0400
From: Ian Gulliver <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: check_mysql should be able to slave status
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="VACxsDaSTfeluoxK"
Content-Disposition: inline
X-Operating-System: Linux puck 2.6.8-1-686
User-Agent: Mutt/1.5.6+20040722i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
--VACxsDaSTfeluoxK
Content-Type: multipart/mixed; boundary="1Y7d0dPL928TPQbc"
Content-Disposition: inline
--1Y7d0dPL928TPQbc
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Package: nagios-plugins
Version: 1.3.1.0-12
Severity: wishlist
Tags: patch
It would be useful if check_mysql could check the current status of
replication from either the master or slave perspective. If replication
breaks currently, even if both ends are monitored, check_mysql will not
notice the problem and will not generate a nagios alert.
Attached is a patch that adds -s/--slave (master perspective, takes a
slave --report-host name) and -S/--slave-io (slave perspective, takes a
database name that is being replicated) flags to check_mysql.
--=20
Ian Gulliver
Penguin Hosting
"Failure is not an option; it comes bundled with your Microsoft products."
--1Y7d0dPL928TPQbc
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment;
filename="nagios-plugins-1.3.1.0-checkslave.patch"
Content-Transfer-Encoding: quoted-printable
diff -udr nagios-plugins-1.3.1.0/plugins/check_mysql.c nagios-plugins-1.3.1=
=2E0-checkslave/plugins/check_mysql.c
--- nagios-plugins-1.3.1.0/plugins/check_mysql.c 2003-02-10
19:47:47.000000=
000 -0500
+++ nagios-plugins-1.3.1.0-checkslave/plugins/check_mysql.c 2004-10-29 15:5=
3:54.000000000 -0400
@@ -30,6 +30,9 @@
char *db =3D "";
unsigned int db_port =3D MYSQL_PORT;
=20
+char *slave =3D NULL;
+char *slave_io =3D NULL;
+
int process_arguments (int, char **);
int validate_arguments (void);
void print_help (void);
@@ -107,6 +110,77 @@
=20
}
=20
+ if (slave !=3D NULL) {
+ MYSQL_ROW row;
+ MYSQL_RES *result;
+ int found =3D 0;
+
+ if (mysql_query(&mysql,"SHOW SLAVE HOSTS;") !=3D 0) {
+ printf("%s\n", mysql_error(&mysql));
+ return STATE_CRITICAL;
+ }
+
+ result =3D mysql_store_result(&mysql);
+ if (result =3D=3D NULL) {
+ printf("%s\n", mysql_error(&mysql));
+ return STATE_CRITICAL;
+ }
+
+ while ((row =3D mysql_fetch_row(result))) {
+ if (strcmp(row[1],slave) =3D=3D 0) {
+ printf("Slave %s is running.\n",row[1]);
+ found =3D 1;
+ break;
+ }
+ }
+
+ mysql_free_result(result);
+
+ if (found =3D=3D 0) {
+ printf("Slave %s is not running.\n",slave);
+ return STATE_CRITICAL;
+ }
+ }
+
+ if (slave_io !=3D NULL) {
+ MYSQL_ROW row;
+ MYSQL_RES *result;
+ int found =3D 0;
+
+ if (mysql_query(&mysql,"SHOW SLAVE STATUS;") !=3D 0) {
+ printf("%s\n", mysql_error(&mysql));
+ return STATE_CRITICAL;
+ }
+
+ result =3D mysql_store_result(&mysql);
+ if (result =3D=3D NULL) {
+ printf("%s\n", mysql_error(&mysql));
+ return STATE_CRITICAL;
+ }
+
+ while ((row =3D mysql_fetch_row(result))) {
+ if (strcmp(row[11],slave_io) =3D=3D 0) {
+ if (strcmp(row[9],"Yes") =3D=3D 0) {
+ found =3D 1;
+ printf("Slave I/O for database %s is
running.\n",row[11]);
+ } else {
+ found =3D 2;
+ printf("Slave I/O for database %s is
not running.\n",row[11]);
+ }
+ break;
+ }
+ }
+
+ mysql_free_result(result);
+
+ if (found =3D=3D 2) {
+ return STATE_CRITICAL;
+ } else if (found =3D=3D 0) {
+ printf("Slave I/O for database %s is not
configure.\n",slave_io);
+ return STATE_CRITICAL;
+ }
+ }
+
/* close the connection */
mysql_close (&mysql);
=20
@@ -137,6 +211,8 @@
{"verbose", no_argument, 0, 'v'},
{"version", no_argument, 0, 'V'},
{"help", no_argument, 0, 'h'},
+ {"slave", required_argument, 0, 's'},
+ {"slave-io", required_argument, 0, 'S'},
{0, 0, 0, 0}
};
#endif
@@ -147,9 +223,9 @@
while (1) {
#ifdef HAVE_GETOPT_H
c =3D
- getopt_long (argc, argv, "hVP:p:u:d:H:", long_options,
&option_index);
+ getopt_long (argc, argv, "hVP:p:u:d:H:s:S:",
long_options, &option_inde=
x);
#else
- c =3D getopt (argc, argv, "hVP:p:u:d:H:");
+ c =3D getopt (argc, argv, "hVP:p:u:d:H:s:S:");
#endif
=20
if (c =3D=3D -1 || c =3D=3D EOF)
@@ -182,6 +258,12 @@
case 'h':
/* help */
print_help ();
exit (STATE_OK);
+ case 's':
+ slave =3D optarg;
+ break;
+ case 'S':
+ slave_io =3D optarg;
+ break;
case '?':
/* help */
usage ("Invalid argument\n");
}
@@ -251,6 +333,12 @@
" Use the indicated password to authenticate the
connection\n"
" =3D=3D> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT
SECURE!!! <=
=3D=3D\n"
" Your clear-text password will be visible as a process
table entry\n"
+ " -s, --slave=3DSTRING\n"
+ " Check that the indicated slave host is running\n"
+ " (requires REPLICATION SLAVE privilege)\n"
+ " -S, --slave-io=3DSTRING\n"
+ " Check that slave I/O is running for the indicated
database\n"
+ " (requires REPLICATION CLIENT privilege)\n"
" -h, --help\n"
" Print detailed help screen\n"
" -V, --version\n" " Print version information\n\n",
MYSQL_PORT);
@@ -265,7 +353,7 @@
print_usage (void)
{
printf
- ("Usage: %s [-d database] [-H host] [-P port] [-u user] [-p
password]\n"
+ ("Usage: %s [-d database] [-H host] [-P port] [-u user] [-p
password] [-=
s slavename] [-S database]\n"
" %s --help\n"
" %s --version\n", progname, progname, progname);
}
--1Y7d0dPL928TPQbc--
--VACxsDaSTfeluoxK
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFBgqIkefI+qeoOjxURArDdAJ9DEYtoVFF1AzmVVogoV1cW9CcNUgCePvg2
66X+LBfjNEUBIqlaetr1gD4=
=acba
-----END PGP SIGNATURE-----
--VACxsDaSTfeluoxK--
---------------------------------------
Received: (at 278864-close) by bugs.debian.org; 13 Oct 2005 09:47:54 +0000
>From [EMAIL PROTECTED] Thu Oct 13 02:47:54 2005
Return-path: <[EMAIL PROTECTED]>
Received: from katie by spohr.debian.org with local (Exim 3.36 1 (Debian))
id 1EPzg5-0007Xr-00; Thu, 13 Oct 2005 02:47:09 -0700
From: sean finney <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.56 $
Subject: Bug#278864: fixed in nagios-plugins 1.4.2-3
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Thu, 13 Oct 2005 02:47:09 -0700
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Source: nagios-plugins
Source-Version: 1.4.2-3
We believe that the bug you reported is fixed in the latest version of
nagios-plugins, which is due to be installed in the Debian FTP archive:
nagios-plugins_1.4.2-3.diff.gz
to pool/main/n/nagios-plugins/nagios-plugins_1.4.2-3.diff.gz
nagios-plugins_1.4.2-3.dsc
to pool/main/n/nagios-plugins/nagios-plugins_1.4.2-3.dsc
nagios-plugins_1.4.2-3_i386.deb
to pool/main/n/nagios-plugins/nagios-plugins_1.4.2-3_i386.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
sean finney <[EMAIL PROTECTED]> (supplier of updated nagios-plugins package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Tue, 11 Oct 2005 10:14:18 +0200
Source: nagios-plugins
Binary: nagios-plugins
Architecture: source i386
Version: 1.4.2-3
Distribution: unstable
Urgency: low
Maintainer: [EMAIL PROTECTED]
Changed-By: sean finney <[EMAIL PROTECTED]>
Description:
nagios-plugins - Plugins for the nagios network monitoring and management
system
Closes: 278864 285554 296278 296600 300701 307905 309255 309673
Changes:
nagios-plugins (1.4.2-3) unstable; urgency=low
.
* Sean Finney:
- include fix from Modesto Alexandre to correct paths in check_log
(closes: #296600).
- looks like upstream's check_mrtg has been broken for a while now.
now including a fix that i'll eventually move upstream.
(closes: #309673).
- include a fix to check_smtp to make it speak proper ehlo before
issueing a starttls command, and also check that the server
actually supports it before blindly continuing. thanks to
Jeroen van Wolffelaar for taking the time to point out the
details (closes: #285554).
- in the process of the above, also figured out how to get
check_smtp to play nicely with gnutls-based servers.
- check_disk once again will match non-mountpoint directories to
the closest parent mountpoint (closes: #296278).
- include jeroen's "less beastly" check_ntp sys.peer regex.
- fix for braindead command-line option parsing for freespace
in check_disk_smb (closes: #300701).
- updated the usage function in check_game to reflect changed
cmdline options (closes: #307905).
- upstream is now shipping an non-broken ipv6-capable check_ping,
with PING6_COMMAND properly set in config.h (closes: #309255).
- upstream check_mysql can now check slave status (closes: #278864).
Files:
7766e68631fe0cf7c0f64e2cef5132d1 959 net extra nagios-plugins_1.4.2-3.dsc
3a099ad7388c38c8a952fc66eda278fa 34971 net extra nagios-plugins_1.4.2-3.diff.gz
75108ddbd441d34df2ad61063101f386 355684 net extra
nagios-plugins_1.4.2-3_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
iD8DBQFDTirrynjLPm522B0RAorGAJ9Ecxq94f/MFeRM3fKPBfOxaYHgeQCdFfXg
BDEEfkgcgepf3QhCffDjGOw=
=Ew24
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
