DB Issues when installing Synology Docker

I am attempting to install passbolt in order to test it against bitwarden/vaultwarden and I am running into a connection issue on the db side of things. I ran through @mariushosting install guide several times and deleting/removing the stacks/containers but it doesn’t appear to ever work. Any advice?

Error on the DB
2023-04-03 10:41:25 227 [Warning] Access denied for user ‘root’@‘127.0.0.1’ (using password: YES)

2023-04-03 10:41:40 228 [Warning] Aborted connection 228 to db: ‘unconnected’ user: ‘unauthenticated’ host: ‘172.21.0.3’ (This connection closed normally without authentication)

2023-04-03 10:41:40 229 [Warning] Aborted connection 229 to db: ‘unconnected’ user: ‘unauthenticated’ host: ‘172.21.0.3’ (This connection closed normally without authentication)

2023-04-03 10:41:55 230 [Warning] Access denied for user ‘root’@‘127.0.0.1’ (using password: YES)

config used - version: “3.9”
services:
db:
image: mariadb:jammy
container_name: Passbolt-DB
hostname: passbolt-db
mem_limit: 512m
mem_reservation: 128m
cpu_shares: 768
security_opt:
- no-new-privileges:true
healthcheck:
test: [“CMD-SHELL”, “mysqladmin ping -P 3306 -prootpass | grep ‘mysqld is alive’ || exit 1”]
volumes:
- /volume1/docker/passbolt/db:/var/lib/mysql:rw
environment:
TZ: America/Chicago
MYSQL_ROOT_PASSWORD: rootpass
MYSQL_DATABASE: passbolt
MYSQL_USER: passboltuser
MYSQL_PASSWORD: passboltpass
restart: on-failure:5

passbolt:
image: passbolt/passbolt:latest-ce-non-root
command:
- /bin/bash
- -c
- /usr/bin/wait-for.sh -t 0 db:3306 – /docker-entrypoint.sh
container_name: Passbolt
hostname: passbolt
mem_limit: 1g
cpu_shares: 512
security_opt:
- no-new-privileges:true
healthcheck:
test: curl -f http://localhost:8080/ || exit 1
ports:
- 9475:8080
volumes:
- /volume1/docker/passbolt/gpg:/etc/passbolt/gpg:rw
- /volume1/docker/passbolt/jwt:/etc/passbolt/jwt:rw
environment:
DEBUG: false
APP_FULL_BASE_URL: xxxxx
DATASOURCES_DEFAULT_HOST: passbolt-db
DATASOURCES_DEFAULT_USERNAME: passboltuser
DATASOURCES_DEFAULT_PASSWORD: passboltpass
DATASOURCES_DEFAULT_DATABASE: passbolt
PASSBOLT_REGISTRATION_PUBLIC: true
EMAIL_DEFAULT_FROM: xxxx
EMAIL_TRANSPORT_DEFAULT_HOST: smtp.gmail.com
EMAIL_TRANSPORT_DEFAULT_PORT: 587
EMAIL_TRANSPORT_DEFAULT_USERNAME: xxxx
EMAIL_TRANSPORT_DEFAULT_PASSWORD: xxxx
EMAIL_TRANSPORT_DEFAULT_TLS: true
restart: on-failure:5
depends_on:
db:
condition: service_started

Hello, you didn’t correctly clean your docker and your firewall rules is wrong. Synology: Common Docker Issues and Fixes – Marius Hosting

2 Likes

Just performed all of these actions and confirmed it works now. Thank you