Munin not show MySQL graphs

Try the following:
- Try restarting MySQL.
- Give Munin some time to do its thing.

- Restart the server if the above two didn't work.

 

Make sure that the password in /root/.my.cnf is valid, first.
Secondly, I have had this problem off and on for months with munin installs. To resolve it, this is what I did:

in /etc/munin/plugin-conf.d , you will see a file called cpanel.conf . Modify it completely to look like so:

Code:

[mysql*]
user root
group wheel
env.mysqlopts --defaults-extra-file=/root/.my.cnf
[exim_mailqueue]
group mail

[exim_mailstats]
group mail

[mailman]
user mailman

then restart munin

Code:

/etc/init.d/munin-node restart

This tells munin to pull the mysql environment from the file necessary
Of course , in this case you will need munin to run as ROOT. To do this:
su to your munin user

Code:

su munin

remove the munin crontab

Code:

crontab -e
remove the line, or just add an # to the beginning of it

then exit out of the shell, and add the SAME crontab (that was in the munin user) to root, adding --force-root to the end of the statement, so it'd be something like:

Code:

*/5 * * * * /opt/munin/bin/munin-cron --force-root

Please note that this is NOT the exact entry, as I have my munin collection server on a non cp server, but this works for CP setups as well

Good luck

 

Did you add the --force-root option?
Either way, good to ehar it's working for you now.

 

Empty/Blank MySQL Stats/Graphs in Munin

I confirm that upon adding "env.mysqlopts --defaults-extra-file=/root/.my.cnf" to "/etc/munin/plugin-conf.d/cpanel.conf" as shown above, then restarting munin-node, Munin began to display MySQL statistics without performing the other additional steps. To reiterate for other people, however, it will take time for the MySQL statistics data to accumulate.