Re: GSSAPI Authentication for pgadmin4 macOS client

> On Oct 27, 2020, at 12:23 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Sean McDaniel <sean(dot)m(dot)mcdaniel(at)gmail(dot)com> 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
>
>