<div dir="ltr"><div>Thanks Luigi,</div>I already tried removing it manually, but it's created again every time.<div>So, does this mean that DB Manager for PostGIS on QGIS 3/Windows is currently broken?</div><div><br></div><div>Giovanni</div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-03-19 11:07 GMT+01:00 Luigi Pirelli <span dir="ltr"><<a href="mailto:luipir@gmail.com" target="_blank">luipir@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">you can safetly remove<br>
C:/Users/giohappy/AppData/<wbr>Local/Temp/tmp_basic_{<wbr>4703a7e8-5f5a-44ec-b490-<wbr>7fd4ec0e9f7f}.pem<br>
and try again<br>
<br>
btw it was fixed since in month in 2-18 <a href="https://github.com/qgis/QGIS/pull/5477" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/<wbr>pull/5477</a><br>
but port to 3.0 was stopped <a href="https://github.com/qgis/QGIS/pull/5599" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/<wbr>pull/5599</a> due<br>
Boundless closed the QGIS team and I forgot it<br>
<br>
Luigi Pirelli<br>
<br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" rel="noreferrer" target="_blank">https://www.linkedin.com/in/<wbr>luigipirelli</a><br>
* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" rel="noreferrer" target="_blank">http://gis.stackexchange.com/<wbr>users/19667/luigi-pirelli</a><br>
* GitHub: <a href="https://github.com/luipir" rel="noreferrer" target="_blank">https://github.com/luipir</a><br>
* Mastering QGIS 2nd Edition:<br>
* <a href="https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition" rel="noreferrer" target="_blank">https://www.packtpub.com/big-<wbr>data-and-business-<wbr>intelligence/mastering-qgis-<wbr>second-edition</a><br>
* Hire me: <a href="http://goo.gl/BYRQKg" rel="noreferrer" target="_blank">http://goo.gl/BYRQKg</a><br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
<div><div class="h5"><br>
<br>
On 19 March 2018 at 10:59, G. Allegri <<a href="mailto:giohappy@gmail.com">giohappy@gmail.com</a>> wrote:<br>
> Hi all,<br>
> I'm facing the following issue with QGIS 3.1.0 (10044fb1dd) on Windows 10.<br>
> I can define a connection to my local PG, using basic authentication, and I<br>
> can access data from Browser.<br>
> If I try to open the connection from DB Manager I obtain;<br>
><br>
> Traceback (most recent call last): File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>model.py", line<br>
> 441, in rowCount self._refreshIndex(parent, True) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>model.py", line<br>
> 490, in _refreshIndex if item.populate(): File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>model.py", line<br>
> 167, in populate if not connection.connect(): File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\postgis\plugin.py",<br>
> line 103, in connect return self.connectToUri(uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\plugin.py",<br>
> line 109, in connectToUri self.db = self.databasesFactory(self, uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\postgis\plugin.py",<br>
> line 70, in databasesFactory return PGDatabase(connection, uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\postgis\plugin.py",<br>
> line 111, in __init__ Database.__init__(self, connection, uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\plugin.py",<br>
> line 218, in __init__ self.connector = self.connectorsFactory(uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\postgis\plugin.py",<br>
> line 114, in connectorsFactory return PostGisDBConnector(uri) File<br>
> "C:/OSGEO4~1/apps/qgis-dev/./<wbr>python/plugins\db_manager\db_<wbr>plugins\postgis\connector.py",<br>
> line 128, in __init__ os.remove(sslCAFile) PermissionError: [WinError 5]<br>
> Access denied:<br>
> 'C:/Users/giohappy/AppData/<wbr>Local/Temp/tmp_basic_{<wbr>4703a7e8-5f5a-44ec-b490-<wbr>7fd4ec0e9f7f}.pem'<br>
> I've tried removing and recreating the auth credentials.<br>
> I've tried also running QGIS as administrator.<br>
> Nothing seems to work...<br>
><br>
> Is it a known bug?<br>
><br>
> Giovanni<br>
><br>
</div></div>> ______________________________<wbr>_________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">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/<wbr>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/<wbr>mailman/listinfo/qgis-user</a><br>
</blockquote></div><br></div>