<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 25, 2019 at 4:17 PM Overkamp, Stefan <overkamp@rvr.ruhr> wrote:<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 lang="DE">
<div class="gmail-m_-4878486086360927035WordSection1">
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">I’m trying to configure Authentication Configuration for QGIS Server 3.4.9<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">In Apache2 I have set environment variables:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH /mypath/withoutqgisauthdb/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE /mypath/withoutqgis-auth.db/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">Then I Have these files<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">/mypath/withoutqgisauthdb/qgis-auth.db and<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">/mypath/withoutqgisauthdb/authpwd with masterpassword</span></p></div></div></blockquote><div><br></div><div>Hi,</div><div><br></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US">QGIS_AUTH_PASSWORD_FILE needs to point to a full path to the text file containing the password and not to a directory.</span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US"><br></span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US">From QGI S server code:<br></span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US">  // Initialize the authentication system<br>  //   creates or uses qgis-auth.db in ~/.qgis3/ or directory defined by QGIS_AUTH_DB_DIR_PATH env variable<br>  //   set the master password as first line of file defined by QGIS_AUTH_PASSWORD_FILE env variable<br>  //   (QGIS_AUTH_PASSWORD_FILE variable removed from environment after accessing)<br> </span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US"><br></span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US">Hope it helps.<br></span></div><div><span style="font-family:"Arial","sans-serif"" lang="EN-US"><br></span></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="DE"><div class="gmail-m_-4878486086360927035WordSection1"><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">In a local test my qgs project file opens the postgis Layers with the authcfg in qgis-auth.db
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">Calling a layer as wms, QGIS Server log shows:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">CRITICAL Server[17067]: Layer(s) … not valid<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">My environmental vars are not mentioned by QGIS Server log, instead it shows
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">Auth DB PATH: //.local/share/QGIS/QGIS3/profiles/default/qgis-auth.db<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US">Has anyone a running configuration for QGIS Server using qgis-auth.db ??<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12pt"><span style="font-size:10pt;font-family:"Arial","sans-serif"">Mit freundlichen Grüßen
<br>
Im Auftrag <br>
<br>
<b>Stefan Overkamp </b></span><span style="font-size:12pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
<table class="gmail-m_-4878486086360927035MsoNormalTable" style="width:497.25pt" width="663" cellspacing="1" cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0cm" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif"">Team Geodaten-Technik<br>
<b>Referat Geoinformation und Raumbeobachtung</b><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif"">Kronprinzenstraße 6
<br>
45128 Essen </span><span style="font-size:10pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
<table class="gmail-m_-4878486086360927035MsoNormalTable" style="width:162pt" width="216" cellspacing="1" cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0cm" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif"">T:<br>
F: <u></u><u></u></span></p>
</td>
<td style="padding:0cm" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif"">+49 201 2069-700<br>
+49 201 2069-369 <u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Times New Roman","serif";display:none"><u></u> <u></u></span></p>
<table class="gmail-m_-4878486086360927035MsoNormalTable" style="width:187.5pt" width="250" cellspacing="1" cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0cm" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif"">overkamp@rvr.ruhr</span><span style="font-size:12pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial","sans-serif""> <br>
</span><span style="font-size:12pt;font-family:"Arial","sans-serif""><img id="gmail-m_-4878486086360927035_x0000_i1025" src="cid:16b8f034ac74ce8e91" width="226" height="107"></span><span style="font-size:12pt;font-family:"Arial","sans-serif""><br>
</span><b><span style="font-size:8pt;font-family:"Arial","sans-serif"">Regionalverband Ruhr
</span></b><span style="font-size:7.5pt;font-family:"Times New Roman","serif""><br>
</span><span style="font-size:8pt;font-family:"Arial","sans-serif"">Die Regionaldirektorin
<br>
<br>
Kronprinzenstraße 35 <br>
45128 Essen </span><span style="font-size:7.5pt;font-family:"Times New Roman","serif""><br>
</span><span style="font-size:8pt;font-family:"Arial","sans-serif"">T: +49 201 2069-0
<br>
F: +49 201 2069-500 <br>
www.rvr.ruhr </span><span style="font-size:7.5pt;font-family:"Times New Roman","serif""><br>
<br>
</span><span style="font-size:8pt;font-family:"Arial","sans-serif"">Postfach 10 32 64 | 45032 Essen
</span><span style="font-size:7.5pt;font-family:"Times New Roman","serif""><br>
</span><span style="font-size:8pt;font-family:"Arial","sans-serif"">Steuernummer: 112/5797/0116 | USt.-ldNr.: DE 173867500<br>
</span><span style="font-size:7.5pt;font-family:"Times New Roman","serif""><br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:silver">Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E- Mail irrtümlich
 erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail sind nicht gestattet.
<br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:silver" lang="EN-US">This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in
 error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
</span><span lang="EN-US"><u></u><u></u></span></p>
</div>
</div>

_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature">Alessandro Pasotti<br>w3:   <a href="http://www.itopen.it" target="_blank">www.itopen.it</a></div></div>