MariaDB 10.4 YUM Mirror Update Fixes For EL8

MariaDB 10.4 MySQL server has been deprecated and new installs of 132.00stable and 140.00beta01 default to MariaDB 10.6 for a while now. But for existing Centmin Mod users still on MariaDB 10.4 using EL8 OSes like Rocky Linux or AlmaLinux 8, the workaround has been to use the MariaDB 10.4 archive mirrors. This issue only applies to EL8 OSes like Rocky Linux 8 or AlmaLinux 8 as EL9 OSes already defaulted to MariaDB 10.6.

However, the workaround fix for this had a bug reported by @Nik in that my workaround fix didn't account for Rackspace MariaDB 10.4 mirrors that recently got removed/deprecated as well. I have now updated Centmin Mod 131.00stable, 132.00stable and 140.00beta01 with the updated workaround fix.

Fixed Releases:

• 131.00stable
• 132.00stable
• 140.00beta01

Centmin Mod installs official MariaDB YUM repos and has own geolocation routine to setup the mirror URLs based on your server location. Some servers got official https://yum.mariadb.org/10.4 mirrors and some got https://mirror.rackspace.com/mariadb/yum/10.4 Rackspace based mirrors depending on your server's geographical location. This fix is for Rackspace base mirror setups for MariaDB 10.4.

What Went Wrong
Your /etc/yum.repos.d/mariadb.repo was pointing at Rackspace’s now-removed MariaDB 10.4 mirror example for EL8 OSes:

Code (Text):

[mariadb]
name = MariaDB
baseurl = https://mirror.rackspace.com/mariadb/yum/10.4/centos8-amd64
module_hotfixes=1
gpgkey  = https://mirror.rackspace.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
exclude = MariaDB-Galera-server

Because Rackspace dropped 10.4, YUM could no longer fetch packages or the GPG key. And this impacted other Centmin Mod functions like centmin.sh menu option 5 PHP-FPM upgrades where other YUM dependencies like libzip were needed but failed to get as MariaDB YUM repo errors got in the way.

How Centmin Mod Fixes It
On the next run of centmin.sh menu, Centmin Mod will automatically:

1. Scan /etc/yum.repos.d/mariadb.repo for any deprecated URLs (Rackspace, yum.mariadb.org, etc.)
2. Replace them with the official archive URLs:
   
   Code (Text):

   baseurl = https://archive.mariadb.org/mariadb-10.4/yum/centos8-amd64
   gpgkey  = https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
   

3. Import the new GPG key and clear the YUM cache
   
   Code (Text):

   rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
   yum -q clean all

If you're using MariaDB 10.4 MySQL server on EL8/EL9 OSes and haven't already, update to either Centmin Mod 131.00stable, 132.00stable and 140.00beta01 and then run cmupdate command to get latest fixes for these versions and then run and exit centmin.sh menu once for auto applying the workaround fix.

For MariaDB 10.4 and EL8 OSes with workaround fix applied, the updated YUM repo file /etc/yum.repos.d/mariadb.repo should look something like:

Code (Text):

[mariadb]
name = MariaDB
baseurl = https://archive.mariadb.org/mariadb-10.4/yum/centos8-amd64
module_hotfixes=1
gpgkey=https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
gpgcheck=1
exclude=MariaDB-Galera-server

Then next step is upgrade your MariaDB 10.4 MySQL server to MariaDB 10.6 as per instructions at https://community.centminmod.com/th...es-to-mariadb-10-2-10-3-10-4-10-5-10-6.17793/

---