[Lizmap] Lizmap/qgis server : Setting up with PostGIS database

Fri May 5 01:55:15 PDT 2023

Good morning dear all,

i work with debian and apache. Qgis server is working. For example, I can
see the world.qgs template project with qgis server.
A getcapabilities request also works. On the other hand, I can't  up to now
see my project with a postgis table. Whether with qgis server and of course
with lizmap.
Below I share the lizmap and  qgis server logs.  I have probably several
errors.
Regarding the postgis aspect, I confess that I don't really understand what
to do as settings in the qgis project. I found a forum talking about saving
configuration in plain text. What is it exactly? How should I save my
id/password? I guess with qgis desktop In the window "edit a postgis
connection" ?. I imagine that everything is set in the Authentication
section? There are 2 tabs. A configuration and a "basic". Should I put
basic authentication?
I share my lizmap logs. Although I think they are less relevant at this
point than the qgis server logs.

In advance, thanks so much for your really usefull help.

*Log lizmap :*

*2023-05-05 09:34:18 [8] Undefined index: repository
/var/www/lizmap/lizmap-web-client-3.6.3/temp/lizmap/www/compiled/templates/modules/admin/server_information_html_t_15.php
171*

*Log qgis server :*

*10:29:43 INFO Server[778180]: ******************** New request
***************10:29:43 INFO Server[778180]: Request URL:
http://XXX.XXX.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg
<http://XXX.XXX.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg>10:29:43
INFO Server[778180]: Environment:10:29:43 INFO Server[778180]:
------------------------------------------------10:29:43 INFO
Server[778180]: SERVER_NAME: XXX-XXXX.andra.fr
<http://XXX-XXXX.andra.fr>10:29:43 INFO Server[778180]: REQUEST_URI:
/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg10:29:43
INFO Server[778180]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi10:29:43 INFO
Server[778180]: REMOTE_ADDR: 172.21.20.9710:29:43 INFO Server[778180]:
SERVER_PORT: 8010:29:43 INFO Server[778180]: QUERY_STRING:
MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=-432786,4372992,3358959,7513746&SRS=EPSG:3857&WIDTH=665&HEIGHT=551&LAYERS=countries&FORMAT=image/jpeg10:29:43
INFO Server[778180]: REQUEST_METHOD: GET10:29:43 INFO Server[778180]:
QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs10:29:43 INFO
Server[778180]: SERVER_PROTOCOL: HTTP/1.110:29:43 INFO Lizmap[778180]:
Request headers provided10:29:43 INFO Lizmap[778180]: No lizmap user groups
in request headers10:29:43 INFO Server[778180]:
BBOX:-432786,4372992,3358959,751374610:29:43 INFO Server[778180]:
FORMAT:image/jpeg10:29:43 INFO Server[778180]: HEIGHT:55110:29:43 INFO
Server[778180]: LAYERS:countries10:29:43 INFO Server[778180]:
MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs10:29:43 INFO
Server[778180]: REQUEST:GetMap10:29:43 INFO Server[778180]:
SERVICE:WMS10:29:43 INFO Server[778180]: SRS:EPSG:385710:29:43 INFO
Server[778180]: VERSION:1.3.010:29:43 INFO Server[778180]:
WIDTH:66510:30:13 WARNING PostGIS[778180]: Connection to database
failedtimeout expired10:30:13 CRITICAL Server[778180]: Error, Layer(s)
XXXXXX_Ouvrage_a_Realiser_Pt_8db55b4d_dd42_4d46_b5d1_1cffd2768ae1 not valid
in project /home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs10:30:13
WARNING Server[778180]: <?xml version="1.0"
encoding="UTF-8"?><ServerException>Layer(s) not
valid</ServerException>10:30:14 INFO Server[778180]: Request finished in
30136 ms*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20230505/a81a8047/attachment.htm>