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

Tue May 9 03:28:49 PDT 2023

Hello,
Following to my previous message, i share an update of my qgis server and
lizmap messages. For those tests, in addition to the .qgs file, i put on
the server the .qgs.cfg. Is it mandatory to do this ?
Please read below the qgis server and lizmap messages :

*qgis server : *

*Code:12:10:06 INFO Server[824190]: ******************** New request
***************12:10:06 INFO Server[824190]: Request URL:
http://XXX-XXXX.XXXX.fr/cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap_test%2Fzios.qgs&request=getcapabilities&service=WMS&version=1.3.0&Lizmap_User=admin&Lizmap_User_Groups=admins&Lizmap_Override_Filter=1
<http://XXX-XXXX.XXXX.fr/cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap_test%2Fzios.qgs&request=getcapabilities&service=WMS&version=1.3.0&Lizmap_User=admin&Lizmap_User_Groups=admins&Lizmap_Override_Filter=1>12:10:06
INFO Server[824190]: Environment:12:10:06 INFO Server[824190]:
------------------------------------------------12:10:06 INFO
Server[824190]: SERVER_NAME: XXXX-XXXXX.XXXXX.fr
<http://XXXX-XXXXX.XXXXX.fr>12:10:06 INFO Server[824190]: REQUEST_URI:
/cgi-bin/qgis_mapserv.fcgi?map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap%5Ftest%2Fzios%2Eqgs&request=getcapabilities&service=WMS&version=1%2E3%2E0&Lizmap%5FUser=admin&Lizmap%5FUser%5FGroups=admins&Lizmap%5FOverride%5FFilter=112:10:06
INFO Server[824190]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi12:10:06 INFO
Server[824190]: REMOTE_ADDR: XXXXXX.XXXXX.XXXX.XXXXX12:10:06 INFO
Server[824190]: SERVER_PORT: 8012:10:06 INFO Server[824190]: QUERY_STRING:
map=%2Fhome%2Fdata%2Fftp%2Ftemplate%2Fqgis%2Flizmap%5Ftest%2Fzios%2Eqgs&request=getcapabilities&service=WMS&version=1%2E3%2E0&Lizmap%5FUser=admin&Lizmap%5FUser%5FGroups=admins&Lizmap%5FOverride%5FFilter=112:10:06
INFO Server[824190]: REQUEST_METHOD: GET12:10:06 INFO Server[824190]:
QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs12:10:06 INFO
Server[824190]: SERVER_PROTOCOL: HTTP/1.112:10:06 INFO Lizmap[824190]:
Request headers provided12:10:06 INFO Lizmap[824190]: No lizmap user groups
in request headers12:10:06 INFO Lizmap[824190]: Lizmap user groups in
parameters : admins12:10:06 INFO Lizmap[824190]: Fetching
/home/data/ftp/template/qgis/lizmap_test/zios.qgs.cfg cfg file with last
modified timestamp : 1683626320.575111912:10:06 INFO Lizmap[824190]: No acl
defined in Lizmap config12:10:06 INFO Server[824190]:
LIZMAP_OVERRIDE_FILTER:112:10:06 INFO Server[824190]:
LIZMAP_USER:admin12:10:06 INFO Server[824190]:
LIZMAP_USER_GROUPS:admins12:10:06 INFO Server[824190]:
MAP:/home/data/ftp/template/qgis/lizmap_test/zios.qgs12:10:06 INFO
Server[824190]: REQUEST:getcapabilities12:10:06 INFO Server[824190]:
SERVICE:WMS12:10:06 INFO Server[824190]: VERSION:1.3.012:10:06 CRITICAL
Server[824190]: Error, Layer(s)
Cigeo_Zios_Po_20170503_ee7aedcd_2ab0_4b3f_bb42_81725199ad65 not valid in
project /home/data/ftp/template/qgis/lizmap_test/zios.qgs12:10:06 WARNING
Server[824190]: <?xml version="1.0"
encoding="UTF-8"?><ServerException>Layer(s) not
valid</ServerException>12:10:06 INFO Server[824190]: Request finished in 70
ms*

*Lizmap message  : *
An error occurred while loading the map. Required resources may be
temporarily unavailable. Please try later.
Return to home page.

*Lizmap Logs : *

2023-05-09 12:04: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

2023-05-09 12:04: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

2023-05-09 12:05:04    [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

2023-05-09 12:05:04    [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

2023-05-09 12:05:24    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:05:25    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:05:28    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:05:28    172.21.20.97    error    An error has been
raised when loading WMS GetCapabilities: HTTP Code 400
2023-05-09 12:06:02    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:06:03    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:06:03    172.21.20.97    error    An error has been
raised when loading WMS GetCapabilities: HTTP Code 400
2023-05-09 12:06:06    172.21.20.97    error    GetCapabilities result code: 500
2023-05-09 12:07:41    [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

2023-05-09 12:07:41    [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

Thanks a lot for your help

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

> 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/qgis-user/attachments/20230509/88f8a3fe/attachment.htm>