Hi all, I'm trying to get my docker compose to run...
# support-questions-legacya
arnmishra
03/13/2023, 6:01 PMHi all, I'm trying to get my docker compose to run properly but have been facing the following error. Not sure why it can't detect the correct password/database:
Copy code
2023-03-14 09:52:34 2023-03-14 16:52:34.972 UTC [129] FATAL: role "doss-username" does not exist
2023-03-14 09:52:39 2023-03-14 16:52:39.086 UTC [131] FATAL: password authentication failed for user "doss-username"
2023-03-14 09:52:39 2023-03-14 16:52:39.086 UTC [131] DETAIL: Role "doss-username" does not exist.
2023-03-14 09:52:39 Connection matched pg_hba.conf line 99: "host all all all md5" Copy code
version: '3.8'
services:
# Database for developers running app locally
doss-postgres-local:
platform: linux/amd64
container_name: doss-postgres-local
image: postgis/postgis:12-3.3
environment:
POSTGRES_USER: doss-username
POSTGRES_PASSWORD: doss-password
POSTGRES_DB: doss-localdb
PGDATA: /var/lib/postgresql/data
ports:
- 5432:5432
networks:
- app_network
volumes:
- doss-localdb:/var/lib/postgresql/data
restart: unless-stopped
healthcheck:
test: ['CMD', 'pg_isready', '-U', 'doss-username']
interval: 5s
timeout: 5s
retries: 5
cap_add:
- NET_ADMIN
supertokens:
image: registry.supertokens.io/supertokens/supertokens-postgresql:4.4
depends_on:
doss-postgres-local:
condition: service_healthy
ports:
- 3567:3567
environment:
POSTGRESQL_CONNECTION_URI: 'postgresql://doss-username:doss-password@doss-postgres-local:5432/doss-localdb'
networks:
- app_network
restart: unless-stopped
healthcheck:
test: >
bash -c 'exec 3<>/dev/tcp/127.0.0.1/3567 && echo -e "GET /hello HTTP/1.1\r\nhost: 127.0.0.1:3567\r\nConnection: close\r\n\r\n" >&3 && cat <&3 | grep "Hello"'
interval: 10s
timeout: 5s
retries: 5r
rp_st
03/14/2023, 5:07 AMHey @arnmishra
rp_st
03/14/2023, 5:09 AMYou are using doss-local instead of doss-postgres-local
a
arnmishra
03/14/2023, 4:49 PMhm? The user is supposed to be doss-local right? That’s what
POSTGRES_USERarnmishra
03/14/2023, 4:50 PMI tried changing all instances of doss-local to doss-postgres-local just to test and it still doesn’t work with the same error.
arnmishra
03/14/2023, 4:54 PMI updated the dockerfile in the initial post with
doss-usernamearnmishra
03/14/2023, 11:42 PMhallelujah! figured it out with some help from chat gpt 4. for some reason the roles were actually just not being created - the solution was to remove the dashes from the username, password, and db names and now it works?
arnmishra
03/14/2023, 11:43 PMupdated (functional) docker-compose:
Copy code
version: '3.8'
services:
doss-postgres-local:
platform: linux/amd64
container_name: doss-postgres-local
image: postgis/postgis:12-3.3
environment:
POSTGRES_USER: dossUsername
POSTGRES_PASSWORD: dossPassword
POSTGRES_DB: dossLocaldb
PGDATA: /var/lib/postgresql/data
ports:
- 5432:5432
networks:
- app_network
volumes:
- dossLocaldb:/var/lib/postgresql/data
restart: unless-stopped
healthcheck:
test: ['CMD-SHELL', 'pg_isready -U doss-username']
interval: 5s
timeout: 5s
retries: 5
cap_add:
- NET_ADMIN
supertokens:
image: registry.supertokens.io/supertokens/supertokens-postgresql:4.4
depends_on:
doss-postgres-local:
condition: service_healthy
ports:
- 3567:3567
environment:
POSTGRESQL_CONNECTION_URI: 'postgresql://dossUsername:dossPassword@doss-postgres-local:5432/dossLocaldb'
networks:
- app_network
restart: unless-stopped
healthcheck:
test: >
bash -c 'exec 3<>/dev/tcp/127.0.0.1/3567 && echo -e "GET /hello HTTP/1.1\r\nhost: 127.0.0.1:3567\r\nConnection: close\r\n\r\n" >&3 && cat <&3 | grep "Hello"'
interval: 10s
timeout: 5s
retries: 5r
rp_st
03/15/2023, 5:16 AMoh awesome!
20 Views