Re: krb5 authentication and multihomed server hosts

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