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.cel...@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.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