Docker compose issue

Question

Hi 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 ``` 2023 03 13 10 58 32 2023 03 13 17 58 32 193 UTC 119 FATAL password authentication failed for user doss local 2023 03 13 10 58 32 2023 03 13 17 58 32 193 UTC 119 DETAIL Password does not match for user doss local 2023 03 13 10 58 32 Connection matched pg hba conf line 99 host all all all md5 2023 03 13 10 58 35 2023 03 13 17 58 35 638 UTC 129 FATAL database doss local does not exist ``` with the following docker compose ``` version 3 8 services doss postgres local platform linux amd64 container name doss postgres local image postgis postgis 12 3 3 environment POSTGRES USER doss local 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 local 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 local 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 5 ```

rp · Answer

Hey < arnmishra>

rp · Answer

You are using doss local instead of doss postgres local

arnmishra · Answer

hm The user is supposed to be doss local right That s what `POSTGRES USER` is

arnmishra · Answer

I 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 · Answer

I updated the dockerfile in the initial post with `doss username` as the username to make it easier to parse through and updated the error message as well

arnmishra · Answer

hallelujah 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 · Answer

updated functional docker compose ``` 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 5 ```

rp · Answer

oh awesome