Thanks Luigi, I already tried removing it manually, but it's created again every time. So, does this mean that DB Manager for PostGIS on QGIS 3/Windows is currently broken?
Giovanni 2018-03-19 11:07 GMT+01:00 Luigi Pirelli <lui...@gmail.com>: > 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 <gioha...@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@lists.osgeo.org > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user