Is MariaDB working in DIRAC? Bugged at least in CI

[Robin-Van-de-Merghel]

Issue

At least in the CI, Mariadb should not work, right?

11.0, unlike previous version, no longer includes mysql named compatible executable symlinks inside the container.

(We are using mariadb:11.4.3 in CI)

Source: https://mariadb.com/docs/release-notes/community-server/old-releases/release-notes-mariadb-11-0-series/mariadb-11-0-1-release-notes#docker-official-images

Example in DIRAC (at least CI)

Taken from check_db_initialized.sh:

allExistingDBs=$(mysql -uDirac -pDirac -h mysql -P 3306 -e "show databases;");

From utilities.sh:

diracDFCDB(){
  echo '==> [diracDFCDB]'

  mysql -u"$DB_ROOTUSER" -p"$DB_ROOTPWD" -h"$DB_HOST" -P"$DB_PORT" -e "DROP DATABASE IF EXISTS FileCatalogDB;"
  SRC_ROOT="$(python -c 'import os; import DIRAC; print(os.path.dirname(DIRAC.__file__))')"
  mysql -u"$DB_ROOTUSER" -p"$DB_ROOTPWD" -h"$DB_HOST" -P"$DB_PORT" < "${SRC_ROOT}/DataManagementSystem/DB/FileCatalogWithFkAndPsDB.sql"
}

How I found the issue

We can see the error only while doing docker logs diracx-wait-for-db...:

/home/dirac/LocalRepo/ALTERNATIVE_MODULES/DIRAC/tests/CI/check_db_initialized.sh: line 7: mysql: command not found

[Robin-Van-de-Merghel]

Fixed in #8248