anand

Well-Known Member
Nov 11, 2002
1,435
1
168
India
cPanel Access Level
DataCenter Provider
Hi,

I installed percona as per How to replace MySQL with Percona in 11.36 | cPanel Blog, and after that tried to install Munin plugin. The plugin gave me the below error:

Code:
[20131215.035602]   Warning: Unable to set access on database tables in "munin_innodb" for MySQL InnoDB plugin usage.
[20131215.035602]   
[20131215.035602]   Encountered problem while setting MySQL InnoDB access. No further InnoDB access was performed.
[20131215.035602]   Suggestion:
[20131215.035602]      Verify input data, enable InnoDB, check config file '/etc/my.cnf', restart MySQL and then re-run /usr/local/cpanel/bin/build_munin_conf
[20131215.035602]      or InnoDB chart may not function as expected.
[20131215.035607]   Stopping Munin Node agents: cat: /var/run/munin/munin-node.pid: No such file or directory
[20131215.035607]   kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
[20131215.035607]   [FAILED]
[20131215.035608]   Starting Munin Node: [  OK  ]
Any ideas on how to resolve the above ?

Thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

While implementing Percona with cPanel/WHM is very straightforward, it's not officially supported. The error message indicates a lack of InnoDB support with your Percona installation. You may want to ensure InnoDB is not disabled in your /etc/my.cnf file. Note that you may want to switch back to MySQL if you are not comfortable making these types of custom changes.

Thank you.
 

anand

Well-Known Member
Nov 11, 2002
1,435
1
168
India
cPanel Access Level
DataCenter Provider
Thanks Michael. The only issue is munin is not tracking mysql/percona in the graphs, rest everything seems to be working. And I did enable and check that INNODB is enabled.

Will see if there is any other solution to get the graphing working :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
You can try manually running the Munin cron to update the graphs via:

Code:
su munin -c /usr/local/cpanel/3rdparty/perl/514/bin/munin-cron
Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Are you logged via SSH as root? If so, it's likely Munin was not properly installed. Try reinstalling it via the "Manage Plugins" option in Web Host Manager.

Thank you.
 

anand

Well-Known Member
Nov 11, 2002
1,435
1
168
India
cPanel Access Level
DataCenter Provider
Yes ofcourse I am logged in as root. Have already tried to reinstall, will check again and post results.

Are you logged via SSH as root? If so, it's likely Munin was not properly installed. Try reinstalling it via the "Manage Plugins" option in Web Host Manager.

Thank you.

Thanks