<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>