CWP Pro in Almalinux 8: Skip MariaDB offering to upgrade to almost same version

[fvnet]

Hello dear friends.
I also re-installed my Hetzner server using AL8 and the CWOP Pro and everything works OK. I also did the upgrade to MariaDB 10.11 using this as help (it needs attention though, not that straightforward but anyway)
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/

Now the dashboard states: MySQL version: 10.11.13-MariaDB
The YUM offers me to upgrade to 10.11.13-1.el8 which fails
Honestly i don't mind not upgrading, but it bothers me that when there are other updates the Update All button doesn't work due to MariaDB. Any way to overcome this??

Code Select Expand


Last metadata expiration check: 2:29:12 ago on Mon May 26 07:12:20 2025.
Dependencies resolved.
================================================================================
Package               Architecture  Version               Repository      Size
================================================================================
Upgrading:
MariaDB-server        x86_64        10.11.13-1.el8        mariadb         28 M

Transaction Summary
================================================================================
Upgrade  1 Package

Total size: 28 M
Downloading Packages:
[SKIPPED] MariaDB-server-10.11.13-1.el8.x86_64.rpm: Already downloaded         
Running transaction check
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'yum clean packages'.


[overseer]

Did you complete the upgrade guide, or just do the mariadb client part of it, missing the server portion? Does

Code Select Expand

systemctl status mariadb.service
show
● mariadb.service - MariaDB 10.11.13 database server

[fvnet]

hmm, you are right, the server part was not updated

Any quck way to update that only? Or do I go again using the usual process?

Code Select Expand


rpm -qa|grep -i maria
MariaDB-server-10.11.11-1.el8.x86_64
MariaDB-backup-10.11.13-1.el8.x86_64
mariadb-gssapi-server-10.3.39-1.module_el8.8.0+3609+204d4ab0.x86_64
MariaDB-shared-10.11.13-1.el8.x86_64
MariaDB-devel-10.11.13-1.el8.x86_64
MariaDB-client-10.11.13-1.el8.x86_64
MariaDB-common-10.11.13-1.el8.x86_64



[overseer]

You could try the relevant portion of the guide pertaining to the server section. I followed the whole thing at once.

[fvnet]

OK, i re-did the whole manual upgrade.
For any friends wanting to do the same here are the steps for Alma Linux 8(based on the https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/ )

First, backup your current my.cnf config :

cp /etc/my.cnf /etc/my.cnf.bak

Remove MariaDB 10.0/10.1/10.2/10.3/10.xx :

Code Select Expand

systemctl stop mariadb mysql mysqld
systemctl disable mariadb
rpm --nodeps -ev MariaDB-server

then run the following to view remaining mariadb instalaltions

Code Select Expand

rpm -qa|grep -i maria

remove the remaining by using rpm --nodeps -ev
for example

Code Select Expand

rpm --nodeps -ev MariaDB-client

follow the above external forum link to install the latest mariadb

in the end i had these

Code Select Expand

rpm -qa|grep -i maria
MariaDB-common-10.11.13-1.el8.x86_64
MariaDB-client-10.11.13-1.el8.x86_64
MariaDB-server-10.11.13-1.el8.x86_64
MariaDB-shared-10.11.13-1.el8.x86_64


[fvnet]

P.S in my case i removed the

MariaDB-backup-10.11.13-1.el8.x86_64
mariadb-gssapi-server-10.3.39-1.module_el8.8.0+3609+204d4ab0.x86_64
MariaDB-devel-10.11.13-1.el8.x86_64

They were not re-installed but I am not sure if they were needed.
Could someone advise whether they were actually needed or not??

[overseer]

They're not needed unless you need them
Seriously though, I would install MariaDB-backup. It is included in a a common full-featured install of MariaDB:

Code Select Expand

yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common