Debian Bug report logs - #408452
munin-node: mysql plugins don't get any data

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Uwe Storbeck <uwe@ibr.ch>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: munin-node: mysql plugins don't get any data

Date: Thu, 25 Jan 2007 23:04:35 +0100

Package: munin-node
Version: 1.2.5-1
Severity: normal

The mysql plugins don't get any data:

$ telnet localhost 4949
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
# munin node at grappa.ibr.ch
list
open_inodes mysql_slowqueries irqstats apache_accesses if_eth0 squid_cache mysql_threads df uptime swap load postfix_mailstats cpu df_inode mysql_queries open_files forks iostat memory exim_mailqueue vmstat nfs_client apache_processes if_err_eth0 entropy processes postfix_mailqueue apache_volume acpi interrupts netstat mysql_bytes munin_graph nfsd hddtemp_smartctl postfix_mailvolume munin_update exim_mailstats squid_requests squid_traffic
fetch mysql_slowqueries
queries.value U
.
fetch mysql_bytes
sent.value U
recv.value U
.

Reason seems to be the config entry for mysql in the file
/etc/munin/plugin-conf.d/munin-node:

  [mysql*]
  user root
  env.mysqlopts --defaults-extra-file=/etc/mysql/debian.cnf

Calling mysqladmin with these options runs into an error:

# mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf extended-status
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Trying to get the extended status directly with the user and password
from the file /etc/mysql/debian.cnf works:

# mysqladmin --user='debian-sys-maint' --password='XXXXXXXXXXXXXXXX' extended-status
+-----------------------------------+----------+
| Variable_name                     | Value    |
+-----------------------------------+----------+
| Aborted_clients                   | 0        |
..

I'm not sure if this is a munin-node or a mysql bug, be free to
reassign it.

mysqladmin from:
  Package: mysql-client-5.0
  Version: 5.0.30-3

Regards,

Uwe


-- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (750, 'testing'), (650, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-3-k7
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages munin-node depends on:
ii  adduser                       3.101      Add and remove users and groups
ii  libnet-server-perl            0.94-1     An extensible, general perl server
ii  lsb-base                      3.1-22     Linux Standard Base 3.1 init scrip
ii  perl                          5.8.8-7    Larry Wall's Practical Extraction 
ii  procps                        1:3.2.7-3  /proc file system utilities

Versions of packages munin-node recommends:
ii  libnet-snmp-perl              5.2.0-1    Script SNMP connections

-- no debconf information

Message #10 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Micah Anderson <micah@riseup.net>

To: 408452@bugs.debian.org

Subject: no longer has access

Date: Sun, 7 Oct 2007 18:01:49 -0400

The debian-sys-maint mysql user no longer has the mysql permissions to
run extended-status, so using
--defaults-extra-file=/etc/mysql/debian.cnf wont work for these plugins.

If you create a /root/.my.cnf with:
[client]
user = root
password = yourpassword

(be sure to make this file ONLY have 600 permissions), then using
--defaults-extra-file=/root/.my.cnf will work

Micah

Message #15 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Micah Anderson <micah@riseup.net>

To: 408452@bugs.debian.org

Subject: Actually, I was wrong

Date: Sun, 7 Oct 2007 18:13:56 -0400

The problem has to do with the option --defaults-extra-file, if you
change it to just --defaults-file it works fine:

This works:
#mysqladmin --defaults-file=/etc/mysql/debian.cnf extended-status

This does not:
# mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf extended-status
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Micah

Message #20 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Giovanni Toraldo <scurippio@gmail.com>

To: 408452@bugs.debian.org

Date: Wed, 11 Feb 2009 22:38:10 +0100

I can confirm both bug and proposed fix.

Message #25 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Holger Levsen <holger@layer-acht.org>

To: 408452@bugs.debian.org, control@bugs.debian.org

Subject: unreproducible

Date: Thu, 26 Feb 2009 17:56:06 +0100

[Message part 1 (text/plain, inline)]

tags 408452 +moreinfo +unreproducable
thanks

Hi,

I cannot reproduce whats written in 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=408452#15 - both commands 
work here, on etch as well as on lenny.

Pointers why "env.mysqlopts --defaults-extra-file=/etc/mysql/debian.cnf" 
should be changed in /etc/munin/plugin-conf.d/munin-node welcome, atm I don't 
see the need to.


regards,
	Holger

[signature.asc (application/pgp-signature, inline)]

Message #34 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Vojtech <vojtech@x.cz>

To: 408452@bugs.debian.org

Subject: reproducable

Date: Sat, 12 Sep 2009 03:03:40 +0200

When mysqladmin is run (under root as munin mysql plugin does) 
with --defaults-extra-file=/etc/mysql/debian.cnf 
the following option files are read (in the same order):
/etc/mysql/my.cnf
/etc/mysql/debian.cnf
/root/.my.cnf
/usr/etc/my.cnf

The result can be checked by running 
mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf --print-defaults
which on default debian installation outputs:
# mysqladmin would have been started with the following arguments:
--port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost --user=debian-sys-maint --password=***** --socket=/var/run/mysqld/mysqld.sock

But in case there is /root/.my.cnf file with content similar to:
[client]
password=*****
the options from /etc/mysql/debian.cnf are overrided:
# mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf --print-defaults
mysqladmin would have been started with the following arguments:
--port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost --user=debian-sys-maint --password=***** --socket=/var/run/mysqld/mysqld.sock --password=*****
which is clearly wrong because the root password (the second one) is used for 
debian-sys-maint.

It seems to me that this is a bug and --defaults-file should be used instead 
of --defaults-extra-file in /etc/munin/plugin-conf.d/munin-node. In that case 
only /etc/mysql/debian.cnf will be processed by mysqladmin (and this should 
be enough, AFAIK).

As a workaround the option
user=root
can be added to /root/.my.cnf

Vojtech

Message #39 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Tom Feiner <feiner.tom@gmail.com>

To: Vojtech <vojtech@x.cz>, Micah Anderson <micah@riseup.net>, Uwe Storbeck <uwe@ibr.ch>

Cc: 408452@bugs.debian.org, control@bugs.debian.org

Subject: Bug#408452: munin-node: mysql plugins don't get any data

Date: Sat, 12 Sep 2009 12:25:15 +0300

[Message part 1 (text/plain, inline)]

tags 408452 -moreinfo -unreproducable
thanks

Hi,

I can also confirm the problem on sid & lenny, and the way to reproduce &
solve it as outlined at:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=408452#34.

Just one clarification, this problem exists only if /root/.my.cnf contain:

[client]
password=xxxxxxx

but do not contain
user=xxxx

if user=xxxx is also defined, then the command sent to mysqladmin is:
mysqladmin --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost
--user=debian-sys-maint --password=xxxxxxx
--socket=/var/run/mysqld/mysqld.sock --user=root --password=yyyyyyy
extended-status

Which basically provides mysqladmin with 2 sets of user/password, and
mysqladmin takes the last set of user/password from the command line.

The problem occurs when:
user=xxxx is not specified in /root/.my.cnf, then the command looks like this:
mysqladmin --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost
--user=debian-sys-maint --password=xxxxxxx
--socket=/var/run/mysqld/mysqld.sock --password=yyyyyyy extended-status

Causing mysqladmin to effectively use: user=debian-sys-maint and
password=yyyyyyy (roots mysql password).

Obviously this is not what we want, and setting
--defaults-file=/etc/mysql/debian.cnf will make this unambiguous, and will
only take the options from /etc/mysql/debian.cnf.

Regards,
    Tom Feiner

[signature.asc (application/pgp-signature, attachment)]

Message #48 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Tom Feiner <feiner.tom@gmail.com>

To: 408452@bugs.debian.org

Cc: control@bugs.debian.org

Subject: Bug#408452,munin-node: mysql plugins don't get any data

Date: Tue, 15 Sep 2009 11:04:26 +0300

[Message part 1 (text/plain, inline)]

tags 408452 patch
thanks

Hi,

Here's the proposed patch.

Holger, if you agree with the assessment and the patch, can you please
add it? (Or let me know and I'll add it?)

Thanks,
    Tom Feiner

[munin-bug-408452-mysql.patch (text/x-patch, inline)]

Index: plugins.conf
===================================================================
--- plugins.conf	(revision 2426)
+++ plugins.conf	(working copy)
@@ -57,7 +57,7 @@
 
 [mysql*]
 user root
-env.mysqlopts --defaults-extra-file=/etc/mysql/debian.cnf
+env.mysqlopts --defaults-file=/etc/mysql/debian.cnf
 
 [postfix_mailqueue]
 user (postfix)

[signature.asc (application/pgp-signature, attachment)]

Message #55 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Holger Levsen <holger@layer-acht.org>

To: 408452@bugs.debian.org

Subject: Re: Bug#408452: ,munin-node: mysql plugins don't get any data

Date: Wed, 16 Sep 2009 11:47:12 +0200

[Message part 1 (text/plain, inline)]

Hi Tom,

On Dienstag, 15. September 2009, Tom Feiner wrote:
> Holger, if you agree with the assessment and the patch, can you please
> add it? (Or let me know and I'll add it?)

Looks good to me :-) Please describe the change in behaviour 
(that /root/.my.cnf is ignored now) in debian/changelog :-)


thanks,
	Holger

[signature.asc (application/pgp-signature, inline)]

Message #60 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Tom Feiner <feiner.tom@gmail.com>

To: 408452@bugs.debian.org

Cc: control@bugs.debian.org

Subject: Re: Bug#408452: ,munin-node: mysql plugins don't get any data

Date: Wed, 16 Sep 2009 19:17:16 +0300

[Message part 1 (text/plain, inline)]

tags 408452 pending
thanks

Hi,

Holger Levsen wrote:
> Looks good to me :-) Please describe the change in behaviour 
> (that /root/.my.cnf is ignored now) in debian/changelog :-)

