On 03.02.23 20:06, chris hermansen wrote:
On Fri, Feb 3, 2023 at 9:25 AM Tomas Pospisek via QGIS-User
<[email protected] <mailto:[email protected]>> wrote:
On 03.02.23 18:02, chris hermansen wrote:
> >
> On Fri, Feb 3, 2023 at 8:11 AM Tomas Pospisek via QGIS-User
> <[email protected] <mailto:[email protected]>
<mailto:[email protected]
<mailto:[email protected]>>> wrote:
>
> When I try to set up a connection to a Postgres/Postgis DB server
with
> Active Directory/Kerberos/GSS authentication the QGIS DB setup dialog
> displays this message:
>
> gssencmode value "require" invalid when GSSAPI support is not
compiled in
>
> When I check the Postgres source code [1] I see that apparently this
> gets displayed when GSS support is not compiled in.
>
> So it seems QGIS as shipped by qgis.org does not ship with GSS
support?
> Is that correct?
>
> Does anybody use QGIS on Windows with GSS? How did you do it?
>
> I could go ahead and download the EDB Postgres ZIP [3] and exctract
> libpq.dll from it and replace the libqq.dll shipped by the QGIS
> installer with it, but I'm not sure if that would work at all, if
that
> would be robust and it'll certainly be a pain to maintain.
>
> Any pointers/suggestions/help?
>
>
> Maybe this is the proverbial dumb question... but why not install your
> EDB PostgreSQL on your windows machine and run it on a different port?
> And then connect to it from your QGIS instance, on that different port
> of course?
Thanks for your answer Chris, but I can't see how you your reply relates
to my question. I need QGIS to authenticate users with Active
Directory/Kerberos. That QGIS/libpq fails to do so doesn't have anything
to do with ports but with the fact that GSS support is not compiled into
the libpq that is furnished with QGIS.
Sorry I was somehow thinking that by using a different PostgreSQL
installation "in its entirety" you could avoid using the libqq.dll (or
is it libpq.dll) that QGIS installs.
Yeah, that's kinda what I have in mind, however I fear DLL hell and I am
not knowledgeable how to do it "right". So that's why I am asking for
advice from people who might have travelled this path before...
My apologies for contributing nothing useful to the solution of your
problem.
Ah, I'm sorry for making it sound like that :-(. I'm very glad you tried
to help...! Thank you :-)!
*t
_______________________________________________
QGIS-User mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
