search

3liz / lizmap-docker-compose

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

Lizmap docker compose and PostGIS #64

Open pjduplooy2022 opened 6 months ago

pjduplooy2022 commented 6 months ago

Hi guys

This is not really an issue, but I am using lizmap docker compose with success on a linux box, but am a bit confused on which database (port number etc) do I use to be able to edit layers in lizmap web client. I use the lizmap plugin in QGIS

I have tried the db that is part of the lizmap docker compose stack, as well as my own db.

I see the layer label in my project, but no data.

Any help would be appreciated.

I use the naturalgis lizmap stack on Windows without any problems, as my DB is used by lizmap.

Regards

Pieter

dmarteau commented 6 months ago

Use postgres services in your projects so that you dont have to rely statically on database location and port.

pjduplooy2022 commented 6 months ago

Hi

My .env file says this:

LIZMAP_PROJECTS=/home/pieter/lizmap-docker-compose/lizmap/instances LIZMAP_DIR=/home/pieter/lizmap-docker-compose/lizmap LIZMAP_UID=1000 LIZMAP_GID=1000 LIZMAP_VERSION_TAG=3.6 QGIS_VERSION_TAG=3.28 POSTGIS_VERSION=13-3 POSTGRES_PASSWORD=postgres POSTGRES_LIZMAP_DB=lizmap POSTGRES_LIZMAP_USER=lizmap POSTGRES_LIZMAP_PASSWORD=lizmap1234! QGIS_MAP_WORKERS=1 WPS_NUM_WORKERS=1 LIZMAP_PORT=127.0.0.1:8090 OWS_PORT=127.0.0.1:8091 WPS_PORT=127.0.0.1:8092 POSTGIS_PORT=127.0.0.1:5432 POSTGIS_ALIAS=db.lizmap

I have used the .pg_service example from https://github.com/3liz/lizmap-web-client/tree/master/tests, and mine reads as follows:

[lizmapdb] host=localhost port=5432 user=lizmap password=lizmap1234!

I can add a layer in PostGIS, (public schema) but it still shows empty.

I can toggle it in the lizmap plugin, set for editing etc, but always empty.