SOLVED MySQL56 conflicts with file from package MariaDB-server

[maverickws]

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

 

[maverickws]

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

 

[cPanelMichael]

Hello,

Please post the output from the following commands:

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.

 

[maverickws]

Hi cPanel Michael, thank you for your reply!

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

[[email protected] 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
[[email protected] 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
[[email protected] scripts]# grep mysql-version /var/cpanel/cpanel.config
mysql-version=5.6
[[email protected] scripts]# grep MySQL /usr/local/cpanel/etc/rpm.versions|grep installed
MySQL50: uninstalled
MySQL51: uninstalled
MySQL55: uninstalled
MySQL56: uninstalled
[[email protected] scripts]# grep MariaDB /usr/local/cpanel/etc/rpm.versions|grep installed
MariaDB100: uninstalled
MariaDB101: uninstalled
MariaDB102: uninstalled
[[email protected] scripts]#

 

[cPanelMichael]

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:

mysql-version=10.1

Then, run the following command:

/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.

 

[maverickws]

Worked beautifully, thank you!

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

 

[cPanelMichael]

Hello,

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