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

[Luigi Pirelli]

he PR was from Boundless repo, make sense to ask to boundless if they
want to continue to support QGIS porting patches to 3.0?
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 11:28, Luigi Pirelli <luipir at gmail.com> wrote:
> yes sorry... not yet merged, and the PR have to be aligned to the current code
> 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 11:22, G. Allegri <giohappy at gmail.com> wrote:
>> 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 <luipir at 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 <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
>>
>>