Lizmap docker compose and PostGIS

[pjduplooy2022]

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]

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

[pjduplooy2022]

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.

[Gustry]

Is-this issue still relevant ?