Munin and MariaDB on cPanel

[iRakic]

Hello,

I have installed MariaDB on server, and I need to install Munin on server. When I'm trying to install it I'm getting the following error:

[20130714.111351]   
[20130714.111351]   Problems were detected with cPanel-provided files which are RPM controlled.
[20130714.111351]   If you did not make these changes intentionally, you can correct them by running:
[20130714.111351]   
[20130714.111351]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[20130714.111351]   The following RPMs are missing from your system:
[20130714.111351]   cpanel-perl-514-Cache-Cache.1.06-1.cp1136
[20130714.111351]   cpanel-perl-514-munin.1.4.7-8.cp1136
[20130714.111351]   Removing 0 broken rpms: 
[20130714.111351]   rpm: no packages given for erase
[20130714.111352]   Downloading http://httpupdate.cpanel.net/RPM/11.36/cloudlinux/6/x86_64/rpm.md5
[20130714.111352]   cpanel-perl-514-munin-1.4.7-8.cp1136.x86_64.rpm already downloaded
[20130714.111352]   cpanel-perl-514-Cache-Cache-1.06-1.cp1136.x86_64.rpm already downloaded
[20130714.111352]   Hooks system enabled
[20130714.111352]   Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
[20130714.111352]   All required 'pre' hooks have been run
[20130714.111352]   No RPMS need to be uninstalled
[20130714.111352]   Installing new rpms: cpanel-perl-514-munin-1.4.7-8.cp1136.x86_64.rpm cpanel-perl-514-Cache-Cache-1.06-1.cp1136.x86_64.rpm
[20130714.111352]   error: Failed dependencies:
[20130714.111352]   	MySQL-server is needed by cpanel-perl-514-munin-1.4.7-8.cp1136.x86_64
[20130714.111352] W Error Code: 2
[20130714.111352] E The following possible errors were detected while installing RPMs:
[20130714.111352] E Failed dependencies
[20130714.111352]   The Administrator will be notified to review this output when this script completes
[20130714.111352]   Checking for and running RPM::Versions 'post' hooks for any RPMs just installed
[20130714.111352]   All required 'post' hooks have been run
Done

Process Complete

Since MariaDB is drop in replacement for MySQL, is there any way I can change cPanel's install script for Munin to not check for mySQL?

 

[cPanelMichael]

Hello

While implementing MariaDB with cPanel/WHM is very straightforward, it's not officially supported. Thus, issues like this are to be expected. I am not aware of any workarounds to have the Munin plugin installed on a server with MariaDB, however you could install a standalone instance of Munin directly to your server.

Thank you.

 

[iRakic]

Thank you Michael for your respond.

Can you please point me to the script that is used to install Munin?

 

[cmanns]

Hello

While implementing MariaDB with cPanel/WHM is very straightforward, it's not officially supported. Thus, issues like this are to be expected. I am not aware of any workarounds to have the Munin plugin installed on a server with MariaDB, however you could install a standalone instance of Munin directly to your server.

Thank you.

Issues like this shouldn't happen.

Thank you Michael for your respond.

Can you please point me to the script that is used to install Munin?

I work for XenServ & used to be MariaDB RPM Package Maintainer.

If you installed MariaDB via yum, properly- it should work just dandy.

I have no traces of MySQL rpms on any systems, yet the Munin plugin installs fine. However I suggest if your graphing because your systems X utilized and faces slow downs, munin locally does bout 10-15% cpu utilization and some IOWait, etc every X minutes you set it too. I further more would suggest installing the munin plugin, removing. Forcing install of munin-node in CentOS RPM for your version OS. Then graph that with a munin 2.0 master, keep the html in normal mode, and the graph in CGI mode.

So as said, cPanel plugins install Munin works fine here with MariaDB and has for years. So MariaDB is not the root of your problem.

--! Edit

Please don't remove Munin plugin via cPanel and install via Yum. It will work but easier to get install going via cPanel plugin, then disable. I just installed on another system, and it works, then disabled.

What were you doing when given that error? My only 2 assumptions is as cPanel is moving to messy RPM's, now this issue has came up.

Solution: cPanel allows MariaDB-Server to satisfy dependency MySQL-Server, I was working on building RPM's for cPanel and what not but then they wanted to send support to me. It's a direct MySQL drop in nearly, I've used it with cPanel before it was the thing, never an issue due to MariaDB. Thanks for trying it

- Will C. Manns @ XenServ

 

[iRakic]

Will,

Thank you for your input.

I have other servers where MariaDB and Munin are working without problems, but I have installed first Munin (when MySQL was installed on server) and then MariaDB. Now what I have is MariaDB installed first on server, and Munin later.

I'm looking how to skip MySQL dependency as you can see in my error log below:

[20130714.111352]   error: Failed dependencies:
[20130714.111352]   	MySQL-server is needed by cpanel-perl-514-munin-1.4.7-8.cp1136.x86_64

 

[cPanelMichael]

I suggest opening a feature request to allow for Munin installations when MariaDB is used as a replacement for MySQL:

Submit A Feature Request

Thank you.

 

[cmanns]

I just faced this on one of our main servers.

Feel like finally putting a write up on changing Munin cPanel to Munin 2.0 FCGI.

I installed Munin on a DNSOnly and it ended up being different install slightly? So I will probably guide using Nginx + Munin 2.0 I used to do it on .deb based was easy.

Oddly the cPanel DNSOnly had MariaDB & Munin, but still installed. My WHM/cPanel Munin is currently broken, Munin does process a load so may as well move it.

 

[d_t]

Any update? I'm running 11.46.1 (build 3) and the problem still appear.

I manage to install munin using cPanel's RPM but now I get

# /usr/local/cpanel/3rdparty/share/munin/plugins/mysql_ suggest
Missing dependency Cache::Cache at /usr/local/cpanel/3rdparty/share/munin/plugins/mysql_ line 716.

even if cpanel-perl-514-Cache-Cache-1.06-1.cp1146.x86_64 is installed.

 

[cPanelMichael]

Please note that MariaDB is officially supported in cPanel version 11.48:

11.48 Release Notes - MariaDB

You may want to revert your custom implementation of MariaDB and consider utilizing the "MySQL Upgrade" option to convert over to MariaDB so it's supported after you update to cPanel version 11.48 (It's currently on in the Edge and Current tiers).

Thank you.

 

[d_t]

Please note that MariaDB is officially supported in cPanel version 11.48.

Thank you for your answer. I'm using Percona, not MariaDB The problem is with munin rpm requirements check, not with the version of mysql i use. The rpm install script should check for mysqllib, not MySQL rpm.

 

[cPanelMichael]

Thank you for your answer. I'm using Percona, not MariaDB The problem is with munin rpm requirements check, not with the version of mysql i use. The rpm install script should check for mysqllib, not MySQL rpm.

Feel free to open a bug report for this issue if you feel it's a flaw in the product (Percona is not supported so it might not be something we can address):

Submit A Bug Report

Thank you.

 

[WebDomain.com]

Hello,

The problem still persists.
I am actually configuring a new server with MariaDB10.
It is still impossible to install MUNIN.
The error reported is about failed dependencies:

MySQL-server is needed by cpanel-perl-514-munin-1.4.7-10.cp1136.x86_64

Any workaround?

 

[cPanelMichael]

Hello,

I've not been able to reproduce this issue after enabling MariaDB through WHM and installing the Munin plugin offered by cPanel. Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.