<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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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">http://xxx.xxx.fr/cgi-bin/qgis_mapserv.fcgi?MAP=/home/data/ftp/template/qgis/lizmap_test/lizmap_test.qgs</a></i></p>
<p class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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">xxxx.xxxx.fr</a></i></p>
<p class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i> </i></p>
<p class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" 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 class="gmail-MsoBodyText" style="margin:8pt 0cm;text-align:justify;line-height:12pt;font-size:9pt;font-family:"Lucida Sans",sans-serif"><i> </i></p>
<p class="gmail-MsoBodyText" 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">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>