<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-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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 lang="EN-US" style="mso-fareast-language:EN-US">Hi </span>
<span lang="EN-US">Etienne,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Ok, Thanks. Result is:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">www-data 752979 1.2 0.4 2066932 318956 ? Sl 09:04 0:30 /usr/lib/cgi-bin/qgis_mapserv.fcgi<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">I’ve out now a pg-service.conf (w/o leading dot) in :/etc/postgresql-common:<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" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">root@bbvgis:/etc/postgresql-common# ls -al<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">total 40<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">drwxr-xr-x 3 root root 4096 Feb 16 08:29 .<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">drwxr-xr-x 137 root root 12288 Feb 16 06:28 ..<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">-rw-r--r-- 1 root root 1325 Aug 13 2020 createcluster.conf<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">-rw-r--r-- 1 root root 575 Feb 15 16:02 pg_service.conf<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">I’ve also put a .pg-service.conf (with leading dot) in /home/qgis/ and changed owner to www-data:<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" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">root@bbvgis:/home/qgis# ls -al<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">total 20<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">drwxr-xr-x 4 www-data www-data 4096 Feb 16 08:58 .<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">drwxr-xr-x 6 root root 4096 Feb 14 09:28 ..<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">-rw-r--r-- 1 www-data www-data 588 Feb 16 08:58 .pg_service.conf<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US">drwxr-xr-x 2 www-data www-data 4096 Aug 13 2020 projects<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="mso-fareast-language:EN-US">drwxr-xr-x 2 www-data www-data 4096 Nov 11 2020 qgisserverdb<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 lang="EN-US" style="mso-fareast-language:EN-US">I also inserted „</span><span lang="EN-US">QGIS_SERVER_IGNORE_BAD_LAYERS</span><span lang="EN-US" style="mso-fareast-language:EN-US">“ in my apache “site available” conf file, which
also sets PGSERVICEFILE:<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" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US"></span><span style="mso-fareast-language:EN-US">#fehlerhafte Layer ignorieren (Standard 0 - false) !!!<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="mso-fareast-language:EN-US">
</span><span lang="EN-US" style="mso-fareast-language:EN-US">FcgidInitialEnv QGIS_SERVER_IGNORE_BAD_LAYERS 1<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US"> # See
<a href="https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/supported_data.html#pg-service-file">
https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/supported_data.html#pg-service-file</a><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US"> SetEnv PGSERVICEFILE /home/qgis/.pg_service.conf<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US" style="mso-fareast-language:EN-US"> FcgidInitialEnv PGPASSFILE /home/qgis/.pgpass<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>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Restarted both postgres and apache2.
<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">I still get service non disponible.
<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">What did I oversee? Do I have anything to insert in the lizmap part?<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>
<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>
<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 <etienne.trimaille@gmail.com> <br>
<b>Gesendet:</b> Dienstag, 15. Februar 2022 22:06<br>
<b>An:</b> G. Wagner, Wagner-IT <info@wagner-it.de><br>
<b>Cc:</b> Wolfgang Meinolf <wmeinolf@bbv-deutschland.de>; lizmap-de@lists.osgeo.org<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"><span lang="EN-US">With Apache, QGIS Server might run with www-data user. So it won't find service files located in your current /home.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">You can check with the command "ps -aux | grep qgis" so see the which user is running QGIS Server.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">pg_config –sysconfdir will work. But be careful, the file is "pg_service.conf" without any dot</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><a href="https://www.postgresql.org/docs/current/libpq-pgservice.html">https://www.postgresql.org/docs/current/libpq-pgservice.html</a>
</span><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 à 22:00, G. Wagner, Wagner-IT <<a href="mailto:info@wagner-it.de">info@wagner-it.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-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hallo Wolfgang,<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">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></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">Viele Grüße<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">Günter<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"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b>Von:</b> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org" target="_blank">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Wolfgang Meinolf<br>
<b>Gesendet:</b> Dienstag, 15. Februar 2022 17:25<br>
<b>An:</b> Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com" target="_blank">etienne.trimaille@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:lizmap-de@lists.osgeo.org" target="_blank">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Lizmap-de] QGIS and Postgis<o:p></o:p></p>
</div>
</div>
<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"><span lang="EN-US">Hm, on my machine I have /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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">How can I check the user, used for QGIS Server?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b>Von:</b> Etienne Trimaille <<a href="mailto:etienne.trimaille@gmail.com" target="_blank">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" target="_blank">wmeinolf@bbv-deutschland.de</a>><br>
<b>Cc:</b> <a href="mailto:lizmap-de@lists.osgeo.org" target="_blank">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">You need to check the user used for QGIS Server.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Does it use /home/gisuserhome ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">QGIS_SERVER_IGNORE_BAD_LAYERS is very convenient.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://docs.qgis.org/3.22/en/docs/server_manual/config.html#environment-variables" target="_blank">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Le mar. 15 févr. 2022 à 16:25, Wolfgang Meinolf <<a href="mailto:wmeinolf@bbv-deutschland.de" target="_blank">wmeinolf@bbv-deutschland.de</a>> a écrit :<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid windowtext 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">--
<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>
</div>
</blockquote>
</div>
</div>
</body>
</html>