Re: [Qgis-user] Auth Manager

[Alessandro Pasotti]

Glad it worked!

On Feb 5, 2018 20:02, "Randal Hale"  wrote:

> 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  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 xxx
>> never get replaced by the Auth-id of their machine of  - 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
>
>
> --
> Randal Hale 
> rjhale@northrivergeographic.comhttps://www.northrivergeographic.com
> (423)653-3611
>
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [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 
> 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
xxx never get replaced by the Auth-id of their machine of
 - 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 


--
Randal Hale
rjh...@northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

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

Re: [Qgis-user] Auth Manager

[Alessandro Pasotti]

On Mon, Feb 5, 2018 at 6:57 PM, Randal Hale  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 xxx never
> get replaced by the Auth-id of their machine of  - 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
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Auth Manager

[Randal Hale]

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 xxx 
never get replaced by the Auth-id of their machine of  - 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




--
Randal Hale
rjh...@northrivergeographic.com
https://www.northrivergeographic.com
(423)653-3611

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