Can't update linux OS because of mysql-common

Hello!
Got a message to update the os, did update but it failed with the error below.
In order to avoid that error and update the rest of the system, i used the command:

Code: [Select]

yum -x 'mysql-common-*' -x 'mysql-libs-*' update


Code: [Select]

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


Code: [Select]

rpm -qa | grep mysql-common
yum remove mysql-common
yum remove mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64

Code: [Select]

rpm -qa | grep mysql-common
yum remove mysql-common
yum remove mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64

Code: [Select]

No match for argument: mysql-common Dependencies resolved. Nothing to do. Complete!


Code: [Select]

No match for argument: mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 Dependencies resolved. Nothing to do. Complete!


When you try to update OS tries to update various system packages and seems some package requires the package MariaDB-common but it conflicts with mysql-common. I do believe you installed MySQL manually.

In order to perform update I recommend the following route:

1. Make backups of the databases
2. Remove packages related with MySQL.
3. Install MariaDB
4. Restore databases if necessary (if you see some errors associated with databases in logs).

Please note you do it on your own risk.

You could follow this guide:
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/
The key takeaway is as part of the MariaDB upgrade process, you manually remove the mysql-common package first:

Code: [Select]

rpm -e --nodeps mysql-common mysql-libs mysql-devel

When you try to update OS tries to update various system packages and seems some package requires the package MariaDB-common but it conflicts with mysql-common. I do believe you installed MySQL manually.

In order to perform update I recommend the following route:

1. Make backups of the databases
2. Remove packages related with MySQL.
3. Install MariaDB
4. Restore databases if necessary (if you see some errors associated with databases in logs).

Please note you do it on your own risk.

I'm the only person that has access to that server and I can tell you that neither I or anyone else installed MySQL. Maybe cwp scripts installed MySQL and I really wonder why.

From the beginning of the server install and config we use MariaDB v10.11.14.

More than likely you have a LAMP installed and that's why you are having problems with the DB and PHP...

More than likely you have a LAMP installed and that's why you are having problems with the DB and PHP...

Does cwp installation script install LAMP? You know it doesn't so I really don't understand why you would think about that...

It was a freshly installed cwp server 3 months ago with no mods.

What OS did you install? It's best to start with a clean AlmaLinux DVD install (not minimal and not with any options such as the LAMP profile). System-provided http (Apache) will interfere with CWP's installer script and also you don't want competing MySQL versions that interfere with the recommended MariaDB install, nor a PHP provided by another means than what CWP is offering.

Hi, i got the solution, you need to remove the module perl-DBD-MySQL, and if you use cbpolicyd you need to modify the file /etc/cbpolicyd/cluebringer.conf
in DSN=DBI:mysql:database=postfix_policyd;host=localhost
you need to put DSN=DBI:MariaDB:database=postfix_policyd;host=localhost
then you can update almalinux and still got mail server working.
the solution cost me a lot of time to figure it out.