<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:#1F497D;}
.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">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Sorry,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US">my example was bad
<br>
</span><span lang="EN-US" style="font-family:"Arial","sans-serif"">QGIS_AUTH_PASSWORD_FILE already points to a full path to the text file containing the password<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US">but
</span><span lang="EN-US" style="font-family:"Arial","sans-serif"">FcgidInitialEnv vars are not mentioned by QGIS Server log<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Instead it shows
</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Auth DB PATH: //.local/share/QGIS/QGIS3/profiles/default/qgis-auth.db</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Mit freundlichen Grüßen
<br>
Im Auftrag <br>
<br>
<b>Stefan Overkamp </b></span><span style="color:#1F497D"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="663" style="width:497.25pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Team Geodaten-Technik<br>
<b>Referat Geoinformation und Raumbeobachtung</b><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Kronprinzenstraße 6
<br>
45128 Essen </span><span style="font-size:10.0pt;color:#1F497D"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="216" style="width:162.0pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">T:<br>
F: <o:p></o:p></span></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">+49 201 2069-700<br>
+49 201 2069-369 <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:#1F497D;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="250" style="width:187.5pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">overkamp@rvr.ruhr</span><span style="color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D"> <br>
</span><span style="font-family:"Arial","sans-serif";color:#1F497D"><img width="226" height="107" id="_x0000_i1026" src="cid:image001.jpg@01D52B74.6EA70D20"></span><span style="font-family:"Arial","sans-serif";color:#1F497D"><br>
</span><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">Regionalverband Ruhr
</span></b><span style="font-size:7.5pt;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">Die Regionaldirektorin
<br>
<br>
Kronprinzenstraße 35 <br>
45128 Essen </span><span style="font-size:7.5pt;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">T: +49 201 2069-0
<br>
F: +49 201 2069-500 <br>
www.rvr.ruhr </span><span style="font-size:7.5pt;color:#1F497D"><br>
<br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">Postfach 10 32 64 | 45032 Essen
</span><span style="font-size:7.5pt;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">Steuernummer: 112/5797/0116 | USt.-ldNr.: DE 173867500<br>
</span><span style="font-size:7.5pt;color:#1F497D"><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 lang="EN-US" style="font-size:7.5pt;font-family:"Arial","sans-serif";color:silver">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" style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Von:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> Alessandro Pasotti [mailto:apasotti@gmail.com]
<br>
<b>Gesendet:</b> Dienstag, 25. Juni 2019 16:24<br>
<b>An:</b> Overkamp, Stefan<br>
<b>Cc:</b> qgis-user@lists.osgeo.org<br>
<b>Betreff:</b> Re: [Qgis-user] QGIS Server qgis-auth.db<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">On Tue, Jun 25, 2019 at 4:17 PM Overkamp, Stefan <</span><a href="mailto:overkamp@rvr.ruhr"><span lang="EN-US">overkamp@rvr.ruhr</span></a><span lang="EN-US">> wrote:<o:p></o:p></span></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"><span style="font-family:"Arial","sans-serif"">Hi,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">I’m trying to configure Authentication Configuration for QGIS Server 3.4.9</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">In Apache2 I have set environment variables:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">FcgidInitialEnv QGIS_AUTH_DB_DIR_PATH /mypath/withoutqgisauthdb/</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">FcgidInitialEnv QGIS_AUTH_PASSWORD_FILE /mypath/withoutqgis-auth.db/</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Then I Have these files</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">/mypath/withoutqgisauthdb/qgis-auth.db and</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">/mypath/withoutqgisauthdb/authpwd with masterpassword</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Hi,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Arial","sans-serif"">QGIS_AUTH_PASSWORD_FILE needs to point to a full path to the text file containing the password and not to a directory.</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" style="font-family:"Arial","sans-serif"">From QGI S server code:</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Arial","sans-serif""> // 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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Hope it helps.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> <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"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">In a local test my qgs project file opens the postgis Layers with the authcfg in qgis-auth.db
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Calling a layer as wms, QGIS Server log shows:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">CRITICAL Server[17067]: Layer(s) … not valid</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">My environmental vars are not mentioned by QGIS Server log, instead it shows
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Auth DB PATH: //.local/share/QGIS/QGIS3/profiles/default/qgis-auth.db</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif"">Has anyone a running configuration for QGIS Server using qgis-auth.db ??</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-family:"Arial","sans-serif""> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Mit freundlichen Grüßen
<br>
Im Auftrag <br>
<br>
<b>Stefan Overkamp </b></span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="663" style="width:497.25pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Team Geodaten-Technik<br>
<b>Referat Geoinformation und Raumbeobachtung</b></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Kronprinzenstraße 6
<br>
45128 Essen </span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="216" style="width:162.0pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">T:<br>
F: </span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">+49 201 2069-700<br>
+49 201 2069-369 </span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="250" style="width:187.5pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><a href="mailto:overkamp@rvr.ruhr">overkamp@rvr.ruhr</a></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> <br>
</span><span style="font-family:"Arial","sans-serif""><img border="0" width="226" height="107" id="gmail-m_-4878486086360927035_x005f_x0000_i1025" src="cid:image001.jpg@01D52B74.6EA70D20"><br>
</span><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">Regionalverband Ruhr
</span></b><span style="font-size:7.5pt"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">Die Regionaldirektorin
<br>
<br>
Kronprinzenstraße 35 <br>
45128 Essen </span><span style="font-size:7.5pt"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">T: +49 201 2069-0
<br>
F: +49 201 2069-500 <br>
<a href="http://www.rvr.ruhr">www.rvr.ruhr</a> </span><span style="font-size:7.5pt"><br>
<br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">Postfach 10 32 64 | 45032 Essen
</span><span style="font-size:7.5pt"><br>
</span><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">Steuernummer: 112/5797/0116 | USt.-ldNr.: DE 173867500<br>
</span><span style="font-size:7.5pt"><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 lang="EN-US" style="font-size:7.5pt;font-family:"Arial","sans-serif";color:silver">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><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Alessandro Pasotti<br>
w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a><o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>