Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: Linux on October 27, 2025, 11:18:55 PM

Title: Can't update linux OS because of mysql-common
Post by: Linux on October 27, 2025, 11:18:55 PM

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


Title: Re: Can't update linux OS because of mysql-common
Post by: overseer on October 27, 2025, 11:27:49 PM

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

Title: Re: Can't update linux OS because of mysql-common
Post by: Linux on October 28, 2025, 06:20:52 PM

Quote from: overseer on October 27, 2025, 11:27:49 PM

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!


Title: Re: Can't update linux OS because of mysql-common
Post by: cyberspace on October 28, 2025, 10:27:51 PM

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.

Title: Re: Can't update linux OS because of mysql-common
Post by: overseer on October 28, 2025, 11:31:14 PM

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

Title: Re: Can't update linux OS because of mysql-common
Post by: Linux on November 01, 2025, 03:49:35 PM

Quote from: cyberspace on October 28, 2025, 10:27:51 PM

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.

Title: Re: Can't update linux OS because of mysql-common
Post by: Starburst on November 01, 2025, 04:30:17 PM

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

Title: Re: Can't update linux OS because of mysql-common
Post by: Linux on November 04, 2025, 12:04:51 PM

Quote from: Starburst on November 01, 2025, 04:30:17 PM

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.

Title: Re: Can't update linux OS because of mysql-common
Post by: overseer on November 04, 2025, 05:23:14 PM

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.

Title: Re: Can't update linux OS because of mysql-common
Post by: XHOST on November 20, 2025, 02:40:55 AM

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.