<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">I've never used that mechanism. </p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">MapServer doesn't read or otherwise utilize that file or environment variable itself so the functionality must be inherent to the underlying Postgres C client library.</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">What packages did you update? Perhaps there was a permission change, missing Apache module (to set environment variables) or something along those lines?</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">--Steve</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> mapserver-users <mapserver-users-bounces@lists.osgeo.org> on behalf of Thomas Horner <haevitetty@gmail.com><br>
<b>Sent:</b> Saturday, August 17, 2019 1:09:18 PM<br>
<b>To:</b> mapserver-users@lists.osgeo.org <mapserver-users@lists.osgeo.org><br>
<b>Subject:</b> [mapserver-users] Mapserver no longer reading pgpass file?</font>
<div> </div>
</div>
<div>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="`"100%`"" style="width:100.0%">
<tbody>
<tr style="">
<td style="background:#FFC845; padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="`"100%`"" cellpadding="`"7px" color="`"#FFFF00`"" style="width:100.0%; background:#FFF3DD; padding:5.25pt 3.75pt 5.25pt 11.25pt; word-wrap:break-word">
<div>
<p class="x_MsoNormal" style=""></p>
<div style="font-size:11pt; font-family:Calibri,sans-serif; color:#003865"><b>This message may be from an external email source.</b><br>
</div>
<div style="font-size:9pt; font-family:Calibri,sans-serif; color:#003865">Do not select links or open attachments unless verified. Report all suspicious emails to Minnesota IT Services Security Operations Center.</div>
<p></p>
</div>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<div>
<div dir="ltr">Hi List,
<div><br>
</div>
<div>My MapServer mapfiles have been set up to read a Postgres connection with<br>
<br>
`PG:host=... post=... dbname=...` etc for some time now.</div>
<div><br>
</div>
<div>I upgraded the packages on my linux box and the mapfiles no longer work (error when connecting to postgres). However, running gdalinfo "PG:host... ..." using the exact same connection string works fine.</div>
<div><br>
</div>
<div>I realized that it's an authentication issue as the mapfiles work fine again when I add password=... to the connection string.</div>
<div><br>
</div>
<div>I have a pgpass file in the cgi-bin, and one in my home directory which is referenced with the PGPASS environment variable. Why would mapserver suddenly not provide the correct password or consume the pgpass file anymore? Does it need to be somewhere else?
Why does it work fine with gdalinfo without the password?<br>
<br>
Thanks,<br>
Thomas</div>
</div>
</div>
</div>
</body>
</html>