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.
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
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:
"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:
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