Re: GSSAPI Authentication for pgadmin4 macOS client

[Neil <neil@xxxxxxxxxxxxxxxx>]

On Oct 27, 2020, at 12:23 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Sean McDaniel <sean.m.mcdaniel@xxxxxxxxx> 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 installed via homebrew and
it supports GSSAPI.  I can connect directly to the server using psql (and
pgcli) from the command line without issue.

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\ 4.app/Contents/Frameworks/libpq.5.dylib 

Since you say that you can connect with psql, it sounds like there is
more than one copy of libpq.dylib on your machine and not all of them
support GSSAPI.  You could use "otool -L" on psql to verify which
libpq it's linked to.  Perhaps the same thing will work on pgadmin,
but I'm unsure which file to check for that.  Anyway the bottom line
here is almost certainly that pgadmin isn't using your homebrew
build of libpq, but some other one.

I have tried to get pgadmin4 to use these binaries by putting
/usr/local/bin under Preferences > Paths > Binary Paths for "PostgreSQL
Binary Path" but that doesn't fix the issue, even after a pgadmin4 restart.

AFAIK that's only likely to help when pgadmin invokes pg_dump or
some other tool, not for its own connections to the server.

regards, tom lane