Re: GSSAPI authentication

2022-06-06 Thread Michael van der Kolff
3 PM Niels Jespersen wrote: >> >>> *Fra:* Michael van der Kolff >>> *Sendt:* 6. juni 2022 14:26 >>> *Til:* Niels Jespersen >>> *Cc:* pgsql-general list >>> *Emne:* Re: GSSAPI authentication >>> >>> >>> >>

Re: GSSAPI authentication

2022-06-06 Thread Michael van der Kolff
olff >> *Sendt:* 6. juni 2022 14:26 >> *Til:* Niels Jespersen >> *Cc:* pgsql-general list >> *Emne:* Re: GSSAPI authentication >> >> >> >> >This sounds like your PG service was unable to authenticate itself to AD. >> >> > >> >

Re: GSSAPI authentication

2022-06-06 Thread Michael van der Kolff
ell. --Michael On Mon, Jun 6, 2022 at 11:33 PM Niels Jespersen wrote: > *Fra:* Michael van der Kolff > *Sendt:* 6. juni 2022 14:26 > *Til:* Niels Jespersen > *Cc:* pgsql-general list > *Emne:* Re: GSSAPI authentication > > > > >This sounds like your PG se

Re: GSSAPI authentication

2022-06-06 Thread Michael van der Kolff
Looking closely at a configuration guide for MSSQL with Kerberos authentication, I see this part: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections?view=sql-server-ver16#Manual. It looks like it might be adapted to your

Re: GSSAPI authentication

2022-06-06 Thread Michael van der Kolff
This sounds like your PG service was unable to authenticate itself to AD. There's probably a trick to that somewhere - AD doesn't really want to be a Kerberos server, it just happens to use it 😉 On Mon, 6 June 2022, 10:05 pm Niels Jespersen, wrote: > Hello all > > > > We are running Postgres 14

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-11-02 Thread Sean McDaniel
Tom, I wasn't able to get pgadmin4 working with the symlinks, but I'm not very knowledgeable about libraries. But that's not a problem. I appreciate everyone diagnosing the issue. I'll reach out the pgsql-admin forum to see if there's a simple workaround or if a GSSAPI-enabled pgadmin4 client is

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Tom Lane
Sean McDaniel writes: > I followed your suggestions and symlinked libpq.5.dylib under > /Applications/pgAdmin 4.app/Contents/Frameworks to the homebrew library > /usr/lib/libpq.5.6.dylib, but unfortunately pgadmin4 now fails on launch > with the error "The pgadmin4 server could not be contacted."

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Sean McDaniel
Thanks Tom and Neil. What you've said makes sense. The pgadmin4 pibpq doesn't support GSSAPI. I followed your suggestions and symlinked libpq.5.dylib under /Applications/pgAdmin 4.app/Contents/Frameworks to the homebrew library /usr/lib/libpq.5.6.dylib, but unfortunately pgadmin4 now fails on lau

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Tom Lane
Neil writes: > On Oct 27, 2020, at 12:23 PM, Tom Lane wrote: >> A quick look through our source code finds that error string only in >> libpq; it indicates that libpq was built without GSSAPI support. > On my Mac pgadmin4 seems to use its own libpq. > You can find it at: /Applications/pgAdmin\

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Neil
> On Oct 27, 2020, at 12:23 PM, Tom Lane wrote: > > Sean McDaniel writes: >> I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a >> server of interest. The "Connect to Server" dialog box has a warning: >> "GSSAPI authentication not supported". I cannot proceed beyond tha

Re: GSSAPI Authentication for pgadmin4 macOS client

2020-10-27 Thread Tom Lane
Sean McDaniel writes: > I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a > server of interest. The "Connect to Server" dialog box has a warning: > "GSSAPI authentication not supported". I cannot proceed beyond that point. > It seems to be a GSSAPI issue. I have postgres