Munin stopped logging MySQL data

rnawky

Member
Jan 13, 2010
20
0
51
Ever since the server was restarted, the Munin plugin for WHM has stopped logging MySQL data all together. Any way to figure out what went wrong and how to fix it?
 

chrishorgan

Registered
Mar 31, 2008
3
0
51
WA
In Shell Try...

service munin-node restart

or...

/etc/init.d/munin-node restart

Cheers
 
Last edited:

chrishorgan

Registered
Mar 31, 2008
3
0
51
WA
And if that doesn't work,

Find the munin-node process...
pgrep -u root -l

Then Kill it.

Then restart the process again with
/etc/init.d/munin-node restart

(It just happened to me!)
 

anton_latvia

Well-Known Member
PartnerNOC
May 11, 2004
432
47
178
Latvia
cPanel Access Level
Root Administrator
Usually this happens when munin plugin is not able to connect to mysql and grab statistica data. Here is what I do to fix this problem:

Code:
cp /root/.my.cnf /home/munin/.my.cnf
chown munin.munin /home/munin/.my.cnf
then in the file /home/munin/.my.cnf I change the word [client] to [mysqladmin] and restart munin:

Code:
/etc/init.d/munin restart
Yes, I know, that giving munin root privileges is a bad idea. On the other hand noone will login with that user, but if you are concerned - you could add special user to mysql with permission to run the following command:

Code:
mysqladmin variables
and of course put that login/pass to /home/munin/.my.cnf.

I hope that helps! ;)