SSL Handshake error when trying to connect to Azure Mysql DB

[hanneswaeckerlig]

Hi there,

I am trying to setup a wiki for the company i work at. I decided to use wiki.js for this.

I folloed the guide on the website as closly as possibel to use a dockerized version of wiki.js. Since we already have a Azure mysql db setup, i decided to use it also for the wiki. so i created a new DB called wiki and a new user called wiki with all the privileges.

After a few guide on the wiki,js website i came uf with this docker comand:

sudo docker create --name=wiki
-e DB_TYPE=mysql
-e DB_HOST=dbdbdb.mysql.database.azure.com
-e DB_PORT=3306 -e DB_USER=wiki
-e DB_PASS=password
-e DB_NAME=wiki
-e DB_SSL=1
-e DB_SSL_CA=/home/master/wiki-ssl/DigiCertGlobalRootG2.crt.pem
--restart=unless-stopped
-h wiki
-p 8081:3000
-p 8443:3443
ghcr.io/requarks/wiki:2

but when i start the container and look at its logs i always see this:

Loading configuration from /wiki/config.yml... OK
2023-12-01T13:51:39.632Z [MASTER] info: =======================================
2023-12-01T13:51:39.636Z [MASTER] info: = Wiki.js 2.5.300 =====================
2023-12-01T13:51:39.636Z [MASTER] info: =======================================
2023-12-01T13:51:39.636Z [MASTER] info: Initializing...
2023-12-01T13:51:40.595Z [MASTER] info: Using database driver mysql2 for mysql [ OK ]
2023-12-01T13:51:40.614Z [MASTER] info: Connecting to database...
2023-12-01T13:51:40.693Z [MASTER] error: Database Connection Error: HANDSHAKE_SSL_ERROR undefined:undefined
2023-12-01T13:51:40.693Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2023-12-01T13:51:43.698Z [MASTER] info: Connecting to database...
2023-12-01T13:51:43.746Z [MASTER] error: Database Connection Error: HANDSHAKE_SSL_ERROR undefined:undefined
2023-12-01T13:51:43.746Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]
...

i also tried to passe the certificate along as a string, but this did not help either.

I seem to be running out of ideas on how to get this working. Could anyone of you out there help me resolve this issue? I am happy to provide more details of needed.

Best regards, hannes