[Qgis-user] Qgis/Postgis : Disable double authentication request?

[Frank Broniewski]

Hi Laurent,

how do you authenticate against the PostGIS database? Do you use the 
Authentication manager? Then you might run into the same questions I 
asked last week, you might want to do a search on the mailing lists 
archive to see the answers I received on that topic.

In any case, if you use the authentication manager, the connection 
credetials to the PostGIS database are stored with a unique ID which is 
then in turn used in the layers connection string for reference. SInce 
this ID is different for each user, you run into the problem you 
encountered.

So, basically you have two options here:

* create an authentication entry with the same ID on each machine

* use PostgreSQL service files to connect to the database

The QGIS manual has a nice round up on the topic, you can find the 
related parts here 
https://docs.qgis.org/3.16/en/docs/user_manual/managing_data_source/opening_data.html?highlight=authentication#database-related-tools

HTH,

Frank

Am 01.12.21 um 15:55 schrieb celati Laurent:
> Good afternoon,
>
> I work on windows with qgis 3.16.6 and postgresql/postgis.
> I have shared a qgis project to several users. The layers are postgis 
> tables. For some time, whenever an user opens the project, it has been 
> constantly asked for a double authentication (id / pswd).
> Would somebody knows why and how to make so that there is as before a 
> single request for authentication?
>
> I paste below the header of my qgs project opened with a text editor; 
> confidential content is replaced by XXXXX :
>
> |<!DOCTYPE qgis PUBLIC 'http://mrcc.com/qgis.dtd' 'SYSTEM'> <qgis 
> saveDateTime="2021-11-25T15:26:51" saveUser="XXXXXX" 
> version="3.16.6-Hannover" saveUserFull="XXXXXXX" projectname=""> 
> <homePath path=""/> <title></title> <autotransaction active="0"/> 
> <evaluateDefaultValues active="0"/> |
> <trust active="0"/>
>
>
>
> Thanks a lot.
>
> _______________________________________________
> 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/20211203/a0d170cb/attachment.html>