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

Fri May 5 05:24:36 PDT 2023

Hello,
Following to my previous message, i validated the ability to connect to the
postgresql server (with pg_isready).
I ' m taking the liberty to paste below an update of qgis server log :
We can see *Connection to database failed **fe_sendauth: no password
supplied*
Do you know the meaning of this message and how to fix this erreur ?
Moreover, what is the meaning of the critical error : *Layer(s) not valid
? *

*14:12:37 INFO Server[778180]: ******************** New request
****************

*14:12:37 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
<http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs>*

*14:12:37 INFO Server[778180]: Environment:*

*14:12:37 INFO Server[778180]:
------------------------------------------------*

*14:12:37 INFO Server[778180]: SERVER_NAME: xxxx.xxxx.fr
<http://xxxx.xxxx.fr>*

*14:12:37 INFO Server[778180]: REQUEST_URI:
/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs*

*14:12:37 INFO Server[778180]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi*

*14:12:37 INFO Server[778180]: REMOTE_ADDR: 1xxx.xx.xx.xx*

*14:12:37 INFO Server[778180]: SERVER_PORT: 80*

*14:12:37 INFO Server[778180]: QUERY_STRING:
MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs*

*14:12:37 INFO Server[778180]: REQUEST_METHOD: GET*

*14:12:37 INFO Server[778180]: QGIS_PROJECT_FILE:
/home/qgis/projects/world.qgs*

*14:12:37 INFO Server[778180]: SERVER_PROTOCOL: HTTP/1.1*

*14:12:37 INFO Lizmap[778180]: Request headers provided*

*14:12:37 INFO Lizmap[778180]: No lizmap user groups in request headers*

*14:12:37 INFO Server[778180]:
MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs*

*14:12:37 WARNING PostGIS[778180]: Connection to database failed*

*fe_sendauth: no password supplied*

*14:12:37 CRITICAL Server[778180]: Error, Layer(s)
Ouvrage_a_Realiser_Pt_7249ce6e_1919_4704_8a1c_cce8299e331d not valid in
project /home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs*

*14:12:37 WARNING Server[778180]: <?xml version="1.0" encoding="UTF-8"?>*

*<ServerException>Layer(s) not valid</ServerException>*

*14:12:37 INFO Server[778180]: Request finished in 96 ms*

Le ven. 5 mai 2023 à 10:55, celati Laurent <laurent.celati at gmail.com> a
écrit :

> 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/bd3564d8/attachment-0001.htm>