MariaDB update problem CWP7PRO

I have tried the recent yum update for MariaDB and it failed:

Code: [Select]

Running transaction

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.2.44-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.2 to MariaDB 10.4 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.4.34-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.4.34-1.el7.centos.x86_64
MariaDB-server-10.2.44-1.el7.centos.x86_64 was supposed to be removed but is not!
  Verifying  : MariaDB-server-10.2.44-1.el7.centos.x86_64                                                                                                           1/2
  Verifying  : MariaDB-server-10.4.34-1.el7.centos.x86_64                                                                                                           2/2

Failed:
  MariaDB-server.x86_64 0:10.2.44-1.el7.centos                                       MariaDB-server.x86_64 0:10.4.34-1.el7.centos

I am hesistant to follow the instructions as removing the old mariadb package might make something inaccessible. Please take a look at this, the yum update should complete this without user interference I think.

OS/Linux distibutive installed on your server/vps ?

Centos 7

Centos 7 is EOL. Consider to migrate to Almalinux 8/9 or RockyLinux 8/9.

It isn't safe to upgrade MariaDB on Centos 7 manually.

Thanks for your input but Centos 7 is still among the recommended OS's of this panel, while el9 is still in beta.
https://control-webpanel.com/installation-instructions#step2

I will upgrade to centos 9 when beta is over. For this particular instance, I believe the devs could fix this with a patch or sth like that.

I am afraid your expectations have no sense because Centos 7 isn't supported by developers since 30 of June 2024:
https://www.redhat.com/en/topics/linux/centos-linux-eol

The problem experienced by you isn't caused by CWP. It is caused by Centos 7 because it isn't maintained. That's it. The End.

Small update for anyone who expects updates for CWP running on Centos 7:
https://forum.centos-webpanel.com/centos-7-problems/i-want-to-update-roundcube-1-5-6-but-it-fails/

For anyone experiencing the same problem, I have fixed the issue

by first:
https://serverfault.com/a/1161847/966295

and then:
https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version

Thanks for your input but Centos 7 is still among the recommended OS's of this panel, while el9 is still in beta.
https://control-webpanel.com/installation-instructions#step2

I will upgrade to centos 9 when beta is over. For this particular instance, I believe the devs could fix this with a patch or sth like that.

FYI CentOS is now a beta OS in RedHat's lineup.

Alpha - fedora
Beta - CentOS Stream
Release - RHEL

No version of CentOS is recommended.

The problem you had isn't' with CWP, RH ended CentOS 7 per their lifecycle schedule. And multiple warning posts where made in 2024.
CentOS 8 support was ended early by RH.

Same with MariaDB's lifecycle.
10.11 LTS is recommended.

I force MySQL version: 15.2

That's good you got it to work, but there is not support for using MySQL with CWP, only MariaDB.

it is MariaDB Server version: 11.2.6-MariaDB - MariaDB Server but say on panel MySQL version: 15.2 but in phpMyAdmin version: 11.2.6-MariaDB

The problem you had isn't' with CWP, RH ended CentOS 7 per their lifecycle schedule. And multiple warning posts where made in 2024.
CentOS 8 support was ended early by RH.

CWP should get partial blame here because their installation instructions literally tell people this (emphasis mine):

"CentOS 7 MINIMAL is recommended version. (RECOMMENDED STABLE)
The best version to be used with CWP as it provides the most features and CWP Secure Kernel."

Sure, in an ideal world everyone installing CWP would know that CentOS 7 is end-of-life.  But, that's not realistic.

As such, it be great if the installation instructions were revised.

Oh here we go with that old outdated mis-information.

Look at https://control-webpanel.com/installation-instructions#step4, which you had to to install CWP.

Installer for CentOS 8/stream, Alma Linux, and Rocky Linux (recommended)

For NON-SysAdmin's that don't understand "MINIMAL' is the install type.

Minimal
..
Select
..
Full

If you install the OS on a lab box, you would see all the endless installation options.

Here what the Official Step 2 is at https://control-webpanel.com/installation-instructions#step2

3. Software Requirements
You must have a clean/fresh installation of supported operating systems:

CentOS 7 MINIMAL is recommended version. (RECOMMENDED STABLE)
The best version to be used with CWP as it provides the most features and CWP Secure Kernel.

Alma Linux 8 & 9 MINIMAL or BOOT (RECOMMENDED STABLE/LATEST)
The best option in 2024 is still the AlmaLinux 8.
AlmaLinux 9 has some missing features and PHP versions are limited to PHP 7.4 or higher.  *EL9 is in beta stage

CWP-CentOS 8 MINIMAL or BOOT Stream-Delayed.
We have our custom repositories making CentOS 8 Stream a stable version. More Info

CentOS 8 & 9 Stream MINIMAL or BOOT
Direct installation or converted from CentOS 8 Linux. (Recommended) *EL9 is in beta stage

Rocky Linux 8 & 9 MINIMAL or BOOT
Compatible but with possible issues, Recommended is to use CentOS 8 Stream or CentOS 7. *EL9 is in beta stage

Using colored, bold fonts doesn't change the fact that the installation instruction are outdated.

Fact is, it does NOT recommend CentOS 7.

The instructions at https://control-webpanel.com/installation-instructions are current, and not outdated.

They Recommend:

Alma Linux 8 & 9 MINIMAL or BOOT (RECOMMENDED STABLE/LATEST)
The best option in 2024 is still the AlmaLinux 8.

You sound like that other CWP hater that got kicked off.
Wondering if your back under a different handle.

If you have a question, and need help, fine.

But if you start posting mis-information and hate about CWP you'll probably get kicked off.