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.cel...@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* >
_______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
