Skip site navigation (1) Skip section navigation (2)

Re: BUG #5559: Full SSL verification fails when hostaddr provided

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Christopher Head <chris2k01(at)hotmail(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided
Date: 2010-07-14 22:16:30
Message-ID: 19143.1279145790@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> Perhaps I was being a bit overzealous in my last response, sorry about
> that.  If the point here is that people who are using hostaddr are in an
> environment where DNS is non-functional or actively broken, then yes,
> just bombing out would probably be fine.

Well, if your environment includes broken DNS then you are clearly going
to get nowhere anyway with Kerberos auth, no?  The point of hostaddr is
*not* to try to avoid that problem.  Rather, it's to allow the
application to shift the time expense of the forward DNS lookup to some
other place than its PQconnect() call.  If you've got an app where the
cost of PQconnect() is that critical, you're likely going to want to
avoid Kerberos auth anyway, so I don't think it's all that important
exactly how the two features play together.

As the code stands in HEAD, I think everything is nicely
self-consistent: host is what we believe the server name is for
authentication purposes, and hostaddr is an optional pre-looked-up
address corresponding to that.  There is nothing in this suggesting
that we should be expected to try to generate an authentication name
from hostaddr alone.  In particular, the fact that Kerberos is capable
of trying to do that is at odds with the other three code paths where
the server name is needed for authentication.  I don't feel any need
to expose Kerberos' peculiarity here.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Stephen FrostDate: 2010-07-14 22:28:00
Subject: Re: BUG #5559: Full SSL verification fails when hostaddrprovided
Previous:From: Tom LaneDate: 2010-07-14 21:58:04
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group