<div dir="ltr">Thanks for your help. It works now. </div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 9 mai 2023 à 12:28, celati Laurent <<a href="mailto:laurent.celati@gmail.com">laurent.celati@gmail.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div>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 ? <br>Please read below the qgis server and lizmap messages : <br><br><b>qgis server : </b><br><i>Code:<br>12:10:06 INFO Server[824190]: ******************** New request ***************<br>12:10:06 INFO Server[824190]: Request URL: <a href="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" target="_blank">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</a><br>12:10:06 INFO Server[824190]: Environment:<br>12:10:06 INFO Server[824190]: ------------------------------------------------<br>12:10:06 INFO Server[824190]: SERVER_NAME: <a href="http://XXXX-XXXXX.XXXXX.fr" target="_blank">XXXX-XXXXX.XXXXX.fr</a><br>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<br>12:10:06 INFO Server[824190]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi<br>12:10:06 INFO Server[824190]: REMOTE_ADDR: XXXXXX.XXXXX.XXXX.XXXXX<br>12:10:06 INFO Server[824190]: SERVER_PORT: 80<br>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<br>12:10:06 INFO Server[824190]: REQUEST_METHOD: GET<br>12:10:06 INFO Server[824190]: QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs<br>12:10:06 INFO Server[824190]: SERVER_PROTOCOL: HTTP/1.1<br>12:10:06 INFO Lizmap[824190]: Request headers provided<br>12:10:06 INFO Lizmap[824190]: No lizmap user groups in request headers<br>12:10:06 INFO Lizmap[824190]: Lizmap user groups in parameters : admins<br>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<br>12:10:06 INFO Lizmap[824190]: No acl defined in Lizmap config<br>12:10:06 INFO Server[824190]: LIZMAP_OVERRIDE_FILTER:1<br>12:10:06 INFO Server[824190]: LIZMAP_USER:admin<br>12:10:06 INFO Server[824190]: LIZMAP_USER_GROUPS:admins<br>12:10:06 INFO Server[824190]: MAP:/home/data/ftp/template/qgis/lizmap_test/zios.qgs<br>12:10:06 INFO Server[824190]: REQUEST:getcapabilities<br>12:10:06 INFO Server[824190]: SERVICE:WMS<br>12:10:06 INFO Server[824190]: VERSION:1.3.0<br>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<br>12:10:06 WARNING Server[824190]: <?xml version="1.0" encoding="UTF-8"?><br><ServerException>Layer(s) not valid</ServerException><br><br>12:10:06 INFO Server[824190]: Request finished in 70 ms</i></div><div><i><br></i></div><div><i><b>Lizmap message : </b></i><br>An error occurred while loading the map. Required resources may be temporarily unavailable. Please try later.<br>Return to home page.<i><br><br><b>Lizmap Logs : </b></i></div><div><pre style="margin-top:0px;margin-bottom:0px;padding:0px;list-style:none;font-size:1.2em;color:rgb(51,51,51)">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</pre></div><div><br></div><div><br></div><div>Thanks a lot for your help</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le ven. 5 mai 2023 à 14:24, celati Laurent <<a href="mailto:laurent.celati@gmail.com" target="_blank">laurent.celati@gmail.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div>Following to my previous message, i validated the ability to connect to the postgresql server (with pg_isready). <br>I ' m taking the liberty to paste below an update of qgis server log : <br>We can see <i style="font-family:"Lucida Sans",sans-serif;font-size:9pt;text-align:justify">Connection to database failed </i><i style="font-family:"Lucida Sans",sans-serif;font-size:9pt;text-align:justify">fe_sendauth: no password supplied</i><i style="font-family:"Lucida Sans",sans-serif;font-size:9pt;text-align:justify"><br></i>Do you know the meaning of this message and how to fix this erreur ? <br>Moreover, what is the meaning of the critical error : <i style="font-family:"Lucida Sans",sans-serif;font-size:12px;text-align:justify">Layer(s) not valid ? </i></div><div><br><p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: ******************** New
request ***************</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: Request URL:
<a href="http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs" target="_blank">http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs</a></i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: Environment:</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]:
------------------------------------------------</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: SERVER_NAME:
<a href="http://xxxx.xxxx.fr" target="_blank">xxxx.xxxx.fr</a></i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: REQUEST_URI: /cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: SCRIPT_NAME:
/cgi-bin/qgis_mapserv.fcgi</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: REMOTE_ADDR: 1xxx.xx.xx.xx</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: SERVER_PORT: 80</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: QUERY_STRING:
MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: REQUEST_METHOD: GET</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: QGIS_PROJECT_FILE:
/home/qgis/projects/world.qgs</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: SERVER_PROTOCOL: HTTP/1.1</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Lizmap[778180]: Request headers provided</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Lizmap[778180]: No lizmap user groups in
request headers</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]:
MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 WARNING PostGIS[778180]: Connection to database
failed</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>fe_sendauth: no password supplied</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i> </i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>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</i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 WARNING Server[778180]: <?xml
version="1.0" encoding="UTF-8"?></i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i><ServerException>Layer(s) not
valid</ServerException></i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i> </i></p>
<p style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i>14:12:37 INFO Server[778180]: Request finished in 96 ms</i></p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le ven. 5 mai 2023 à 10:55, celati Laurent <<a href="mailto:laurent.celati@gmail.com" target="_blank">laurent.celati@gmail.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Good morning dear all,</div><div><br></div><div>i work with debian and apache. Qgis server is working. For example, I can see the world.qgs template project with qgis server.<br>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.<br>Below I share the lizmap and qgis server logs. I have probably several errors.<br>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?<br>I share my lizmap logs. Although I think they are less relevant at this point than the qgis server logs.<br></div><div><br></div><div>In advance, thanks so much for your really usefull help.</div><div><br></div><div><b>Log lizmap :</b> </div><div><br></div><i>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</i><div><br></div><div><b>Log qgis server :</b> <br></div><div><br></div><div><i>10:29:43 INFO Server[778180]: ******************** New request ***************<br>10:29:43 INFO Server[778180]: Request URL: <a href="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" target="_blank">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</a><br>10:29:43 INFO Server[778180]: Environment:<br>10:29:43 INFO Server[778180]: ------------------------------------------------<br>10:29:43 INFO Server[778180]: SERVER_NAME: <a href="http://XXX-XXXX.andra.fr" target="_blank">XXX-XXXX.andra.fr</a><br>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<br>10:29:43 INFO Server[778180]: SCRIPT_NAME: /cgi-bin/qgis_mapserv.fcgi<br>10:29:43 INFO Server[778180]: REMOTE_ADDR: 172.21.20.97<br>10:29:43 INFO Server[778180]: SERVER_PORT: 80<br>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<br>10:29:43 INFO Server[778180]: REQUEST_METHOD: GET<br>10:29:43 INFO Server[778180]: QGIS_PROJECT_FILE: /home/qgis/projects/world.qgs<br>10:29:43 INFO Server[778180]: SERVER_PROTOCOL: HTTP/1.1<br>10:29:43 INFO Lizmap[778180]: Request headers provided<br>10:29:43 INFO Lizmap[778180]: No lizmap user groups in request headers<br>10:29:43 INFO Server[778180]: BBOX:-432786,4372992,3358959,7513746<br>10:29:43 INFO Server[778180]: FORMAT:image/jpeg<br>10:29:43 INFO Server[778180]: HEIGHT:551<br>10:29:43 INFO Server[778180]: LAYERS:countries<br>10:29:43 INFO Server[778180]: MAP:/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs<br>10:29:43 INFO Server[778180]: REQUEST:GetMap<br>10:29:43 INFO Server[778180]: SERVICE:WMS<br>10:29:43 INFO Server[778180]: SRS:EPSG:3857<br>10:29:43 INFO Server[778180]: VERSION:1.3.0<br>10:29:43 INFO Server[778180]: WIDTH:665<br>10:30:13 WARNING PostGIS[778180]: Connection to database failed<br>timeout expired<br><br>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<br>10:30:13 WARNING Server[778180]: <?xml version="1.0" encoding="UTF-8"?><br><ServerException>Layer(s) not valid</ServerException><br><br>10:30:14 INFO Server[778180]: Request finished in 30136 ms</i><br></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>