Done.

I added the following to debian/changelog:

Changed mysql* plugins options to use /etc/mysql/debian.cnf
exclusively. /root/.my.cnf, and other default mysql configuration files
will now be ignored.

Regards,
    Tom Feiner

[signature.asc (application/pgp-signature, attachment)]

Message #67 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Holger Levsen <holger@layer-acht.org>

To: 408452@bugs.debian.org

Subject: Re: Bug#408452: ,munin-node: mysql plugins don't get any data

Date: Thu, 17 Sep 2009 15:20:55 +0200

[Message part 1 (text/plain, inline)]

Hi Tom,

On Mittwoch, 16. September 2009, Tom Feiner wrote:
> I added the following to debian/changelog:
>
> Changed mysql* plugins options to use /etc/mysql/debian.cnf
> exclusively. /root/.my.cnf, and other default mysql configuration files
> will now be ignored.

what other default files are now ignored which werent previously? Are there 
any?


regards,
	Holger

[signature.asc (application/pgp-signature, inline)]

Message #72 received at 408452@bugs.debian.org (full text, mbox, reply):

From: Tom Feiner <feiner.tom@gmail.com>

To: Holger Levsen <holger@layer-acht.org>, 408452@bugs.debian.org

Subject: Re: Bug#408452: ,munin-node: mysql plugins don't get any data

Date: Thu, 17 Sep 2009 17:09:06 +0300

[Message part 1 (text/plain, inline)]

Holger Levsen wrote:

> 
> what other default files are now ignored which werent previously? Are there 
> any?
> 

The default files used by mysqladmin (in sid) are:

/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

I'll add them also to the changelog, so people will know what to expect.

Thanks,
    Tom Feiner

[signature.asc (application/pgp-signature, attachment)]

Message #77 received at 408452-close@bugs.debian.org (full text, mbox, reply):

From: Holger Levsen <holger@debian.org>

To: 408452-close@bugs.debian.org

Subject: Bug#408452: fixed in munin 1.2.6-16

Date: Fri, 18 Sep 2009 10:47:23 +0000

Source: munin
Source-Version: 1.2.6-16

We believe that the bug you reported is fixed in the latest version of
munin, which is due to be installed in the Debian FTP archive:

munin-node_1.2.6-16_all.deb
  to pool/main/m/munin/munin-node_1.2.6-16_all.deb
munin-plugins-extra_1.2.6-16_all.deb
  to pool/main/m/munin/munin-plugins-extra_1.2.6-16_all.deb
