Re: krb5 authentication and multihomed server hosts - Mailing list pgsql-bugs

From Tom Lane
Subject Re: krb5 authentication and multihomed server hosts
Date
Msg-id 27228.1122385333@sss.pgh.pa.us
Whole thread Raw
In response to krb5 authentication and multihomed server hosts  (pod@herald.ox.ac.uk (pod))
Responses Re: krb5 authentication and multihomed server hosts  (pod@herald.ox.ac.uk (pod))
List pgsql-bugs
pod@herald.ox.ac.uk (pod) writes:
> PostgreSQL-Version: 7.4.7

> It is not always possible to use krb5 authentication to a server that is
> listening on multiple interfaces other than to the 'primary' interface.

> More specifically: src/backend/libpq/auth.c pg_krb5_init() fills in the
> pg_krb5_server principal with a call to krb5_sname_to_principal with NULL
> as the second argument (the hostname argument).

I see this has been changed in CVS tip, but I don't know enough about
Kerberos to know whether the change addresses your operational problem.

> I append a patch that 'fixes' behaviour for the limited case where a
> virtual_host is specified in /etc/postgresql/postgresql.conf.

VirtualHost is long gone, so this patch is of little help anyway.  Could
you take a look at CVS or a recent nightly snapshot (look under dev/ on
the FTP servers) and see if your problem is fixed or not?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Lumir Vanek"
Date:
Subject: BUG #1787: Timestamp issue for moment when clock moved to DST
Next
From: Tom Lane
Date:
Subject: Re: BUG #1787: Timestamp issue for moment when clock moved to DST