MariaDB Alma 10 beta, upgrading Mariadb fails

There should be a log for the menu run at /root/centminlogs//centminmod_${SCRIPT_VERSION}_${DT}_mariadb_1011-to-114_upgrade.log so. you can find specific file(s) in /root/centminlogs using grep

Code (Text):

ls -lAh /root/centminlogs/ | grep '_mariadb_1011-to-114_upgrade.log'

sanitize file if any private info and share it on gist.github.com etc

But I suspect is, you haven't setup up in persistent config file /etc/centminmod/custom_config.inc the variable yet

Code (Text):

ENABLE_MARIADBELEVENFOURUPGRADE='y'

11.8 has

Code (Text):

ENABLE_MARIADBELEVENEIGHTUPGRADE='y'

For 10.6 and 10.11 we can jump to 11.4 and 11.8 directory unlike prior versions

 

Ah I remember now, AlmaLinux 10 early development didn't have official MariaDB YUM repo, so had to install with native AlmaLinux MariaDB 10.11 server IIRC. So could be some minor differences in how Centmin Mod menu option upgrades detect the output MariaDB version as the binary names are different for native EL10 vs MariaDB YUM repo packages. I have to check if MariaDB has official EL10 YUM repo now and update 141.00beta01 for this.

edit: yeah AlmaLinux/Rocky Linux 10 don't have MariaDB 10.11/11.4/11.8 YUM repo packages yet as EL10 is still new Index of /yum/10.11/ so Centmin Mod 141.00beta01 is using native MariaDB 10.11 that comes with OS right now

 

No idea from link above MariaDB repos still don't have AlmaLinux 10 version support

 

Strange location to put them as specific versions. Could be temp staging locations until they move them? Thanks for the heads up though!

 

Ah wasn't there when I last looked!

 

Should work in Centmin Mod 141.00beta01 - while I was at it, also added MariaDB 12.3 LTS Release Candidate version support - not ready for GA production live use yet but preparing for it.

Code (Text):

--------------------------------------------------------
     MariaDB MySQL Upgrade & Management Sub-Menu      
--------------------------------------------------------
0). Regenerate New MySQL Root User Password (local server)
1). MariaDB 5.2.x Branch Upgrade Only
2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
7). MariaDB 10.2.x to MariaDB 10.3.x YUM upgrade
8). MariaDB 10.3.x to MariaDB 10.4.x YUM upgrade
9). MariaDB 10.4.x to MariaDB 10.5.x YUM upgrade
10). MariaDB 10.5.x to MariaDB 10.6.x LTS YUM upgrade
11). MariaDB 10.6.x to MariaDB 10.11.x LTS YUM upgrade
12). MariaDB 10.6.x to MariaDB 11.4.x LTS YUM upgrade
13). MariaDB 10.6.x to MariaDB 11.8.x LTS YUM upgrade
14). MariaDB 10.11.x to MariaDB 11.4.x LTS YUM upgrade
15). MariaDB 10.11.x to MariaDB 11.8.x LTS YUM upgrade
16). MariaDB 11.4.x to MariaDB 11.8.x LTS YUM upgrade
17). MariaDB 10.11.x to MariaDB 12.3.x LTS YUM upgrade
18). MariaDB 11.4.x to MariaDB 12.3.x LTS YUM upgrade
19). MariaDB 11.8.x to MariaDB 12.3.x LTS YUM upgrade
20). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 20 ]
--------------------------------------------------------

Only use MariaDB 12.3 for test non-live. You'd need persistent config /etc/centminmod/custom_config.inc variables to enable them though

Code (Text):

ENABLE_MARIADBELEVENFOURUPGRADE='y'
ENABLE_MARIADBELEVENEIGHTUPGRADE='y'
ENABLE_MARIADBTWELVETHREEUPGRADE='y'

Code (Text):

mariadb-admin ver
mariadb-admin from 12.3.1-MariaDB, client 10.0 for Linux (x86_64)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          12.3.1-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 5 min 50 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 17  Open tables: 10  Queries per second avg: 0.011

 

Interesting will check why

 

I see now, you used the wrong variable. The one you used is only for centmin.sh menu option 11 not for initial Centmin Mod installs.

To select a non-default MariaDB version on fresh installs, set ONE of these variables in /etc/centminmod/custom_config.inc before running the installer:

Code (Text):

MARIADB_INSTALLTWELVETHREE='y' # MariaDB 12.3
MARIADB_INSTALLELEVENEIGHT='y' # MariaDB 11.8
MARIADB_INSTALLELEVENFOUR='y' # MariaDB 11.4
MARIADB_INSTALLTENELEVEN='y' # MariaDB 10.11
MARIADB_INSTALLTENSIX='y' # MariaDB 10.6 

OS defaults without override:
EL8/EL9 = MariaDB 10.6, EL10 = MariaDB 10.11.

MariaDB 11.8/12.3 only available in 141.00beta01 though

 

Thanks for feedback. As you're a premium user, also check out https://community.centminmod.com/threads/new-centminmod-com-site-redesign-previews.31092/