Topic: MariaDB 10.10.2 or later for SMEServer 10

[wdepot]

Is it possible to add MariaDB 10.10.2 or later to SMEServer 10? The contribs only go up to version 10.5 and I'm working on something that could use the uca1400_ai_ci collation that wasn't added to MariaDB until version 10.10.2. Ideally I would want to add some version of MariaDB 11 since that is the current stable version. I really only need access to it from PHP (I'll be using version 8.3 from the Webhosting contrib) via a socket as is done with the MariaDB 10.5 contribution and would need to be able to use SME Server's phpMyAdmin with it as well.

I'm trying to prepare in advance for SME Server 11 which I assume will use more current versions of PHP and MariaDB.

[Jean-Philippe Pialasse]

SME 10 is based on Centos 7 .
we rely on software collection to provide the extra version of mariadb, maximum version offered by RH was rh-mariadb105


SME11 will rely on Rocky 8 and hence up to  php 8.0 using modules  and  mariadb-10.5. Also remi will be kept as source for php fpm versions


you can still try to play with https://downloads.mariadb.com/MariaDB/
but the result is that core packages relying on mariadb 5.5 on SME10 will  fail, also the current script to load mariadb will fail with higher version .

also we rely on epel version of phpmyadmin and it will liekly not support edge version of mariadb.

That is the point of using SME and enterprise linux solutions, they are build to last on robust versions, not to surf on edge softwares

[Jean-Philippe Pialasse]

also this source says uca1400_ai_ci

uca1400_ai_ci

In 23.08 ES, 23.07 ES:

    A collation for the NULL character set.

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

    Not present


https://mariadb.com/docs/server/ref/mdb/collations/uca1400_ai_ci/