[Qgis-user] DB Manager cannot connect to PostGIS (error with traceback)

[G. Allegri]

Hi all,
I'm facing the following issue with QGIS 3.1.0 (10044fb1dd
<https://github.com/qgis/QGIS/commit/10044fb1dd>) on Windows 10.
I can define a connection to my local PG, using basic authentication, and I
can access data from Browser.
If I try to open the connection from DB Manager I obtain;

Traceback (most recent call last): File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_model.py", line
441, in rowCount self._refreshIndex(parent, True) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_model.py", line
490, in _refreshIndex if item.populate(): File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_model.py", line
167, in populate if not connection.connect(): File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\postgis\plugin.py",
line 103, in connect return self.connectToUri(uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\plugin.py",
line 109, in connectToUri self.db = self.databasesFactory(self, uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\postgis\plugin.py",
line 70, in databasesFactory return PGDatabase(connection, uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\postgis\plugin.py",
line 111, in __init__ Database.__init__(self, connection, uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\plugin.py",
line 218, in __init__ self.connector = self.connectorsFactory(uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\postgis\plugin.py",
line 114, in connectorsFactory return PostGisDBConnector(uri) File
"C:/OSGEO4~1/apps/qgis-dev/./python/plugins\db_manager\db_plugins\postgis\connector.py",
line 128, in __init__ os.remove(sslCAFile) PermissionError: [WinError 5]
Access denied:
'C:/Users/giohappy/AppData/Local/Temp/tmp_basic_{4703a7e8-5f5a-44ec-b490-7fd4ec0e9f7f}.pem'

I've tried removing and recreating the auth credentials.
I've tried also running QGIS as administrator.
Nothing seems to work...

Is it a known bug?

Giovanni
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180319/ca3397a9/attachment.html>