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

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

2018-03-20 Thread G. Allegri

thanks Luigi!

2018-03-20 16:59 GMT+01:00 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  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  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  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  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 :
> >> >>>
> >> >>> 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  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_
>

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

2018-03-20 Thread 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  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  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  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  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 :
>> >>>
>> >>> 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  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
>> >>> >
>> >>> >
>> >>> >

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

2018-03-19 Thread G. Allegri

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  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  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  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 :
> >>>
> >>> 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  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
> >>> >
> >>> >
>

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

2018-03-19 Thread 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  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  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 :
>>>
>>> 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  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?
>>> >

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

2018-03-19 Thread Luigi Pirelli

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  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 :
>>
>> 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  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

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

2018-03-19 Thread G. Allegri

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 :

> 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  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

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

2018-03-19 Thread 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  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

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

2018-03-19 Thread G. Allegri

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

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

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

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

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

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

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

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

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

8 matches

Site Navigation

Mail list logo

Footer information