<html data-lt-installed="true">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body style="padding-bottom: 1px;">
Hi Laurent,<br>
<br>
In QGIS Desktop, when you defined the PostGIS connection, you have
to use basic authentication to provide the login/password in the
layer datasource.<br>
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.<br>
If these parameters are not in the layer's datasource, QGIS Server
will not be able to create the connection to the database.<br>
<br>
Regards,<br>
René-Luc<br>
<br>
<div class="moz-cite-prefix">Le 09/05/2023 à 12:28, celati Laurent a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAHByMH3S5EpEM0fdM3xEbU4U8u0sfvmcrF7+jJBwD3JcvLnbFQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true" class="moz-txt-link-freetext">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" moz-do-not-send="true"
class="moz-txt-link-freetext">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"
moz-do-not-send="true">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"
moz-do-not-send="true" class="moz-txt-link-freetext">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" moz-do-not-send="true">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"
moz-do-not-send="true">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>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Lizmap mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lizmap@lists.osgeo.org">Lizmap@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/lizmap">https://lists.osgeo.org/mailman/listinfo/lizmap</a>
</pre>
</blockquote>
<br>
<div id="grammalecte_menu_main_button_shadow_host" style="width:
0px; height: 0px;"></div>
</body>
<lt-container></lt-container>
</html>