[Docker Image] Cannot connect through MySQL SSL

[alesnav]

Code of Conduct

• [x] I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• [x] I have searched the existing issues

Version

GLPI 10 and GLPI 11, both

Bug description

I am trying to move from my GLPI VM to a Dockerized GLPI over Azure Kubernetes. My database is SSL-enabled only, so clear text sessions are not allowed.

Inside the configuration file of my VM, I included these two lines:

   public $dbssl = true;
   public $dbsslca = '/opt/glpi/config/DigiCertGlobalRootCA.crt.pem';

The first one is to enable SSL and the second one is to refer the SSL CA needed for the connection (in my case, provided by Microsoft Azure).

When using the GLPI Docker image, there is no parameters for this kind of SSL connection, so it is useless in a secured environment because GLPI won't be able to connect to the database.

Relevant log output

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[orthagh]

Hello.

With the current image, we use GLPI CLI console to connect the database on install/update/ This console doesn't support setting SSL connections at the moment.

An alternative to make your setup working correctly:

• declare GLPI_SKIP_AUTOINSTALL env var to disable the automatic installation of the image
• as indicated in the README, we automatically declare a volume for the config directory, so you can place your config_db.php file already with the correct values, notably with public $dbssl = true;

Let me know if it's sufficient.