Re: Fwd: localhost not equal at 127.0.0.1 - Mailing list pgsql-jdbc

Given this information it would appear to be a bug in the java network
classes on this platform.  All the jdbc code is doing is opening a
socket connection to localhost via ( connection = new Socket(host,
port); ).  So for some reason the Java Socket class is thinking
localhost maps to the wrong IP address.

thanks,
--Barry



Stéphane Chomat wrote:

> I work with  Mac Os X (10.1) and postgresql 7.1.3
> Excuse me but no :
> steph# ping localhost
> PING localhost (127.0.0.1): 56 data bytes
> 64 bytes from 127.0.0.1: icmp_seq=0 ttl=255 time=1.863 ms
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=255 time=0.369 ms
> 64 bytes from 127.0.0.1: icmp_seq=2 ttl=255 time=0.458 ms
> 64 bytes from 127.0.0.1: icmp_seq=3 ttl=255 time=0.582 ms
> 64 bytes from 127.0.0.1: icmp_seq=4 ttl=255 time=0.423 ms
> 64 bytes from 127.0.0.1: icmp_seq=5 ttl=255 time=0.364 ms
> 64 bytes from 127.0.0.1: icmp_seq=6 ttl=255 time=0.368 ms
> 64 bytes from 127.0.0.1: icmp_seq=7 ttl=255 time=0.432 ms
> 64 bytes from 127.0.0.1: icmp_seq=8 ttl=255 time=0.371 ms
> 64 bytes from 127.0.0.1: icmp_seq=9 ttl=255 time=0.423 ms
>
>
> --- localhost ping statistics ---
> 10 packets transmitted, 10 packets received, 0% packet loss
> round-trip min/avg/max = 0.364/0.565/1.863 ms
>
> and more, i can obtain my loca page with two different brosser,
> (http://localhost/).
> tanks
> --steph
>
> Début du message réexpédié :
>
>> De : Barry Lind <barry@xythos.com>
>> Date : Mer 31 oct 2001  11:15:13  Europe/Paris
>> À : Stéphane Chomat <steph_chomat@mac.com>
>> Cc : pgsql-jdbc@postgresql.org
>> Objet : Rép : localhost not equal at 127.0.0.1
>>
>> I think there is a setup problem with your client.  For some reason
>> 'localhost' is being resolved to an IP address different than
>> 127.0.0.1.  That is a configuration problem on the computer, not a
>> problem with the jdbc driver.  If you 'ping localhost' what do you get
>> as the reported IP address?
>>
>> The code change you suggest below is not appropriate, because it is
>> reasonable to expect that other users may desire that localhost
>> resolves to an IP address other than 127.0.0.1.  So hardcoding this
>> mapping inside the driver is not correct.
>>
>> thanks,
>> --Barry
>>
>> Stéphane Chomat wrote:
>>
>>> I test the  example corba and i am an exception : "Quelque chose de
>>> peu commun sest produit pour faire ??chouer le gestionnaire. Veuillez
>>> enregistrer cette exception: {0}...". It 's a correct message.
>>> The connection is refused by the server : 'No pg_hba.conf entry for
>>> host 217.128.128.146, user user, database dbase' The ip address is
>>> not permit to connect on the server.
>>> But there are a bug : i am not given this ip adresse of my machine. I
>>> want to connect an localhost with 127.0.0.1. When i give this
>>> address, it 's ok.
>>>  When i give  no ip address (ex : jdbc:postgresql:dbase ) or i give
>>> localhost (ex : jdbc:postgresql://localhost/dbase), it take the ip
>>> address of the machine)
>>> I think that this is a bug. I propose to add this ligne at the end of
>>> the method parseURL of the file Driver.java.
>>>     String p_PGHOST = urlProps.getProperty("PGHOST");
>>>     if (( p_PGHOST == null) || ( p_PGHOST.equals("localhost"))) {
>>>              urlProps.put("PGHOST", "127.0.0.1");
>>>     }
>>> Stephane Chomat
>>> 22 rue Le Brix
>>> 38100 Grenoble
>>> 603-999-478
>>> steph_chomat@mac.com
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>>
> Stéphane Chomat
> 22 rue Le Brix
> 38100 Grenoble
> 603-999-478
> steph_chomat@mac.com
>