Re: BUG #9337: SSPI/GSSAPI with mismatched user names - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #9337: SSPI/GSSAPI with mismatched user names
Date
Msg-id 20140224192732.GQ2921@tamriel.snowman.net
Whole thread Raw
In response to Re: BUG #9337: SSPI/GSSAPI with mismatched user names  (Brian Crowell <brian@fluggo.com>)
List pgsql-bugs
* Brian Crowell (brian@fluggo.com) wrote:
> On Mon, Feb 24, 2014 at 1:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Why exactly doesn't Npgsql know what the Kerberos principal name is?
> > How did it obtain the ticket without knowing that?
>=20
> Windows obtained the ticket, not Npgsql. It's attached to my logon
> token without Npgsql's help. If I'm on the domain, I _might_ have
> access to that information through a call to LsaGetLogonSessionData or
> similar. If I'm not on the domain, I definitely don't.
>=20
> Npgsql is just asking Windows to do GSSAPI auth on its behalf, so it
> never really touches that info.

I seem to recall that, at one point, we actually we doing this
automatically in libpq- that is, grabbing the Kerberos princ and then
using it to auth.  That was too constrained though, as we wanted to be
able to have users with names other than their princs, but perhaps we
should have just made it optional instead, perhaps using an environment
variable.  Would that work for you and the general users?  I'm on the
fence about making that the default again since it's possible we would
break things for existing users...

    Thanks,

        Stephen

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #9337: SSPI/GSSAPI with mismatched user names
Next
From: Brian Crowell
Date:
Subject: Re: BUG #9337: SSPI/GSSAPI with mismatched user names