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

[Luigi Pirelli]

working on that... seems Boundless master repo remained to november
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 14:05, G. Allegri <giohappy at gmail.com> wrote:
> Well, I don't know if they're inclined to do it but it would nice to know
> how they want to manage it...
>
> This is a severe bug for Windows.
>
> Giovanni
>
> Il lun 19 mar 2018, 13:34 Luigi Pirelli <luipir at gmail.com> ha scritto:
>>
>> 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
>> >>
>> >>