<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hallo Wolfgang,<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>ich bin die Woche nicht im Büro und mir deshalb nicht sicher, ob es das ausführliche Protokoll vom QGIS-Server oder vom Apache war, in dem die gesetzten Variablen angezeigt werden. Das könnte doch helfen – oder?<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Viele Grüße<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Günter<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>Von:</b> Lizmap-de <lizmap-de-bounces@lists.osgeo.org> <b>Im Auftrag von </b>Wolfgang Meinolf<br><b>Gesendet:</b> Dienstag, 15. Februar 2022 17:25<br><b>An:</b> Etienne Trimaille <etienne.trimaille@gmail.com><br><b>Cc:</b> lizmap-de@lists.osgeo.org<br><b>Betreff:</b> Re: [Lizmap-de] QGIS and Postgis<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'>Hm, on my machine I have </span><span lang=EN-US>/home/gisuserhome and /home/qgis. My Portals are located in separate folders under /home/gisuserhome, e.g. /home/gisuserhome/portal1, /home/gisuserhome/portal2 and so on. Owner of these folders is gisuserhome.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>In /home/qgis I just see 2 folders called qgisserverdb and projects. Owner of these folders is www-data. I installed the entire server about 18 months ago, so it’s difficult to remember. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>So I tried to place the „.pg_service.conf“ in both home dirs, gisuserhome and qgis, but without success. I also ran pg_config –sysconfdir, which lead me to /etc/postgresql-common and placed the „.pg_service.conf“ there without success.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'>How can I check the user, used for QGIS Server?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>Von:</b> Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com">etienne.trimaille@gmail.com</a>> <br><b>Gesendet:</b> Dienstag, 15. Februar 2022 16:33<br><b>An:</b> Wolfgang Meinolf <<a href="mailto:wmeinolf@bbv-deutschland.de">wmeinolf@bbv-deutschland.de</a>><br><b>Cc:</b> <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br><b>Betreff:</b> Re: [Lizmap-de] QGIS and Postgis<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Hi,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>You need to check the user used for QGIS Server.<o:p></o:p></p></div><div><p class=MsoNormal>Does it use /home/gisuserhome ?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Try to set explicitly the path to the service file with PGSERVICEFILE when launching QGIS Server.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>QGIS_SERVER_IGNORE_BAD_LAYERS is very convenient.<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://docs.qgis.org/3.22/en/docs/server_manual/config.html#environment-variables">https://docs.qgis.org/3.22/en/docs/server_manual/config.html#environment-variables</a><o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Le mar. 15 févr. 2022 à 16:25, Wolfgang Meinolf <<a href="mailto:wmeinolf@bbv-deutschland.de">wmeinolf@bbv-deutschland.de</a>> a écrit :<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hallo zusammen,<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>auf meinem Web Server (UBUNTU) läuft Lizmap mit QGIS Server unter Apache und Postgres mit Postgis Erweiterung. Die Postgis credentials habe ich auf meinem Windows PC in pg_service.conf. Darin auf dem PC die URL des Webservers. Die gleiche pg_service.conf ist auf dem Webserver unter /home/gisuserhome, also meinem Home Verzeichnis dort, nur natürlich mit punkt davor, also „.pg_service.conf“. Ausserdem ist die host adresse dort „localhost“.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Ein QGS Projekt auf meinem PC enthält ausschließlich einen Postgis Layer. In Qgis funktioniert das Ganze einwandfrei, die credentials kommen offensichtlich aus der pg_service.conf. Lade ich das QGS und Lizmap cfg file auf meinen Server zeigt Lizmap Service non disponible. Offensichtlich kann der POSTGIS Layer nicht geöffnet werden. Ist ja sonst kein Layer im Projekt.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Was mache ich falsch?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Gruß<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Wolfgang<o:p></o:p></p></div></div><p class=MsoNormal>-- <br>Lizmap-de mailing list<br><a href="mailto:Lizmap-de@lists.osgeo.org" target="_blank">Lizmap-de@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/lizmap-de" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap-de</a><o:p></o:p></p></blockquote></div></div></body></html>