Glad it worked! On Feb 5, 2018 20:02, "Randal Hale" <rjh...@northrivergeographic.com> 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 <rjhale@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 > > > -- > 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