[Lizmap] Lizmap/qgis server : Setting up with PostGIS database
celati Laurent
laurent.celati at gmail.com
Wed May 10 06:53:43 PDT 2023
Thanks for your help. It works now.
Le mar. 9 mai 2023 à 12:28, celati Laurent <laurent.celati at gmail.com> a
écrit :
> 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/lizmap/attachments/20230510/e80786ba/attachment-0001.htm>
More information about the Lizmap
mailing list