The error is due to a bug in a Perl library Munin uses which causes the plugin cannot find the mysqladmin.
1. Find where is mysqladmin program located with the the following command:
locate mysqladmin
2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file:
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts --defaults-extra-file=/root/.my.cnf
Where the env.mysqladmin value is path returned by step above. Also ensure that /root/.my.cnf contains correct root password to the MySQL databases.
4. The format of /root/.my.cnf is:
[client]
user="root"
pass="******************"
5. Restart Munin service:
killall munin-node
su - munin --shell=/bin/bash
/usr/share/munin/munin-update
exit
service munin-node restart
if you are going to get a VPS server make sure that it has cPanel coz it makes server maintennance easier.’.’
Cpanel is reall great for managing websites and server reources”‘:
After searching Ask I found your site about cPanel – Munin Graph blank for MySQL Knowledge Base . I think both are good and I will be coming back to you and them in the future. Thanks
cPanel has fixed this issues in the last updates.
Perfect fix.
Easy and works well.
Thanks for the great write-up
Hi there, I found your site via Google at the same time as looking for a related topic, your website came up, it seems great. I have bookmarked it in my google bookmarks.