<div dir="ltr"><div>Hi Carlo,</div><div><br></div><div>I suggest you to have a look there : <a href="https://github.com/3liz/lizmap-web-client/issues/1638#issuecomment-627872662">https://github.com/3liz/lizmap-web-client/issues/1638#issuecomment-627872662</a></div><div>Explaining the master password and where to set credentials.</div><div><br></div><div>I started to add this in the documentation on new page dedicated to PostgreSQL.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 6 oct. 2021 à 09:00, Nicolas Boisteault <<a href="mailto:nboisteault@3liz.com">nboisteault@3liz.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>
<p>Hi,</p>
<p>You can also use postgresql service file :
<a href="https://www.postgresql.org/docs/14/libpq-pgservice.html" target="_blank">https://www.postgresql.org/docs/14/libpq-pgservice.html</a></p>
<p>Regards.<br>
</p>
<div>Le 05/10/2021 à 21:20,
<a href="mailto:michal.wloga@envirosolutions.pl" target="_blank">michal.wloga@envirosolutions.pl</a> a écrit :<br>
</div>
<blockquote type="cite">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)" lang="EN-US">Hi Carlo,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)" lang="EN-US">I prefer to save only user in qgs file and
password in server’s .pgpass file. It works for both qgis
server and lizmap-direct postgres connections<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)" lang="EN-US"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Pozdrawiam,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(51,187,90)">EnviroSolutions
Sp. z o. o.<br>
</span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Michał
Włoga<br>
tel: +48 607 059 157<br>
<a href="mailto:coo@envirosolutions.pl" target="_blank"><span style="color:rgb(5,99,193)">coo@envirosolutions.pl</span></a><br>
<a href="http://www.envirosolutions.pl/szkolenia" target="_blank"><span style="color:rgb(5,99,193)">www.envirosolutions.pl</span></a></span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(0,176,240)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(46,116,181)"><a href="https://www.envirosolutions.pl/news/118/129/Wtyczka-QGIS---Pobieracz-Danych-GUGiK.html" target="_blank"><span style="color:rgb(46,116,181)">Pobieracz Danych GUGiK</span></a></span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">
– laureat nagrody GUGiK na najlepsze wykorzystanie danych
i usług GUGiK w 2020 r. oraz w 2021 r.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"> Lizmap
[<a href="mailto:lizmap-bounces@lists.osgeo.org" target="_blank">mailto:lizmap-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Carlo A. Nicolini (cxc)<br>
<b>Sent:</b> Tuesday, October 5, 2021 9:14 PM<br>
<b>To:</b> <a href="mailto:lizmap@lists.osgeo.org" target="_blank">lizmap@lists.osgeo.org</a><br>
<b>Subject:</b> [Lizmap] Qgis project, login postgis and
Lizmap<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><span><span lang="EN">Hello
</span></span><span lang="EN"><br>
<br>
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span><span lang="EN">I
would like to publish a Lizmap project linked to db
postgresql / postgis. </span></span><span lang="EN"><br>
<br>
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span><span lang="EN">In
the various tests I have found that Lizmap does not
accept qgis configurations.</span></span><span><span lang="EN"> </span></span><span lang="EN"><br>
<br>
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span><span lang="EN">Storing
user and pass works but exposes user and pass in the
.qgs file </span></span><span lang="EN"><br>
<br>
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span><span lang="EN">Is
this all correct or are there other possibilities? </span></span><span lang="EN"><br>
<br>
</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span><span lang="EN">Thank
you Carlo A.</span></span><span lang="EN"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Lizmap mailing list
<a href="mailto:Lizmap@lists.osgeo.org" target="_blank">Lizmap@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
Lizmap mailing list<br>
<a href="mailto:Lizmap@lists.osgeo.org" target="_blank">Lizmap@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><p> <span style="font-weight:bold;color:rgb(154,205,50)">Etienne Trimaille</span>
<br>Ingénieur géomaticien <br>
<a href="http://www.3liz.com" style="text-decoration:none;color:rgb(154,205,50)" target="_blank">www.3liz.com</a> <br>
</p><p><span style="font-size:0.8em"> +33 6 12 93 11 39<br></span></p><p><span style="font-size:0.8em">
<br>
<b>Siège social</b> <br>
73, allée Kleber <br>
Boulevard de Strasbourg <br>
34000 Montpellier </span>
</p></div></div></div></div></div></div>