Munin stopped logging MySQL data

[rnawky]

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]

In Shell Try...

service munin-node restart

or...

/etc/init.d/munin-node restart

Cheers

 

[chrishorgan]

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!)

 

[Dante78]

mine, is not loggining any data. all graphs are blank

Cheers

 

[anton_latvia]

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:

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:

/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:

mysqladmin variables

and of course put that login/pass to /home/munin/.my.cnf.

I hope that helps!