Re: [Qgis-developer] PG credentials
> * 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
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&geo=IT&q=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
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
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
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&geo=IT&q=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
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
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&geo=IT&q=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
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
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&geo=IT&q=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
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