Munin not showing graphs

Fix for Munin installed by cPanel/WHM

1. Determine where is mysqladmin program located with the one of the following command:

   which mysqladmin
   type mysqladmin
   locate mysqladmin

   If should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin.

2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below:

   
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts --defaults-extra-file=/root/.my.cnf


   Ensure the env.mysqladmin value is path returned by step above. Also ensure that /root/.my.cnf contains correct root password to the MySQL databases.

3. Then restart Munin service:

   /etc/init.d/munin-node restart

4. Wait a while for MySQL statistics to be gathered, and check the graphs again.

Enjoy
Ninad