[TikiWiki-commits] [Git][tikiwiki/tiki][master] [ENH] Update MariaDB and MySQL version support in CI configuration

Benoit Grégoire pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
ba81eb11 by Sandeep D at 2026-01-19T19:29:38+00:00
[ENH] Update MariaDB and MySQL version support in CI configuration
---
* [ENH] Update MariaDB and MySQL version support in CI configuration

See merge request tikiwiki/tiki!9345

- - - - -


1 changed file:

- .gitlab-ci.yml


Changes:

=====================================
.gitlab-ci.yml
=====================================
@@ -21,10 +21,15 @@ variables:
   #The schemas dumped for prior tikis on https://gitlab.com/tikiwiki/tikiwiki-ci-databases have explicit COLLATION() statements for each table column.  Later versions of mysql (8.0.11+, but not sure) will not dump the same whits explicit collations.
   #Running php doc/devtools/check_schema_upgrade.php -m 22 --db1=tiki:tiki@localhost:tikiold --db2=tiki:tiki@localhost:tikinew gives other errors localy that are false positives.  But locally, unless you decompress https://gitlab.com/tikiwiki/tikiwiki-ci-databases into doc/devtool/dbdiff/cache, tiki.org won't give the schemas to you, and will blacklist your IP address!  benoitg - 2023-05-16
 
-  MARIADB_IMAGE_NEWEST_SUPPORTED: mariadb:10.11.7
+  # Database Version Testing Strategy:
+  # - OLDEST versions: Minimum compatibility baseline, ensures backward compatibility
+  # - COMMON LTS: Widely deployed versions, provides stable testing baseline
+  # - NEWEST LTS: Future-proofing, tests latest LTS features and compatibility
   MARIADB_IMAGE_OLDEST_SUPPORTED: mariadb:10.5.11
-  MYSQL_IMAGE_NEWEST_SUPPORTED: mysql:8.0.36
+  MARIADB_IMAGE_COMMON_LTS: mariadb:10.11.15
+  MARIADB_IMAGE_NEWEST_SUPPORTED: mariadb:11.8.5
   MYSQL_IMAGE_OLDEST_SUPPORTED: mysql:8.0.29
+  MYSQL_IMAGE_NEWEST_SUPPORTED: mysql:8.4.7
   MANTICORE_NEWEST_SUPPORTED: 15.1.0
   #Only for older version upgrade tests these days
   MYSQL_5_IMAGE: mysql:5.7.44
@@ -439,7 +444,7 @@ composer-could-update-lock:
   <<: *template-tiki-schema-upgrade
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}$IMAGE
-      command: [ "--default-authentication-plugin=mysql_native_password", "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
+      command: [ "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
       alias: mysql
 
 db-upgrade-28-mysql:
@@ -541,7 +546,7 @@ console-php-works:
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}${DB_IMAGE}
       alias: mysql
-      command: ["--default-authentication-plugin=mysql_native_password", "--explicit-defaults-for-timestamp=off"]
+      command: ["--explicit-defaults-for-timestamp=off"]
     - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
       alias: elasticsearch
     - name: ${DEPENDENCY_PROXY_PREFIX}manticoresearch/manticore:${MANTICORE_NEWEST_SUPPORTED}
@@ -576,7 +581,7 @@ unit-tests:
       - PHP_VERSION: "8.1"
         DB_IMAGE: ${MARIADB_IMAGE_OLDEST_SUPPORTED}
       - PHP_VERSION: "8.3"
-        DB_IMAGE: ${MARIADB_IMAGE_NEWEST_SUPPORTED}
+        DB_IMAGE: ${MARIADB_IMAGE_COMMON_LTS}
       - PHP_VERSION: "8.4"
         DB_IMAGE: ${MARIADB_IMAGE_NEWEST_SUPPORTED}
       - PHP_VERSION: "8.5"



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/ba81eb115abce436592d6cc1f5a6bbc78c6d2b6c

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/ba81eb115abce436592d6cc1f5a6bbc78c6d2b6c
You're receiving this email because of your account on gitlab.com.

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs