[Lizmap] Lizmap/qgis server : Setting up with PostGIS database
René-Luc Dhont
rldhont at gmail.com
Tue May 9 04:39:14 PDT 2023
Hi Laurent,
In QGIS Desktop, when you defined the PostGIS connection, you have to
use basic authentication to provide the login/password in the layer
datasource.
You can check your QGIS Project file (.qgs). The <datasource> which
contain parameters to connect to the database has to have login and
password parameter.
If these parameters are not in the layer's datasource, QGIS Server will
not be able to create the connection to the database.
Regards,
René-Luc
Le 09/05/2023 à 12:28, celati Laurent 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=1
> 12:10:06 INFO Server[824190]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi
> 12:10:06 INFO Server[824190]: REMOTE_ADDR: XXXXXX.XXXXX.XXXX.XXXXX
> 12:10:06 INFO Server[824190]: SERVER_PORT: 80
> 12: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=1
> 12:10:06 INFO Server[824190]: REQUEST_METHOD: GET
> 12:10:06 INFO Server[824190]: QGIS_PROJECT_FILE:
> /home/qgis/projects/world.qgs
> 12:10:06 INFO Server[824190]: SERVER_PROTOCOL: HTTP/1.1
> 12:10:06 INFO Lizmap[824190]: Request headers provided
> 12:10:06 INFO Lizmap[824190]: No lizmap user groups in request headers
> 12:10:06 INFO Lizmap[824190]: Lizmap user groups in parameters : admins
> 12:10:06 INFO Lizmap[824190]: Fetching
> /home/data/ftp/template/qgis/lizmap_test/zios.qgs.cfg cfg file with
> last modified timestamp : 1683626320.5751119
> 12:10:06 INFO Lizmap[824190]: No acl defined in Lizmap config
> 12:10:06 INFO Server[824190]: LIZMAP_OVERRIDE_FILTER:1
> 12:10:06 INFO Server[824190]: LIZMAP_USER:admin
> 12:10:06 INFO Server[824190]: LIZMAP_USER_GROUPS:admins
> 12:10:06 INFO Server[824190]:
> MAP:/home/data/ftp/template/qgis/lizmap_test/zios.qgs
> 12:10:06 INFO Server[824190]: REQUEST:getcapabilities
> 12:10:06 INFO Server[824190]: SERVICE:WMS
> 12:10:06 INFO Server[824190]: VERSION:1.3.0
> 12: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.qgs
> 12: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/
>
> /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/jpeg
> 10:29:43 INFO Server[778180]: SCRIPT_NAME:
> /cgi-bin/qgis_mapserv.fcgi
> 10:29:43 INFO Server[778180]: REMOTE_ADDR: 172.21.20.97
> 10:29:43 INFO Server[778180]: SERVER_PORT: 80
> 10: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/jpeg
> 10:29:43 INFO Server[778180]: REQUEST_METHOD: GET
> 10:29:43 INFO Server[778180]: QGIS_PROJECT_FILE:
> /home/qgis/projects/world.qgs
> 10:29:43 INFO Server[778180]: SERVER_PROTOCOL: HTTP/1.1
> 10:29:43 INFO Lizmap[778180]: Request headers provided
> 10:29:43 INFO Lizmap[778180]: No lizmap user groups in request
> headers
> 10:29:43 INFO Server[778180]: BBOX:-432786,4372992,3358959,7513746
> 10:29:43 INFO Server[778180]: FORMAT:image/jpeg
> 10:29:43 INFO Server[778180]: HEIGHT:551
> 10:29:43 INFO Server[778180]: LAYERS:countries
> 10:29:43 INFO Server[778180]:
> MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs
> 10:29:43 INFO Server[778180]: REQUEST:GetMap
> 10:29:43 INFO Server[778180]: SERVICE:WMS
> 10:29:43 INFO Server[778180]: SRS:EPSG:3857
> 10:29:43 INFO Server[778180]: VERSION:1.3.0
> 10:29:43 INFO Server[778180]: WIDTH:665
> 10:30:13 WARNING PostGIS[778180]: Connection to database failed
> timeout expired
>
> 10: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.qgs
> 10: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/
>
>
> _______________________________________________
> Lizmap mailing list
> Lizmap at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/lizmap
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20230509/4ca9488b/attachment-0001.htm>
More information about the Lizmap
mailing list