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

Tue Mar 20 10:04:03 PDT 2018

thanks Luigi!

2018-03-20 16:59 GMT+01:00 Luigi Pirelli <luipir at gmail.com>:

> 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
> >> >>
> >> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180320/d5dc75dc/attachment.html>