Re: ident auth postgres 7.4 fedora core 3 - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: ident auth postgres 7.4 fedora core 3
Date
Msg-id 2491.1110213167@sss.pgh.pa.us
Whole thread Raw
In response to Re: ident auth postgres 7.4 fedora core 3  (Ian Pilcher <i.pilcher@comcast.net>)
Responses Re: ident auth postgres 7.4 fedora core 3  (Ian Pilcher <i.pilcher@comcast.net>)
List pgsql-jdbc
Ian Pilcher <i.pilcher@comcast.net> writes:
> Since 1.4.2 (I believe), Java uses IPv6 by default.  When a connection
> is made to an IPv4 address, it actually makes an IPv6 connection to an
> "IPv4-mapped address".  So when you request a connection to 127.0.0.1,
> you actually get a connection to ::ffff:127.0.0.1.  PostgreSQL doesn't
> know this, however; it asks the ident daemon, "who's connecting from
> 127.0.0.1?"  The daemon answers "nobody".

Hmm.  I think you have mischaracterized the situation, because the
IDENT protocol doesn't actually mention IP addresses at all --- just
port numbers.  It's up to Postgres to connect back to the same IP
address that the connection came from, and AFAIK we do that correctly
for IPv6 addresses.

This report could indicate a bug in our handling of the case, or it
could indicate a configuration error on the part of the OP, or it could
be that his ident daemon isn't handling the case correctly.  There's
not enough info to tell.  It would be useful to see the postmaster log
output when the connection is rejected.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Sergio Lob
Date:
Subject: Re: [BUGS] BUG #1523: precision column value returned from getTypeInfo()
Next
From: Tom Lane
Date:
Subject: Re: ident auth postgres 7.4 fedora core 3