The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Munin and MariaDB on cPanel

Discussion in 'General Discussion' started by iRakic, Jul 14, 2013.

  1. iRakic

    iRakic Member

    Joined:
    Sep 19, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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:
    Code:
    [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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. iRakic

    iRakic Member

    Joined:
    Sep 19, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Thank you Michael for your respond.

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

    cmanns Member

    Joined:
    Nov 22, 2006
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Issues like this shouldn't happen.

    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
     
    #4 cmanns, Jul 16, 2013
    Last edited: Jul 16, 2013
  5. iRakic

    iRakic Member

    Joined:
    Sep 19, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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:
    Code:
    [20130714.111352]   error: Failed dependencies:
    [20130714.111352]   	MySQL-server is needed by cpanel-perl-514-munin-1.4.7-8.cp1136.x86_64
    
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  7. cmanns

    cmanns Member

    Joined:
    Nov 22, 2006
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
  8. d_t

    d_t Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    243
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Bucharest
    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

    Code:
    # /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.
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  10. d_t

    d_t Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    243
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Bucharest
    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.
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  12. WEBDOMAIN.com

    WEBDOMAIN.com Active Member

    Joined:
    Jun 29, 2007
    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:
    Code:
    MySQL-server is needed by cpanel-perl-514-munin-1.4.7-10.cp1136.x86_64
    Any workaround?
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page