<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,</p>
<p>You can also use postgresql service file :
<a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/14/libpq-pgservice.html">https://www.postgresql.org/docs/14/libpq-pgservice.html</a></p>
<p>Regards.<br>
</p>
<div class="moz-cite-prefix">Le 05/10/2021 à 21:20,
<a class="moz-txt-link-abbreviated" href="mailto:michal.wloga@envirosolutions.pl">michal.wloga@envirosolutions.pl</a> a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:00a501d7ba1e$1ce4f070$56aed150$@envirosolutions.pl">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}@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;}@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}span.viiyi
{mso-style-name:viiyi;}span.jlqj4b
{mso-style-name:jlqj4b;}span.zeswk
{mso-style-name:zeswk;}span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Hi Carlo,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
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<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Pozdrawiam,<o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#33BB5A">EnviroSolutions
Sp. z o. o.<br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Michał
Włoga<br>
tel: +48 607 059 157<br>
<a href="mailto:coo@envirosolutions.pl"
moz-do-not-send="true"><span style="color:#0563C1">coo@envirosolutions.pl</span></a><br>
<a href="http://www.envirosolutions.pl/szkolenia"
target="_blank" moz-do-not-send="true"><span
style="color:#0563C1">www.envirosolutions.pl</span></a></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#00B0F0"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#2E74B5"><a
href="https://www.envirosolutions.pl/news/118/129/Wtyczka-QGIS---Pobieracz-Danych-GUGiK.html"
target="_blank" moz-do-not-send="true"><span
style="color:#2E74B5">Pobieracz Danych GUGiK</span></a></span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
– laureat nagrody GUGiK na najlepsze wykorzystanie danych
i usług GUGiK w 2020 r. oraz w 2021 r.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><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><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="EN-US">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="EN-US"> Lizmap
[<a class="moz-txt-link-freetext" href="mailto:lizmap-bounces@lists.osgeo.org">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 class="moz-txt-link-abbreviated" href="mailto:lizmap@lists.osgeo.org">lizmap@lists.osgeo.org</a><br>
<b>Subject:</b> [Lizmap] Qgis project, login postgis and
Lizmap<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span class="jlqj4b"><span lang="EN">Hello
</span></span><span lang="EN"><br>
<br>
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span class="jlqj4b"><span lang="EN">I
would like to publish a Lizmap project linked to db
postgresql / postgis. </span></span><span lang="EN"><br>
<br>
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span class="jlqj4b"><span lang="EN">In
the various tests I have found that Lizmap does not
accept qgis configurations.</span></span><span
class="viiyi"><span lang="EN"> </span></span><span
lang="EN"><br>
<br>
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span class="jlqj4b"><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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span class="jlqj4b"><span lang="EN">Is
this all correct or are there other possibilities? </span></span><span
lang="EN"><br>
<br>
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span class="jlqj4b"><span lang="EN">Thank
you Carlo A.</span></span><span lang="EN"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></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>
</body>
</html>