[MDEV-24862] Conflicts with mysql-common files on CentOS 8 installations Created: 2021-02-14  Updated: 2022-09-14  Resolved: 2021-04-08

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform RedHat
Affects Version/s: 10.3.27, 10.4.17, 10.5.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Thomas Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: need_feedback
Environment:

CentOS 8

Issue Links:
Duplicate
is duplicated by MDEV-29531 Conflicts with mysql-common files on ... Closed

 Description   

When trying to install MariaDB 10.5, 10.4 or even 10.3 from your repos for CentOS 8, and on the side installing postfix with SQL support, which installs mysql-common, you get conflicting files between the two packages and postfix cannot be installed (or MariaDB cannot be installed if you installed postfix first, no matter what)
This is not resolvable by any exclusions as these are dependencies.
If you install mariab 10.3.27 from the CentOS repo aside with postfix this error does not occur.

So at the moment it is not possible to use 10.4 or 10.5 together with postfix on CentOS 8.

It would be nice if this could be fixed asap.

Thanks

 Comments   
Comment by Thomas [ 2021-02-14 ]

Here the list of errors for 10.5, it looks same for 10.4 and 10.3

Error: Transaction test error:
 
  file /usr/share/mysql/charsets/Index.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp1251.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp850.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp852.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/cp866.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/dec8.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/greek.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/hp8.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/latin1.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/latin2.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/latin5.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/latin7.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/macce.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/macroman.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64
 
  file /usr/share/mysql/charsets/swe7.xml from install of mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 conflicts with file from package MariaDB-common-10.5.8-1.el8.x86_64

Comment by Sergei Golubchik [ 2021-02-17 ]

How did you install postfix? I'm trying:

[buildbot@centos8-amd64 ~]$ sudo dnf install postfix
 
Dependencies resolved.
 
================================================================================
 
 Package          Architecture    Version                 Repository       Size
 
================================================================================
 
Installing:
 
 postfix          x86_64          2:3.3.1-12.el8          BaseOS          1.4 M
 
Installing dependencies:
 
 libicu           x86_64          60.3-2.el8_1            BaseOS          8.8 M
 
 
 
Transaction Summary
 
================================================================================
 
Install  2 Packages
 
 
 
Total download size: 10 M
 
Installed size: 36 M
 
Is this ok [y/N]: y

No MySQL dependency here.

[buildbot@centos8-amd64 ~]$ sudo dnf install postfix-mysql
 
Last metadata expiration check: 0:01:43 ago on Wed 17 Feb 2021 08:10:46 PM UTC.
 
Dependencies resolved.
 
================================================================================
 
 Package                       Arch      Version             Repository    Size
 
================================================================================
 
Installing:
 
 postfix-mysql                 x86_64    2:3.3.1-12.el8      AppStream     54 k
 
Installing dependencies:
 
 mariadb-connector-c           x86_64    3.1.11-2.el8_3      AppStream    200 k
 
 mariadb-connector-c-config    noarch    3.1.11-2.el8_3      AppStream     15 k
 
 
 
Transaction Summary
 
================================================================================
 
Install  3 Packages
 
 
 
Total download size: 268 k
 
Installed size: 540 k
 
Is this ok [y/N]: y

No MySQL dependency here either.

[buildbot@centos8-amd64 ~]$ cat /etc/centos-release
 
CentOS Linux release 8.2.2004 (Core)

Comment by Thomas [ 2021-02-17 ]

I installed it from Ghettoforge Repo, as I need the latest version.
So it is the direct CentOS Third Partz repo if you want.
Ah I just saw that it uses mariadb-connector-c, the direct version uses mysql-libs and mysql-common as far as I recall, so therefore the conflicts I think

Comment by Thomas [ 2021-02-17 ]

Is there anything that can be done so these conflicts do not happen then?

Comment by Daniel Black [ 2021-02-17 ]

It appears Ghettoforge's postfix3-mysql depends on libmysqlclient.so.21
https://centos.pkgs.org/8/ghettoforge-testing-x86_64/postfix3-mysql-3.5.9-1.gf.el8.x86_64.rpm.html

Packaged mariadb-connector-c don't provide the same library https://pkgs.org/download/mariadb-connector-c

compared to postfix-mysql (appstream)
https://centos.pkgs.org/8-stream/centos-appstream-x86_64/postfix-mysql-3.5.8-1.el8.x86_64.rpm.html

Do you need it? Maybe the Ghettoforge can help by packaging it similar to the CentOS appstream.

Technically the mysqlclient can connect to the MariaDB server. Installing the server with the mysqlclient libraries might be awkward, however there are binary tarballs of MariaDB server.

Comment by Thomas [ 2021-02-18 ]

Yea sadly I need a higher version than provided by RedHat in this case.
Ok I will try to reach out to the GhettoForge people then and ask if they could make a package for/with mariadb-connector

Comment by Thomas [ 2021-02-18 ]

But there is one more thing that is not clear to me.
Using the mariadb version from appstream on CentOS 8, and then using postfix3 from GF repo does not lead to any conflicts although using the same combination and postfix3 using mysql-libs and mysql-common,
Only when using mariadb from your CentOS repos leads to this conflicts, so there has to be something different in the way it is packaged by you and by RHEL. And this has nothing to do with the thing that postfix3 uses mysql.
So right now I can decide if I use the newest version of mariadb or of postfix because both do not work.
The combination of appstream with either one of the newest versions does though

Comment by Peter Ajamian [ 2021-03-13 ]

This has been fixed in GhettoForge gf-testing repo postfix3-mysql-3.5.9-2.gf.el8.x86_64.rpm.

Comment by Sergei Golubchik [ 2021-04-08 ]

I'll close this ticket, as it appears to be no longer an issue.

Comment by David Forbush [ 2022-09-14 ]

serg

The issue is still very much present with dovecot23-mysql as of a year later. Please see MDEV-29531.

Generated at Thu Feb 08 09:33:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.