SOLVED MySQL56 conflicts with file from package MariaDB-server

maverickws

Member
Dec 13, 2017
22
4
3
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
 

maverickws

Member
Dec 13, 2017
22
4
3
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
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.
 

maverickws

Member
Dec 13, 2017
22
4
3
Lisbon
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
Hello,

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