search

3liz / lizmap-docker-compose

Run Lizmap stack with docker-compose
30 stars 42 forks source link

PostgreSQL not connecting on default settings #45

Closed Toylerrr closed 1 year ago

Toylerrr commented 1 year ago

I am getting this error:

lizmap-docker-compose-lizmap-1   | Updating configuration
lizmap-docker-compose-lizmap-1   | Checking for lizmap configuration files in /srv/etc/lizmap                                                              config.d
lizmap-docker-compose-lizmap-1   | * Loading lizmap configuration: /srv/etc/lizmapconfig.d/li                                                              zmap-url.ini.php
lizmap-docker-compose-lizmap-1   | Checking for lizmap configuration files in /srv/etc/localc                                                              onfig.d
lizmap-docker-compose-lizmap-1   | * Loading lizmap configuration: /srv/etc/localconfig.d/tes                                                              t.ini.php
lizmap-docker-compose-lizmap-1   | Checking for lizmap configuration files in /srv/etc/profil                                                              es.d
lizmap-docker-compose-lizmap-1   | * Loading lizmap configuration: /srv/etc/profiles.d/lizmap                                                              _local.ini.php
lizmap-docker-compose-lizmap-1   | * Loading lizmap configuration: /srv/etc/profiles.d/test.i                                                              ni.php
lizmap-docker-compose-lizmap-1   | trying to connect to the Postgresql database lizmap at db.                                                              lizmap with the profile default...
lizmap-docker-compose-lizmap-1   |   Cannot connect yet, wait a bit before retrying...
lizmap-docker-compose-lizmap-1   | PHP Warning:  pg_connect(): Unable to connect to PostgreSQ                                                              L server: timeout expired in /bin/update-config.php on line 87
lizmap-docker-compose-lizmap-1   |   Retry...
lizmap-docker-compose-lizmap-1   |   Cannot connect yet, wait a bit before retrying...

I haven't changed any env variables I have only run the linux commands under the README md.

dmarteau commented 1 year ago

Does not looks like an error: it's just telling you that it's waiting for the database to be ready....

Toylerrr commented 1 year ago

It goes on for quite a while, I left the rest out for brevity. When I tried it on WSL it worked almost instantly but on a ubuntu VM it cant connect to postgresql.

Logs ``` lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retry ing... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retry ing... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retry ing... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-con fig.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Error: cannot connect to the Postgresql database. lizmap-docker-compose-lizmap-1 | Lizmap cannot starts. lizmap-docker-compose-lizmap-1 exited with code 1 lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Error: cannot connect to the Postgresql database. lizmap-docker-compose-lizmap-1 | Lizmap cannot starts. lizmap-docker-compose-lizmap-1 exited with code 1 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Error: cannot connect to the Postgresql database. lizmap-docker-compose-lizmap-1 | Lizmap cannot starts. lizmap-docker-compose-lizmap-1 exited with code 1 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | Retry... lizmap-docker-compose-lizmap-1 | Cannot connect yet, wait a bit before retrying... lizmap-docker-compose-lizmap-1 | PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: timeout expired in /bin/update-config.php on line 87 lizmap-docker-compose-lizmap-1 | Retry... ```
dmarteau commented 1 year ago

When I tried it on WSL it worked almost instantly but on a ubuntu VM it cant connect to postgresql.

This seems to be a Docker related problem running on your VM - Docker is known to run well on WSL (which run itlself on a VM) - but badly on Mac.

Try to log the posgresql container to get its status. You may try also a minimal compose stack to check network behavior between containers (Note that Docker require iptables and networking may not work if it is not installed on your VM).

Gustry commented 1 year ago

Try also docker ps -a to see you if you don't have another PG container.

dmarteau commented 1 year ago

Try also docker ps -a to see you if you don't have another PG container.

That should be a problem only if the lizmap postgres container try to open the same public port.

Toylerrr commented 1 year ago

Switched to Debian and it works now. must be a problem with Docker/Ubuntu networks