similar problems here - munin was working great for a couple of days. then after a server reboot (due to required kernel upgrade) the MySQL graphs stopped updating - others were working fine.
support at my datacentre suggested uninstalling and re-installing munin which I did - since then none of my graphs are updating.
munin-node is runnning, and /var/log/munin/munin-node.log is showing these every 5 minutes (which is what was showing when the graphs were updating properly)
2006/08/13-12:05:01 CONNECT TCP Peer: "127.0.0.1:48230" Local: "127.0.0.1:4949"
2006/08/13-12:05:03 Plugin "mailman" exited with status 768. ----
2006/08/13-12:10:02 CONNECT TCP Peer: "127.0.0.1:48268" Local: "127.0.0.1:4949"
2006/08/13-12:10:04 Plugin "mailman" exited with status 768. ----
looking back further in that log I find this:
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
2006/08/12-00:50:01 CONNECT TCP Peer: "127.0.0.1:34920" Local: "127.0.0.1:4949"
2006/08/12-00:50:04 Plugin "mailman" exited with status 768. ----
^Gmysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
2006/08/12-00:55:01 CONNECT TCP Peer: "127.0.0.1:34943" Local: "127.0.0.1:4949"
2006/08/12-00:55:03 Plugin "mailman" exited with status 768. ----
^Gmysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
which I guess is why my MySQL graps stopped working. but now that message has gone away and nothing is updating.
so I updated /etc/munin/munin-node.conf and set:
log_level 4
to
log_level 10
I now see this:
Process Backgrounded
2006/08/13-12:15:51 MyPackage (type Net::Server::Fork) starting! pid(29675)
Binding to TCP port 4949 on host *
Setting gid to "10 10"
2006/08/13-12:20:01 CONNECT TCP Peer: "127.0.0.1:48296" Local: "127.0.0.1:4949"
2006/08/13-12:20:04 Plugin "mailman" exited with status 768. ----
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I still have the MSQL problem - but will get to that later.
I then notice in munin-update.log
Aug 13 12:15:05 [29219] - Unable to update /var/lib/munin/mydomain.com/host.mydomain.com-exim_mailqueue-mails-g.rrd: opening '/var/lib/munin/mydomain.com/host.mydomain.com-exim_mailqueue-mails-g.rrd': Permission denied
looking in that directory I see:
-rw-r--r-- 1 32007 32009 50604 Aug 13 03:15 host.mydomain.com-apache_accesses-accesses80-d.rrd
so it seems like the RRD files (the databases that hold the statistics) have the wrong owner / group set. I fixed this:
[email protected] [/var/lib/munin/mydomain.com]# chown munin.munin *
on the next run the permssions denied errors have gone, and a couple of the graphs have updated. on the run after that all my graphs are updating again apart from the MySQL ones.
the MySQL ones do seem to be related to connection errors following (many) recent cpanel updates on my server... I will leave that for another day though or wait for someone to post findings re. that as it's now time for me to get some lunch
support at my datacentre suggested uninstalling and re-installing munin which I did - since then none of my graphs are updating.
munin-node is runnning, and /var/log/munin/munin-node.log is showing these every 5 minutes (which is what was showing when the graphs were updating properly)
2006/08/13-12:05:01 CONNECT TCP Peer: "127.0.0.1:48230" Local: "127.0.0.1:4949"
2006/08/13-12:05:03 Plugin "mailman" exited with status 768. ----
2006/08/13-12:10:02 CONNECT TCP Peer: "127.0.0.1:48268" Local: "127.0.0.1:4949"
2006/08/13-12:10:04 Plugin "mailman" exited with status 768. ----
looking back further in that log I find this:
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
2006/08/12-00:50:01 CONNECT TCP Peer: "127.0.0.1:34920" Local: "127.0.0.1:4949"
2006/08/12-00:50:04 Plugin "mailman" exited with status 768. ----
^Gmysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
2006/08/12-00:55:01 CONNECT TCP Peer: "127.0.0.1:34943" Local: "127.0.0.1:4949"
2006/08/12-00:55:03 Plugin "mailman" exited with status 768. ----
^Gmysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
which I guess is why my MySQL graps stopped working. but now that message has gone away and nothing is updating.
so I updated /etc/munin/munin-node.conf and set:
log_level 4
to
log_level 10
I now see this:
Process Backgrounded
2006/08/13-12:15:51 MyPackage (type Net::Server::Fork) starting! pid(29675)
Binding to TCP port 4949 on host *
Setting gid to "10 10"
2006/08/13-12:20:01 CONNECT TCP Peer: "127.0.0.1:48296" Local: "127.0.0.1:4949"
2006/08/13-12:20:04 Plugin "mailman" exited with status 768. ----
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I still have the MSQL problem - but will get to that later.
I then notice in munin-update.log
Aug 13 12:15:05 [29219] - Unable to update /var/lib/munin/mydomain.com/host.mydomain.com-exim_mailqueue-mails-g.rrd: opening '/var/lib/munin/mydomain.com/host.mydomain.com-exim_mailqueue-mails-g.rrd': Permission denied
looking in that directory I see:
-rw-r--r-- 1 32007 32009 50604 Aug 13 03:15 host.mydomain.com-apache_accesses-accesses80-d.rrd
so it seems like the RRD files (the databases that hold the statistics) have the wrong owner / group set. I fixed this:
[email protected] [/var/lib/munin/mydomain.com]# chown munin.munin *
on the next run the permssions denied errors have gone, and a couple of the graphs have updated. on the run after that all my graphs are updating again apart from the MySQL ones.
the MySQL ones do seem to be related to connection errors following (many) recent cpanel updates on my server... I will leave that for another day though or wait for someone to post findings re. that as it's now time for me to get some lunch