munin_1.2.6-16.diff.gz
  to pool/main/m/munin/munin_1.2.6-16.diff.gz
munin_1.2.6-16.dsc
  to pool/main/m/munin/munin_1.2.6-16.dsc
munin_1.2.6-16_all.deb
  to pool/main/m/munin/munin_1.2.6-16_all.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 408452@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Holger Levsen <holger@debian.org> (supplier of updated munin 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 ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.8
Date: Fri, 18 Sep 2009 10:34:33 +0000
Source: munin
Binary: munin-node munin-plugins-extra munin
Architecture: source all
Version: 1.2.6-16
Distribution: unstable
Urgency: low
Maintainer: Munin Debian Maintainers <munin-deb-maint@linpro.no>
Changed-By: Holger Levsen <holger@debian.org>
Description: 
 munin      - network-wide graphing framework (grapher/gatherer)
 munin-node - network-wide graphing framework (node)
 munin-plugins-extra - network-wide graphing framework (user contributed plugins for nod
Closes: 408452 532955 545465 545967
Changes: 
 munin (1.2.6-16) unstable; urgency=low
 .
   [ Holger Levsen ]
   * Bump standards-version to 3.8.3, no changes necessary.
 .
   [ Tom Feiner ]
   * Add python to munin-plugins-extra suggests, as ipmi_sensor_ needs it.
     (Closes: #545967)
   * Updated ejabberd plugin, thanks to Peter Viskup. (Closes: #545465)
   * Add suggests to libnet-telnet-perl for munin-plugins-extra as the
     asterisk plugins needs it. (Closes: #532955)
   * Changed mysql* plugins options to use /etc/mysql/debian.cnf
     exclusively. /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf
     ~/.my.cnf (including /root/.my.cnf) mysql configuration files
     will now be ignored. (Closes: #408452)
Checksums-Sha1: 
 a8bb158261ce15c8bc03d92b0cc5ea3d316dbcd7 1421 munin_1.2.6-16.dsc
 a40589d54efb1056b81a2f563f8a29536e1539a3 80945 munin_1.2.6-16.diff.gz
 d8b7443ee2967cefe5c15d89a5021d5c727bb5f1 614690 munin_1.2.6-16_all.deb
 7a5710531408efc5413d21af78e7a3979d286689 664936 munin-node_1.2.6-16_all.deb
 60ffdf8adcbe276fb12863be593a71bfe7ddc713 91036 munin-plugins-extra_1.2.6-16_all.deb
Checksums-Sha256: 
 89fd7f3235c2353b5ce96078cad21fea523c154df4bbb2bb9d45695c6cdd5c31 1421 munin_1.2.6-16.dsc
 0b01d6ee33f65a607fd1eab1d3117ead419f12be2304ebd8e1ef23f240e59f1d 80945 munin_1.2.6-16.diff.gz
 bae5bc663dd8421248313b35e21773d80c567887d313d608422ae1a586138560 614690 munin_1.2.6-16_all.deb
 e7878cd9f4511c014dc312a34102ccd438dd7e729260e356ee624aabfd0201a4 664936 munin-node_1.2.6-16_all.deb
 a7e4d4ef66df5f8382fdbddb70cf55eee8372d3fe165a74dba19ee0943378dac 91036 munin-plugins-extra_1.2.6-16_all.deb
Files: 
 c4cc3744f1671316990d875a0f091352 1421 net optional munin_1.2.6-16.dsc
 6016beb123bdaa293f65fc6c8ad7182d 80945 net optional munin_1.2.6-16.diff.gz
 550f3ddb37f5bd402175b6ff8f8fe89b 614690 net optional munin_1.2.6-16_all.deb
 1c20388fe355c13da228542f602fcfd8 664936 net optional munin-node_1.2.6-16_all.deb
 01e363732ae623f846d6f837a7f3b146 91036 net optional munin-plugins-extra_1.2.6-16_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iD8DBQFKs2PYUHLQNqxYNSARAt2AAJ9po2jKnY4JtRvg/nUT6JqySE4jSgCgyx/R
jXK7hiLLOO9iG9LUjPvVZ24=
=5Ivy
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.