User Permissions / Database Creation Issues

[RR-Helpdesk]

two issues,

For some reason despite supplying variables for MYSQL, it appears the docker container ignores those and tries to create a local 1password.sqlite database.

I have tried many scenarios, typically I use USER/GROUP 1000 but have tried 999 as well and also without a USER or GROUP defined variables all ending with the same outcomes.

ENVIRONMENT:****************************************************************************************

OS: Ubuntu 22.04.3 LTS x86_64
Host: Compute Instance
Kernel: 5.15.0-78-generic
Uptime: 1 day, 18 hours, 2 mins
Packages: 2727 (dpkg), 9 (snap)
Shell: zsh 5.8.1
Resolution: 1280x800
Terminal: /dev/pts/2
CPU: AMD EPYC 7542 (2) @ 2.899GHz
GPU: 00:01.0 Vendor 1234 Device 1111
Memory: 1917MiB / 3911MiB

DOCKER COMPOSE FILE********************************************************************************

version: "3.7"

networks:
default:
external:
name: bridge
docweb:
name: docweb
external: true

services:

op-connect-api:
image: 1password/connect-api:latest
hostname: op-connect-api
container_name: op-connect-api
restart: "unless-stopped"
environment:
TZ: "America/Los_Angeles"
PUID: 1000
PGID: 1000
OP_HTTP_PORT: 8080
OP_HTTPS_PORT: 8443
MYSQL_DATABASE: "1passworddb"
MYSQL_USERNAME: "1password"
MYSQL_PASSWORD: $(op read op://rr-docker/1passworddb/password)
OP_CONNECT_HOST: "http://localhost:8080"
OP_CONNECT_TOKEN: $OP_API_TOKEN
XDG_DATA_HOME: "/home/opuser"
ports:
- "8080:8080"
networks:
- docweb
volumes:
- "/opt/docker/app_data/1password/1password-credentials.json:/home/opuser/.op/1password-credentials.json"
- "/opt/docker/app_data/1password/data:/home/opuser/.op/data"
extra_hosts:
- "host.docker.internal:host-gateway"

op-connect-sync:
image: 1password/connect-sync:latest
hostname: op-connect-sync
container_name: op-connect-sync
restart: "unless-stopped"
environment:
TZ: "America/Los_Angeles"
PUID: 999
PGID: 999
OP_HTTP_PORT: 8080
OP_HTTPS_PORT: 8443
MYSQL_DATABASE: "1passworddb"
MYSQL_USERNAME: "1password"
MYSQL_PASSWORD: $(op read op://rr-docker/1passworddb/password)
OP_CONNECT_HOST: "http://localhost:8080"
OP_CONNECT_TOKEN: $OP_API_TOKEN
XDG_DATA_HOME: "/home/opuser"
networks:
- docweb
ports:
- "8081:8080"
volumes:
- "/opt/docker/app_data/1password//1password-credentials.json:/home/opuser/.op/1password-credentials.json"
- "/opt/docker/app_data/1password/data:/home/opuser/.op/data"
extra_hosts:
- "host.docker.internal:host-gateway"

volumes:
data:

LOGFILES:*******************************************************************************************

3 | log_message=(I) starting 1Password Connect Sync ... timestamp=2023-08-11T07:49:41.525326255-07:00
3 | log_message=(I) no existing database found, will initialize at /home/opuser/.op/data/1password.sqlite timestamp=2023-08-11T07:49:41.52849658-07:00
Error: Server: (failed to OpenDefault), Wrapped: (failed to open db), unable to open database file: no such file or directory
Usage:
connect-sync [flags]
Flags:
-h, --help help for connect-sync
-v, --version version for connect-sync