Re: [Qgis-developer] PG credentials

[Luigi Pirelli]

> * if one inserts the credentials at project startup, these seem to be
> remembered upon further opening of the project (unsure about other
> projects), even after restarting QGIS.

There is no cache other that that expressed by Jürgen => cache is
removed after closing qgis session.
The only way to remember pws is to save in the project (old dangerous
way) or saving using qgis auth manager (crypted using master pwd)

so something is wrong in your tests.
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Paolo Cavallini]

Il 19/10/2016 11:19, DelazJ ha scritto:
> No, it isn't. Paolo, could you fill a ticket in the repository, please?

Done:
https://github.com/qgis/QGIS-Documentation/issues/1458
Thanks.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[DelazJ]

Hi,

2016-10-19 8:37 GMT+02:00 Jürgen E. Fischer :

> Hi Paolo,
>
> On Tue, 18. Oct 2016 at 18:19:08 +0200, Paolo Cavallini wrote:
> > Thanks Jürgen for the clarification. You mean the OS session, not the
> > QGIS one, right?
>
> No, the QGIS session - since Feb 2010.  So nothing new.
>
> > Is this documented in the manual?
>
> No, it isn't. Paolo, could you fill a ticket in the repository, please?
Thanks.

Harrissou


> No idea.
>
>
> Jürgen
>
> --
> Jürgen E. Fischer   norBIT GmbH Tel.
> +49-4931-918175-31
> Dipl.-Inf. (FH) Rheinstraße 13  Fax.
> +49-4931-918175-50
> Software Engineer   D-26506 Norden
> http://www.norbit.de
> QGIS release manager (PSC)  GermanyIRC: jef on FreeNode
>
> ___
> Qgis-developer mailing list
> Qgis-developer@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Jürgen E . Fischer]

Hi Paolo,

On Tue, 18. Oct 2016 at 18:19:08 +0200, Paolo Cavallini wrote:
> Thanks Jürgen for the clarification. You mean the OS session, not the
> QGIS one, right?

No, the QGIS session - since Feb 2010.  So nothing new.

> Is this documented in the manual?

No idea.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Norden http://www.norbit.de
QGIS release manager (PSC)  GermanyIRC: jef on FreeNode 



pgpBGfYzHukb1.pgp
Description: PGP signature
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Paolo Cavallini]

Il 18/10/2016 18:23, Matthias Kuhn ha scritto:

> Something else that is able to cache passwords persistently is the auth
> system
> 
> https://docs.qgis.org/2.14/en/docs/user_manual/auth_system/auth_overview.html

Yes, but this has to be done explicitly, the base mechanism is
transparent (and may be surprising) to the user.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Matthias Kuhn]

Hi Paolo

On 10/18/2016 06:19 PM, Paolo Cavallini wrote:
> Il 18/10/2016 17:58, Jürgen E. Fischer ha scritto:
>> H Paolo,
>>
>> On Tue, 18. Oct 2016 at 16:44:31 +0200, Paolo Cavallini wrote:
>>> thanks for the feedback. The situation is:
>>> * a qgs project pointing to PostgreSQL, without username and password
>>> * if one inserts the credentials at project startup, these seem to be
>>> remembered upon further opening of the project (unsure about other
>>> projects), even after restarting QGIS.
>>> It seems therefore impossible that QGIS takes it from .pgpass.
>>
>> Entered passwords are cached for the session - but not stored in the layers.
> 
> Thanks Jürgen for the clarification. You mean the OS session, not the
> QGIS one, right? Is this documented in the manual?
> All the best.
> 

Something else that is able to cache passwords persistently is the auth
system

https://docs.qgis.org/2.14/en/docs/user_manual/auth_system/auth_overview.html

Matthias
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Paolo Cavallini]

Il 18/10/2016 17:58, Jürgen E. Fischer ha scritto:
> H Paolo,
> 
> On Tue, 18. Oct 2016 at 16:44:31 +0200, Paolo Cavallini wrote:
>> thanks for the feedback. The situation is:
>> * a qgs project pointing to PostgreSQL, without username and password
>> * if one inserts the credentials at project startup, these seem to be
>> remembered upon further opening of the project (unsure about other
>> projects), even after restarting QGIS.
>> It seems therefore impossible that QGIS takes it from .pgpass.
> 
> Entered passwords are cached for the session - but not stored in the layers.

Thanks Jürgen for the clarification. You mean the OS session, not the
QGIS one, right? Is this documented in the manual?
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Jürgen E . Fischer]

H Paolo,

On Tue, 18. Oct 2016 at 16:44:31 +0200, Paolo Cavallini wrote:
> thanks for the feedback. The situation is:
> * a qgs project pointing to PostgreSQL, without username and password
> * if one inserts the credentials at project startup, these seem to be
> remembered upon further opening of the project (unsure about other
> projects), even after restarting QGIS.
> It seems therefore impossible that QGIS takes it from .pgpass.

Entered passwords are cached for the session - but not stored in the layers.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Norden http://www.norbit.de
QGIS release manager (PSC)  GermanyIRC: jef on FreeNode 



pgp0zU1cCDxsN.pgp
Description: PGP signature
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Paolo Cavallini]

Il 18/10/2016 13:54, Neumann, Andreas ha scritto:
> Hi Paolo,
> 
> hm - not sure.
> 
> If you have a .pgpass file it may take credentials from the .pgpass file.
> 
> Not sure what you mean "from the system" - you mean the credentials from
> the operating system? Yes - this is another fallback mechanism - but it
> depends how you configured your PostgreSQL access controls.

Hi Andreas,
thanks for the feedback. The situation is:
* a qgs project pointing to PostgreSQL, without username and password
* if one inserts the credentials at project startup, these seem to be
remembered upon further opening of the project (unsure about other
projects), even after restarting QGIS.
It seems therefore impossible that QGIS takes it from .pgpass.
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] PG credentials

[Neumann, Andreas]

Hi Paolo, 

hm - not sure. 

If you have a .pgpass file it may take credentials from the .pgpass
file. 

Not sure what you mean "from the system" - you mean the credentials from
the operating system? Yes - this is another fallback mechanism - but it
depends how you configured your PostgreSQL access controls. 

Greetings, 

Andreas 

On 2016-10-18 13:25, Paolo Cavallini wrote:

> Hi all,
> if I open a project without saved credentials for PostgreSQL access,
> they seem to be taken from the system (the last used credentials). Is
> this confirmed, and the expected behaviour?
> All the best, and thanks.

  ___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] PG credentials

[Paolo Cavallini]

Hi all,
if I open a project without saved credentials for PostgreSQL access,
they seem to be taken from the system (the last used credentials). Is
this confirmed, and the expected behaviour?
All the best, and thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer