search

ckan / ckan-docker

Scripts and images to run CKAN using Docker Compose
93 stars 176 forks source link

Docker Compose - Error while restarting DB container #145

Open IotaLion opened 4 months ago

IotaLion commented 4 months ago

I have currently the issue that ckan-docker isn't restarting due to a database auth error: psycopg2.OperationalError: connection to server at "db" (172.22.0.3), port 5432 failed: FATAL: password authentication failed for user "datastore_ro"

For more context: error_datastore.txt

Are there any solutions?

kowh-ai commented 4 months ago

It looks like somewhere along the line someone has updated the DATASTORE_READONLY_PASSWORD environment variable (or something similar) after setting up that password when the Datastore database was created...Could it be something like that?

IotaLion commented 4 months ago

Not sure, I did not change the datastore password in the .env or anywhere else. A new, local, installation wasn't successful either.

kowh-ai commented 4 months ago

Weird - you could running thse commands before a new (local) install

https://github.com/ckan/ckan-docker/wiki/Docker-cleanup

IotaLion commented 3 months ago

Hi, sorry for the super late reply.

So, the local installation runs without the password authentication error, but I don't get a connection to the CKAN_SITE_URL (IP address of the VM + port) either.

It seems like the ckan docker container is never starting completely (still having a health: running when using docker ps after 10 minutes)

-> update after 20 minutes with the workaround of https://github.com/ckan/ckan-docker/issues/149#issuecomment-2110052794: ckan container is starting but still no connection to the URL