docker-discourse
docker-discourse copied to clipboard
Published
20 hours ago •
tiredofit
tiredofit
[WARN] ** [discourse] Postgres Host 'discourse-db' is not accessible, retrying..
I have executed:
$ docker network create proxy
$ docker network create services
$ docker-compose up -d
I see:
$ docker-compose ps
Name Command State Ports
-------------------------------------------------------------------------------------
discourse-app /init Up 10050/tcp, 2020/tcp, 3000/tcp, 80/tcp
discourse-db /init Up 10050/tcp, 2020/tcp, 5432/tcp
discourse-db-backup /init Up 10050/tcp, 2020/tcp
discourse-example-org-redis /init Up 10050/tcp, 2020/tcp, 6379/tcp
And:
$ docker-compose logs -f discourse-app
Attaching to discourse-app
discourse-app | ,---.
discourse-app | ,--------.,--. ,--. ,---. ,--. ,--------.| |
discourse-app | '--. .--'`--',--.--. ,---. ,-| | ,---. / .-' | | '--. .--'| .'
discourse-app | | | ,--.| .--'| .-. :' .-. | | .-. || `-, | | | | | |
discourse-app | | | | || | \ --.\ `-' | ' '-' '| .-' | |.--.| | `--'
discourse-app | `--' `--'`--' `----' `---' `---' `--' `--''--'`--' .--.
discourse-app | '--'
discourse-app | Image: tiredofit/discourse | Version 3.1.4 Type 'image_changelog' for details
discourse-app | Repository/Issues/Support: https://github.com/tiredofit/docker-discourse/
discourse-app | Sponsor me for development and upkeep: https://www.tiredofit.ca/sponsor
discourse-app |
discourse-app | 2023-04-07.17:33:10 [NOTICE] ** [timezone] Timezone: Setting to 'America/Vancouver' from 'Etc/GMT'
discourse-app | 2023-04-07.10:33:10 [NOTICE] ** [monitoring] Container configured for monitoring with 'zabbix modern'
discourse-app | 2023-04-07.10:33:10 [NOTICE] ** [scheduling] Container configured for scheduled tasks with 'cron'
discourse-app | 2023-04-07.10:33:10 [NOTICE] ** [messaging] Container configured to route mail via SMTP to 'postfix-relay'
discourse-app | 2023-04-07.10:33:11 [NOTICE] ** [nginx] Disabling Nginx Functionality
discourse-app | 2023-04-07.10:33:16 [WARN] ** [discourse] Postgres Host 'discourse-db' is not accessible, retrying.. (5 seconds so far)
...
discourse-app | 2023-04-07.10:42:14 [WARN] ** [discourse] Postgres Host 'discourse-db' is not accessible, retrying.. (540 seconds so far)
discourse-app | 2023-04-07.10:42:19 [WARN] ** [discourse] Postgres Host 'discourse-db' is not accessible, retrying.. (545 seconds so far)
Where is my mistake? How can I fix it?
It doesn't look like you have a functioning Postgresql database which is what it is waiting to verify..
It doesn't look like you have a functioning Postgresql database which is what it is waiting to verify..
Indeed:
discourse-db | ,---.
discourse-db | ,--------.,--. ,--. ,---. ,--. ,--------.| |
discourse-db | '--. .--'`--',--.--. ,---. ,-| | ,---. / .-' | | '--. .--'| .'
discourse-db | | | ,--.| .--'| .-. :' .-. | | .-. || `-, | | | | | |
discourse-db | | | | || | \ --.\ `-' | ' '-' '| .-' | |.--.| | `--'
discourse-db | `--' `--'`--' `----' `---' `---' `--' `--''--'`--' .--.
discourse-db | '--'
discourse-db | Image: tiredofit/postgres:15 | Version 15-3.0.2 Type 'image_changelog' for details
discourse-db | Repository/Issues/Support: https://github.com/tiredofit/docker-postgres/
discourse-db | Sponsor me for development and upkeep: https://www.tiredofit.ca/sponsor
discourse-db |
discourse-db | 2023-04-07.21:23:56 [NOTICE] ** [timezone] Timezone: Setting to 'America/Vancouver' from 'Etc/GMT'
discourse-db | 2023-04-07.14:23:56 [NOTICE] ** [monitoring] Container configured for monitoring with 'zabbix modern'
discourse-db | 2023-04-07.14:23:56 [NOTICE] ** [scheduling] Container configured for scheduled tasks with 'cron'
discourse-db | 2023-04-07.14:23:56 [ERROR] ** [postgres] No 'Superuser Password' Entered! - Set '$SUPERUSER_PASS'
discourse-db | **********************************************************************************************************************
discourse-db | **********************************************************************************************************************
discourse-db | **** ****
discourse-db | **** ERROR - Some initialization scripts haven't completed - All services are now halted ****
discourse-db | **** - The following scripts in '/etc/cont-init.d' did not pass their completion check ****
discourse-db | **** ****
discourse-db | **********************************************************************************************************************
discourse-db | **********************************************************************************************************************
discourse-db |
discourse-db | 10-postgres
discourse-db |
discourse-db |
discourse-db | **********************************************************************************************************************
discourse-db | **********************************************************************************************************************
discourse-db | **** ****
discourse-db | **** This could have happened for a variety of reasons. Please make sure you have followed the README ****
discourse-db | **** relating to this image and have proper configuration such as environment variables and volumes set ****
discourse-db | **** ****
discourse-db | **** If you feel that you have encountered a bug, please submit an issue on the revision control system ****
discourse-db | **** and provide full debug logs by setting the environment variable 'DEBUG_MODE=TRUE' ****
discourse-db | **** ****
discourse-db | **********************************************************************************************************************
discourse-db | **********************************************************************************************************************
discourse-db |
discourse-db | Image: tiredofit/postgres:15
discourse-db | Repository/Issues/Support: https://github.com/tiredofit/docker-postgres/
@tiredofit Fixed by:
❯ git diff
diff --git a/examples/docker-compose.yml b/examples/docker-compose.yml
index 852c9fe..df9cd83 100644
--- a/examples/docker-compose.yml
+++ b/examples/docker-compose.yml
@@ -45,6 +45,7 @@ services:
- POSTGRES_DB=discourse
- POSTGRES_USER=discourse
- POSTGRES_PASSWORD=password
+ - SUPERUSER_PASS=superuser
networks:
- services
If it helps, I solved by adding the - SUPERUSER_PASS=superuser like @stephane-klein
Also by using the official Postgres image and exposing the PG port. Without that, PG is not reachable.
discourse-db:
container_name: discourse-db
image: postgres:15
restart: unless-stopped
volumes:
- ./db:/var/lib/postgresql/data
environment:
- TIMEZONE=Europe/Paris
- CONTAINER_NAME=discourse-db
- POSTGRES_DB=discourse
- POSTGRES_USER=discourse
- POSTGRES_PASSWORD=password
- SUPERUSER_PASS=superuser
networks:
- services
expose:
- 5432
