Tuesday, December 11, 2007

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:

    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.

View My Stats