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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
