[Qgis-user] Auth Manager

[Randal Hale]

Actually - that's excellent - it's working like I thought it should now!

Thanks - I had been looking at this way too long and ignoring the fact I 
could make the authcfg whatever I wanted! So I was stuck on changing it 
when I just needed to set it up differently.


Randy


On 02/05/2018 01:06 PM, Alessandro Pasotti wrote:
> On Mon, Feb 5, 2018 at 6:57 PM, Randal Hale 
> <rjhale at northrivergeographic.com 
> <mailto:rjhale at northrivergeographic.com>> wrote:
>
>     I'm not entirely sure I've titled this correctly.
>
>     I have a client that has about 20 people editing. There is a want
>     to reduce editing pain by introducing dropdown lists in the form
>     of widgets.
>
>       * 20 users have 20 logins to the postgres/postgis database
>       * 20 users have 20 qgs files which need to be replaced
>
>     My first thought to "fix" some of the headache was using the
>     Authentification manager. I would have everyone set that up and I
>     could build the qgs files and pass them along. They would open
>     them and be asked for a password. The Authentification manager
>     passes their credentials back to the database. It replaces the
>     authcfg in the project with theirs and life is good.
>
>     What I am finding is that my layers which have an Auth-id of
>     xxxxxxx never get replaced by the Auth-id of their machine of
>     yyyyyyyy - so every time they open my new qgs file they are
>     prompted for the password of the authcfg database and their
>     connection credentials. Which - maybe that's the way it works and
>     not the way I think (which is generally not the way the world works).
>
>     example: /dbname='client_database' host=gis4 port 5432
>     sslmode=disable authcfg=*938s81lr* key='id' srid=2274
>     type=multilinestring table="fiber.m_fiber" (geom) sql=/
>
>     /Their authcfg is not/*/938s81lr. /*/It never gets replaced**with
>     their *authcfg*/*/
>     /*
>
>     Is there a way to replace authcfg with their authcfg which would
>     let me cascade these new QGIS files to the users? I could
>     eliminate three things that must be typed down to one upon opening
>     the file.
>
>     Thanks much! Hopefully this all makes some sense.
>
>     Randy
>
>
>
>
>
> Hi, maybe I misunderstood your needs but I don't see the issue.
>
> The authcfg is just an ID that the QGIS authentication manager uses to 
> retrieve the credentials from the QGIS user authentication DB.
>
> If I get your point, what I suggest you is that you create your 
> project (the one that needs to be distributed) and configure your 
> layers with a custom authcfg (you can use up to 7 digits or letters to 
> name it) and just tell the users to create an entry in their 
> authentication DB (using the authentication manager in their QGIS 
> instance) with same authcfg that you have chosen and  with their 
> credentials.
>
> Hope that helps!
>
> -- 
> Alessandro Pasotti
> w3: www.itopen.it <http://www.itopen.it>

-- 
Randal Hale
rjhale at northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180205/eaff31d3/attachment.html>