BUG #16320: GSSAPI Error

Started by PG Bug reporting formabout 6 years ago7 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16320
Logged by: Kinjal Brahmbhatt
Email address: brahmbhattkinjal18@gmail.com
PostgreSQL version: 12.2
Operating system: Mac
Description:

Hello, i tried to uninstall and reinstall the Postgresql multiple times, but
every time i go to enter my password, it gives me a GSSAPI error.

Please advise.

Thank you,
Kinjal Brahmbhatt

#2Fahar Abbas
fahar.abbas@enterprisedb.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16320: GSSAPI Error

Hi Kinjal,

What is the version of MAC OS X?

Can you please share screen-shot and install-postgresql.log file under /tmp
folder?

On Fri, Mar 27, 2020 at 12:14 AM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16320
Logged by: Kinjal Brahmbhatt
Email address: brahmbhattkinjal18@gmail.com
PostgreSQL version: 12.2
Operating system: Mac
Description:

Hello, i tried to uninstall and reinstall the Postgresql multiple times,
but
every time i go to enter my password, it gives me a GSSAPI error.

Please advise.

Thank you,
Kinjal Brahmbhatt

--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com

#3Stephen Frost
sfrost@snowman.net
In reply to: PG Bug reporting form (#1)
Re: BUG #16320: GSSAPI Error

Greetings,

* PG Bug reporting form (noreply@postgresql.org) wrote:

Hello, i tried to uninstall and reinstall the Postgresql multiple times, but
every time i go to enter my password, it gives me a GSSAPI error.

You're probably getting bit by the broken GSSAPI library on OSX. Try
installing a supported library (MIT Kerberos or Heimdal).

Thanks,

Stephen

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stephen Frost (#3)
Re: BUG #16320: GSSAPI Error

Stephen Frost <sfrost@snowman.net> writes:

* PG Bug reporting form (noreply@postgresql.org) wrote:

Hello, i tried to uninstall and reinstall the Postgresql multiple times, but
every time i go to enter my password, it gives me a GSSAPI error.

You're probably getting bit by the broken GSSAPI library on OSX. Try
installing a supported library (MIT Kerberos or Heimdal).

Should we document somewhere that we consider that unsupported?
Trying it here, I see a bunch of "deprecation" warnings during
the build, but it does build --- which might lead people to expect
that it'd work.

regards, tom lane

#5Stephen Frost
sfrost@snowman.net
In reply to: Tom Lane (#4)
Re: BUG #16320: GSSAPI Error

Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Stephen Frost <sfrost@snowman.net> writes:

* PG Bug reporting form (noreply@postgresql.org) wrote:

Hello, i tried to uninstall and reinstall the Postgresql multiple times, but
every time i go to enter my password, it gives me a GSSAPI error.

You're probably getting bit by the broken GSSAPI library on OSX. Try
installing a supported library (MIT Kerberos or Heimdal).

Should we document somewhere that we consider that unsupported?
Trying it here, I see a bunch of "deprecation" warnings during
the build, but it does build --- which might lead people to expect
that it'd work.

There had been discussion on another thread about trying to figure out a
way to detect the OSX GSSAPI library and refuse to build with GSSAPI
support when that's what we'd be building against. I didn't see anyone
post a patch though and I haven't got an OSX box to play with myself
easily at hand.

Thanks,

Stephen

#6Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stephen Frost (#5)
Re: BUG #16320: GSSAPI Error

Stephen Frost <sfrost@snowman.net> writes:

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Should we document somewhere that we consider that unsupported?
Trying it here, I see a bunch of "deprecation" warnings during
the build, but it does build --- which might lead people to expect
that it'd work.

There had been discussion on another thread about trying to figure out a
way to detect the OSX GSSAPI library and refuse to build with GSSAPI
support when that's what we'd be building against. I didn't see anyone
post a patch though and I haven't got an OSX box to play with myself
easily at hand.

Just poking around, it looks like something along this line would work:

#ifdef GSSKRB_APPLE_DEPRECATED
#error "Postgres doesn't work with the macOS GSSAPI library, please use XXX instead."
#endif

(in any suitable spot after #including gssapi.h)

Now, this is testing the *headers* not the actual *library*, which in
some sense is not the right thing. But it's probably close enough for
the purpose.

regards, tom lane

#7Stephen Frost
sfrost@snowman.net
In reply to: Tom Lane (#6)
Re: BUG #16320: GSSAPI Error

Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Stephen Frost <sfrost@snowman.net> writes:

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Should we document somewhere that we consider that unsupported?
Trying it here, I see a bunch of "deprecation" warnings during
the build, but it does build --- which might lead people to expect
that it'd work.

There had been discussion on another thread about trying to figure out a
way to detect the OSX GSSAPI library and refuse to build with GSSAPI
support when that's what we'd be building against. I didn't see anyone
post a patch though and I haven't got an OSX box to play with myself
easily at hand.

Just poking around, it looks like something along this line would work:

#ifdef GSSKRB_APPLE_DEPRECATED
#error "Postgres doesn't work with the macOS GSSAPI library, please use XXX instead."
#endif

(in any suitable spot after #including gssapi.h)

Now, this is testing the *headers* not the actual *library*, which in
some sense is not the right thing. But it's probably close enough for
the purpose.

Sounds good to me.

Thanks,

Stephen