Control Web Panel
WebPanel => Updates => Topic started by: mabdala68 on August 21, 2023, 12:58:48 PM
-
Did someone have trouble updating MariaDB? The Server component is not updating for me. The "mariadb-server" package remains in version 10.11, while "mariadb-client" has been updated to version 11.
Using Almalinux 8
---------------------------------------------------------
Upgrading directly from MySQL 10.11 to MariaDB 11.0 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: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server
Verifying : MariaDB-server-11.0.3-1.el8.x86_64 1/2
Verifying : MariaDB-server-10.11.3-1.el8.x86_64 2/2
Failed:
MariaDB-server-10.11.3-1.el8.x86_64 MariaDB-server-11.0.3-1.el8.x86_64
Error: Transaction failed
-
Yes, I posted about that, that upgrading to MariaDB 11.x doesn't work.
Maria 10.11.x does though.
Nothing should have upgraded to 11.x unless you changed the mariadb.repo to download & install 11.x.
Not sure where you got those instructions from, but they are wrong for CWP.
The official MariaDB upgrade instructions can be found at: https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version
Where it is only safe to change the .repo up to 10.11
-
/////Not sure where you got those instructions from, but they are wrong for CWP. ////
running yum -y update from SSH console, I got that message.
I also tried changing the repository, but it doesn't work either.
-
Yea, that's not how yum/dnf update works.
Not to mention your post shows some kind of script was run - "error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1"
MySQL doesn't get installed with CWP, or even with the minimal install of AL 8 or 9.
Something else was done manually, since when you should be running dnf (not yum on 8.x/9.x) it refers to the .repo file for the version to be downloaded/updated.
By Default CWP installs MariaDB 10.4.x and the .repo for only that version.
Once you manually upgrade from MariaDB 10.11.x to 11.x, downgrading isn't really an option.
Best option is to start with a fresh minimal install as you should, and follow the step to step install guide that starts at:
https://control-webpanel.com/installation-instructions#step1
-
In other Server, I use the CWP Updates, and appear the same problem.
-----------------------------------------------------------------------------------
This message appear after Update :::
Update All
×
Package updated successfully.
--------------
Last metadata expiration check: 0:00:19 ago on Tue Aug 22 20:38:48 2023.
Dependencies resolved.
================================================================================
Package Architecture Version Repository Size
================================================================================
Upgrading:
MariaDB-server x86_64 11.0.3-1.el8 mariadb-main 27 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total download size: 27 M
Downloading Packages:
MariaDB-server-11.0.3-1.el8.x86_64.rpm 24 MB/s | 27 MB 00:01
--------------------------------------------------------------------------------
Total 23 MB/s | 27 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/2
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.11.3-1.el8.x86_64) is installed.
Upgrading directly from MySQL 10.11 to MariaDB 11.0 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 ' 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: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1
Verifying : MariaDB-server-11.0.3-1.el8.x86_64 1/2
Verifying : MariaDB-server-10.11.3-1.el8.x86_64 2/2
Failed:
MariaDB-server-10.11.3-1.el8.x86_64 MariaDB-server-11.0.3-1.el8.x86_64
-
That's not from CWP.
Again their repo is for 10.4 Only:
cat > /etc/yum.repos.d/mariadb.repo
# MariaDB 10.4 CentOS repository list - created 2020-06-23 23:26 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos8-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
This is directly from the Install script (cwp-el8-latest), and would have to be MANUALLY modified to another version.
NOTE: See how CWP even uses the CentOS version of MariaDB, not EL8.
It is one of the things we change after the install, we follow the wiki, and upgrade it to 10.11.x
All of our servers are running AlmaLinux 8.x, and it is NOT an upgrade from AL either.
SPAMMING the forum with your same question about some other non-CWP script you ran and corrupted your install isn't going to gain you any help or support.
Do a FRESH MINIMAL INSTALL and follow the install instructions, and leave it alone.
-
make the change in /etc/yum.repos.d/mariadb.repo and it works perfect !
thanxss !!!!