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

[Luigi Pirelli]

you can safetly remove
C:/Users/giohappy/AppData/Local/Temp/tmp_basic_{4703a7e8-5f5a-44ec-b490-7fd4ec0e9f7f}.pem
and try again

btw it was fixed since in month in 2-18 https://github.com/qgis/QGIS/pull/5477
but port to 3.0 was stopped https://github.com/qgis/QGIS/pull/5599 due
Boundless closed the QGIS team and I forgot it

Luigi Pirelli

**************************************************************************************************
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
* https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**************************************************************************************************


On 19 March 2018 at 10:59, G. Allegri <giohappy at gmail.com> wrote:
> Hi all,
> I'm facing the following issue with QGIS 3.1.0 (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
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user