Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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.

SOLVED MySQL56 conflicts with file from package MariaDB-server

Discussion in 'Database Discussions' started by maverickws, Dec 13, 2017.

  1. maverickws

    maverickws Registered

    Joined:
    Dec 13, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lisbon
    cPanel Access Level:
    Root Administrator
    Hi,

    I manage several servers and currently I'm facing a problem with a DNS-Only server in Europe.
    I'm trying to update cPanel DNS-ONLY and it fails due to several conflicts with MySQL version:

    MySQL56-server-5.6.37-1.cp1156.x86_64 conflicts with file from package MariaDB-server-10.1.29-1.el7.centos.x86_64

    I have another DNS-ONLY server in North America with MariaDB (10.0.33) and it updates just fine, no issues what so ever.

    Can someone point me on what steps to take to fix this? thanks.
    Ricardo
     
  2. maverickws

    maverickws Registered

    Joined:
    Dec 13, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lisbon
    cPanel Access Level:
    Root Administrator
    I can't seem to be able to post the log, so here's a couple of lines
    file /usr/bin/mysqlslap from install of MySQL56-client-5.6.37-1.cp1156.x86_64 conflicts with file from package MariaDB-client-10.1.29-1.el7.centos.x86_64
    file /usr/share/man/man1/msql2mysql.1.gz from install of MySQL56-client-5.6.37-1.cp1156.x86_64 conflicts with file from package MariaDB-client-10.1.29-1.el7.centos.x86_64
    file /usr/share/man/man1/mysql.1.gz from install of MySQL56-client-5.6.37-1.cp1156.x86_64 conflicts with file from package MariaDB-client-10.1.29-1.el7.centos.x86_64
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,693
    Likes Received:
    1,703
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Please post the output from the following commands:

    Code:
    rpm -qa|grep MariaDB
    rpm -qa|grep MySQL
    grep mysql-version /var/cpanel/cpanel.config
    grep MySQL /usr/local/cpanel/etc/rpm.versions|grep installed
    grep MariaDB /usr/local/cpanel/etc/rpm.versions|grep installed
    
    Thank you.
     
  4. maverickws

    maverickws Registered

    Joined:
    Dec 13, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lisbon
    cPanel Access Level:
    Root Administrator
    Hi cPanel Michael, thank you for your reply!

    As requested, here's the output from the mentioned commands:

    [root@two scripts]# rpm -qa|grep MariaDB
    MariaDB-server-10.1.29-1.el7.centos.x86_64
    MariaDB-common-10.1.29-1.el7.centos.x86_64
    MariaDB-client-10.1.29-1.el7.centos.x86_64
    MariaDB-shared-10.1.29-1.el7.centos.x86_64
    [root@two scripts]# rpm -qa|grep MySQL
    cpanel-perl-524-MySQL-Diff-0.50-1.cp1162.x86_64
    compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
    perl-DBD-MySQL-4.023-5.el7.x86_64
    compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
    [root@two scripts]# grep mysql-version /var/cpanel/cpanel.config
    mysql-version=5.6
    [root@two scripts]# grep MySQL /usr/local/cpanel/etc/rpm.versions|grep installed
    MySQL50: uninstalled
    MySQL51: uninstalled
    MySQL55: uninstalled
    MySQL56: uninstalled
    [root@two scripts]# grep MariaDB /usr/local/cpanel/etc/rpm.versions|grep installed
    MariaDB100: uninstalled
    MariaDB101: uninstalled
    MariaDB102: uninstalled
    [root@two scripts]#
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,693
    Likes Received:
    1,703
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Since MariaDB 10.1 is installed, you can modify the "mysql-version" line in /var/cpanel/cpanel.config so that it looks like this:

    Code:
    mysql-version=10.1
    Then, run the following command:

    Code:
    /usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MariaDB101 installed
    Let us know if this helps to solve the issue.

    Thank you.
     
  6. maverickws

    maverickws Registered

    Joined:
    Dec 13, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Lisbon
    cPanel Access Level:
    Root Administrator
    Worked beautifully, thank you!

    [2017-12-14 09:13:38 +0100] Completed all updates
    => Log closed Thu Dec 14 09:13:38 2017
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,693
    Likes Received:
    1,703
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm glad to see that helped. Thank you for updating us with the outcome.
     
Loading...

Share This Page