Connection to Postqre times out during install

[andreasziegl]

Hi all,

paperless-ng really looks pretty amazing and I tried to set it up, but unfortunately, I failed.
I hope someone of you can help me. I try to install paperless-ng via the installation script. Unfortunately, it fails while trying to setup the connection to Postqre.
I freshly downloaded the script a few minutes ago.

LogOutput from script:

Pulling broker    ... done
Pulling db        ... done
Pulling webserver ... done
Starting paperless_broker_1 ... done
Starting paperless_db_1     ... done
Paperless-ng docker container starting...
Mapping UID and GID for paperless:paperless to 1026:100
creating directory ../data/index
creating directory ../media/documents
creating directory ../media/documents/originals
creating directory ../media/documents/thumbnails
creating directory /tmp/paperless
Waiting for PostgreSQL to start...

/sbin/docker-entrypoint.sh: connect: Connection timed out
/sbin/docker-entrypoint.sh: line 33: /dev/tcp/db/5432: Connection timed out
Attempt 1 failed! Trying again in 5 seconds...

/sbin/docker-entrypoint.sh: connect: Connection timed out
/sbin/docker-entrypoint.sh: line 33: /dev/tcp/db/5432: Connection timed out
Attempt 2 failed! Trying again in 5 seconds...
/sbin/docker-entrypoint.sh: connect: Connection timed out
/sbin/docker-entrypoint.sh: line 33: /dev/tcp/db/5432: Connection timed out
Attempt 3 failed! Trying again in 5 seconds...
/sbin/docker-entrypoint.sh: connect: Connection timed out
/sbin/docker-entrypoint.sh: line 33: /dev/tcp/db/5432: Connection timed out
Attempt 4 failed! Trying again in 5 seconds...

Logoutput from the DB container:

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Success. You can now start the database server using:
    pg_ctl -D /var/lib/postgresql/data -l logfile start
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
waiting for server to start....2021-02-23 21:27:40.841 UTC [48] LOG:  starting PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-02-23 21:27:40.843 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-02-23 21:27:40.851 UTC [49] LOG:  database system was shut down at 2021-02-23 21:27:38 UTC
2021-02-23 21:27:40.860 UTC [48] LOG:  database system is ready to accept connections
 done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2021-02-23 21:27:42.008 UTC [48] LOG:  received fast shutdown request
waiting for server to shut down....2021-02-23 21:27:42.010 UTC [48] LOG:  aborting any active transactions
2021-02-23 21:27:42.012 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
2021-02-23 21:27:42.016 UTC [50] LOG:  shutting down
2021-02-23 21:27:42.041 UTC [48] LOG:  database system is shut down
 done
server stopped
PostgreSQL init process complete; ready for start up.
2021-02-23 21:27:42.147 UTC [1] LOG:  starting PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-02-23 21:27:42.147 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-02-23 21:27:42.147 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2021-02-23 21:27:42.151 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-02-23 21:27:42.157 UTC [76] LOG:  database system was shut down at 2021-02-23 21:27:42 UTC
2021-02-23 21:27:42.164 UTC [1] LOG:  database system is ready to accept connections

Regards
Andreas

[jonaswinkler]

Hello!

Could you please post your docker-compose.env / .yml files? Make sure not to post SECRET_KEY.

[andreasziegl]

Hi,
thank you for the fast answer.

Yes sure I have attached them:

docker-compose.env.txt
docker-compose.yml.txt

[malso]

Were you able to resolve your problem? I'm having more or less the same problem.

[andreasziegl]

Hi, no not really.
My solution was to use a raspi instead of my Synology NAS

[andreasziegl]

Okay, I had some spare time and did look into that another time. I was able to solve the issue... It was gloriously stupid:
I did set up paperless on a synology NAS and have very restrictive firewall rules. Those rules did block the connection...

[andreasziegl]

Check firewall rules, to make sure that the Docker containers can actually talk with each other :P