Re: [QGIS-Developer] [PyQGIS] adding a layer with an auth config ID leaks into the project

[Denis Rouzaud]

Hi Bernard,

Many thanks works perfectly.


Le lun. 14 oct. 2019 à 16:13, Bernhard Ströbl  a
écrit :

> Hi Denis,
>
> I use:
> uri = QgsDataSourceUri()
> uri.setDataSource(schemaName, tableName, geomColumn)
> uri.setConnection(thisHostName,
>  str(thisPort), thisDatabaseName,
>  "", "", QgsDataSourceUri.SslRequire, thisAuthCfgId)
> vLayerUri = uri.uri(False)
> vlayer = QgsVectorLayer(vLayerUri, displayName, "postgres",
>  layerOptions)
>
> this works as expected storing the authcfg=auth_id using QGIS 3.4
>
> Bernhard
>
> Am 14.10.2019 um 15:52 schrieb Denis Rouzaud:
> > Hi all,
> >
> > I add a layer using an authentification config ID using PyQGIS:
> >
> > uri = QgsDataSourceUri()
> > uri.setConnection(HOST, PORT, DB, None, None,
> > QgsDataSourceUri.SslPrefer, pg_auth_id)
> >
> > In the project, the credentials are written in clear text in the project
> > file:
> >
> > dbname='pub' host=geodb.rootso.org 
>
> > port=5432 user='xx' password='xx'
> >
> > Is it possible to avoid this? How?
> >
> > Cheers,
> > Denis
> >
>
>
> __ Information from ESET Mail Security, version of virus signature
> database 20178 (20191014) __
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [PyQGIS] adding a layer with an auth config ID leaks into the project

[Bernhard Ströbl]

Hi Denis,

I use:
uri = QgsDataSourceUri()
uri.setDataSource(schemaName, tableName, geomColumn)
uri.setConnection(thisHostName,
str(thisPort), thisDatabaseName,
"", "", QgsDataSourceUri.SslRequire, thisAuthCfgId)
vLayerUri = uri.uri(False)
vlayer = QgsVectorLayer(vLayerUri, displayName, "postgres",
layerOptions)

this works as expected storing the authcfg=auth_id using QGIS 3.4

Bernhard

Am 14.10.2019 um 15:52 schrieb Denis Rouzaud:

Hi all,

I add a layer using an authentification config ID using PyQGIS:

uri = QgsDataSourceUri()
uri.setConnection(HOST, PORT, DB, None, None, 
QgsDataSourceUri.SslPrefer, pg_auth_id)


In the project, the credentials are written in clear text in the project 
file:


dbname='pub' host=geodb.rootso.org  
port=5432 user='xx' password='xx'


Is it possible to avoid this? How?

Cheers,
Denis




__ Information from ESET Mail Security, version of virus signature 
database 20178 (20191014) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] [PyQGIS] adding a layer with an auth config ID leaks into the project

[Denis Rouzaud]

Hi all,

I add a layer using an authentification config ID using PyQGIS:

uri = QgsDataSourceUri()
uri.setConnection(HOST, PORT, DB, None, None, QgsDataSourceUri.SslPrefer,
pg_auth_id)

In the project, the credentials are written in clear text in the project
file:

dbname='pub' host=geodb.rootso.org port=5432 user='xx'
password='xx'

Is it possible to avoid this? How?

Cheers,
Denis
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer