How to start docker image on managed service with managed db

Checklist
I have read intro post: About the Installation Issues category
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue

Hello,

i’m struggling with the installation of Passbolt since a day or two. I have tried to use Digitalocean App Platform and also Northflank. On both provider i have added a Docker deployment with passbolt/passbolt:latest.

Env variables i have set:

APP_FULL_BASE_URL=“…”
DATASOURCES_DEFAULT_PORT=“3306”
DATASOURCES_DEFAULT_HOST=“primary.pwd-manager-db–46t2q6hrgn4w.addon.code.run”
DATASOURCES_DEFAULT_PASSWORD=“a4f0a906d336d04750ac2cedc3502d”
DATASOURCES_DEFAULT_USERNAME=“53a45c2bfa3ce881”
DATASOURCES_DEFAULT_DATABASE=“4546907862ab”

The above creds only work on the Northflank network i have created so i didn’t removed them. I have tried to change the DATASOURCES_DEFAULT_HOST env to DATASOURCES_DEFAULT_URL but in that case the docker container just crash.

Error i see on console:

2024-01-10T21:52:19.325415785Z stdout F 2024-01-10 21:52:19 error: [Cake\Database\Exception\MissingConnectionException] Connection to Mysql could not be established: SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Driver.php on line 133

2024-01-10T21:52:19.325453697Z stdout F Caused by: [PDOException] SQLSTATE[HY000] [3159] Connections using insecure transport are prohibited while --require_secure_transport=ON. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Driver.php on line 121

2024-01-10T21:52:20.019293441Z stdout F 2024-01-10 21:52:20 error: Could not connect to Database.

The big question is: How to run the docker image on managed services like do app platform or northflank with managed database?

The error seems to point to the database connection not being secure. From the northflank docs it seems like you can create databases with or without TLS, do you remember which you chose?

1 Like

This solved the issue, recreated the DB without TLS and its working now. One more question. I do not see an env var to set database adapter postgres or mysql. Is there a way to use postgres just by setting an env var?

I think our postgres compose file will be what you are looking for here