Control Web Panel
WebPanel => MySQL => Topic started by: fvnet on May 26, 2025, 07:44:48 AM
-
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??
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'.
-
Did you complete the upgrade guide, or just do the mariadb client part of it, missing the server portion? Does
systemctl status mariadb.serviceshow
● mariadb.service - MariaDB 10.11.13 database server
-
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?
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
-
You could try the relevant portion of the guide pertaining to the server section. I followed the whole thing at once.
-
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 :
systemctl stop mariadb mysql mysqld
systemctl disable mariadb
rpm --nodeps -ev MariaDB-server
then run the following to view remaining mariadb instalaltions
rpm -qa|grep -i maria
remove the remaining by using rpm --nodeps -ev
for example rpm --nodeps -ev MariaDB-client
follow the above external forum link to install the latest mariadb
in the end i had these
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
-
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??
-
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:
yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common