Re: Connection Problem - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Connection Problem
Date
Msg-id AANLkTi=33Q0OtVVT4DeiPaTdOteVjmBhNcuStrM0Xzwc@mail.gmail.com
Whole thread Raw
In response to Connection Problem  (Rob Stone <robstone@mira.net>)
List pgsql-jdbc
No worries, I'm sure you won't be the first. This will be searchable
so hopefully it will help others.

Dave

On Fri, Dec 10, 2010 at 8:15 AM, Rob Stone <robstone@mira.net> wrote:
> Hi Radoslaw,
>
> A Thomas Markus sent me a workaround. See below.
>
> ---
> maybe this is your problem
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=560056
>
> try to start your java class with -Djava.net.preferIPv4Stack=true
> ---
>
> Using the -D option running java works.
>
> Now to sort out my l0 issue!!
>
>
> Thanks to everybody for your assistance. At first glance I thought it
> was a JDBC issue and I'm sorry to have troubled you all when it is
> related to something entirely different.
>
> Regards,
> Rob
>
>
>
> On Fri, 2010-12-10 at 04:38 -0500, Radosław Smogura wrote:
>> Hi,
>>
>> I think you have badly configured routing table, I don't see there
>> loopback routing (lo device)
>> You should have line like this (lo - ended, 3rd line).
>>
>> 217.118.24.64   0.0.0.0         255.255.255.192 U     0      0        0 eth0
>> 169.254.0.0     0.0.0.0         255.255.0.0     U     0      0        0 eth0
>> 127.0.0.0       0.0.0.0         255.0.0.0       U     0      0        0 lo
>> 0.0.0.0         217.118.24.65   0.0.0.0         UG    0      0        0 eth0
>>
>> I believe that you can connect to postmaster at IP 187.65.254.157 (if
>> it's not your dynamic address). After calling
>> route add -net 127.0.0.0
>> you should connect as well.
>>
>> Check if you started all network interfaces at boot. Linux
>> distributions makes its different, you will need to call
>> /etc/init.d/*.lo or ifup lo from command line. Eventually check
>> /etc/sysconfig/network/ifcfg-lo there should be something like
>> STARTMODE=onboot
>>
>> I really wonder how you connect to http://localhost if you don't have
>> route to it. I hope this helps you.
>>
>> Kind regards,
>> Radosław smogura
>> http://softperience.eu
>> Cytowanie Rob Stone <robstone@mira.net>:
>>
>> > Hi Radek,
>> >
>> > Output from those commands attached.
>> >
>> > I always completely shutdown my laptop and pull the plug. So, it is
>> > doing a complete cold boot each time.
>> >
>> > When I try connecting to the database with ExecuteQuery, the same error
>> > is returned for both "localhost" and 127.0.0.1, when entering those
>> > values as the "host" on the connection dialogue.
>> >
>> > Via a browser, if I access http://localhost it returns the "It Work's!"
>> > output from apache.
>> >
>> > Thanks to everybody for your help.
>> >
>> > Cheers,
>> > Rob
>> >
>> >
>> >
>> > On Thu, 2010-12-09 at 15:43 -0500, Radosław Smogura wrote:
>> >> Hi,
>> >>
>> >> Check with netstat -atnp (it shows the process associated with port),
>> >> but psql should be there.
>> >>
>> >> Do route -n to see routing traces, execute ifconfig next.
>> >>
>> >> But this can be kernel driver problem. Do you "shut down" laptop by
>> >> closing it, I mean do you put it in sleep mode? Maybe you need to
>> >> restart network interfaces instead.
>> >>
>> >> On my PC when I put it on sleep mode, SATA controller doesn't wakes up.
>> >>
>> >> Kind regards,
>> >> Radek Smogura
>> >> > Rob,
>> >> >
>> >> > Have you tried 127.0.0.1 instead of localhost ? It's not that it isn't
>> >> > listening, the problem is there is no route to localhost which seems
>> >> > strange on it's own.
>> >> >
>> >> > Dave
>> >> >
>> >> > On Thu, Dec 9, 2010 at 8:18 AM, Rob Stone <robstone@mira.net> wrote:
>> >> >> Hi Oliver,
>> >> >>
>> >> >> Thanks for the reply.
>> >> >>
>> >> >> Output from netstat shows port 5432 as being listened. Don't know what
>> >> >> to try next.
>> >> >>
>> >> >> Sometimes when I shut down my laptop the "stop" messages are displayed.
>> >> >> I noticed last night that pg_ctl could not find the postmaster.pid file,
>> >> >> even though PGHOST and PGDATA variables are set. I'm starting it with
>> >> >> the -i and -D options with -D pointing explicitly to the PGDATA path
>> >> >> using the full path name. Could not finding a postmaster.pid file be
>> >> >> linked in any way with my problem??
>> >> >>
>> >> >>
>> >> >> Cheers,
>> >> >> Rob
>> >> >>
>> >> >> rob@roblaptop:~> netstat -ln --tcp
>> >> >> Active Internet connections (only servers)
>> >> >> Proto Recv-Q Send-Q Local Address           Foreign Address
>> >> >> State
>> >> >> tcp        0      0 0.0.0.0:22              0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 127.0.0.1:631           0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:5432            0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:58112           0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:2049            0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:44739           0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:6566            0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:60135           0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp        0      0 0.0.0.0:111             0.0.0.0:*
>> >> >> LISTEN
>> >> >> tcp6       0      0 :::22                   :::*
>> >> >> LISTEN
>> >> >> tcp6       0      0 ::1:631                 :::*
>> >> >> LISTEN
>> >> >> tcp6       0      0 :::5432                 :::*
>> >> >> LISTEN
>> >> >> tcp6       0      0 :::6566                 :::*
>> >> >> LISTEN
>> >> >> tcp6       0      0 :::80                   :::*
>> >> >> LISTEN
>> >> >> rob@roblaptop:~>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> On Wed, 2010-12-08 at 08:52 +1300, Oliver Jowett wrote:
>> >> >>> On 08/12/10 02:29, Rob Stone wrote:
>> >> >>>
>> >> >>> > Wrote a mickey mouse java class (testdbconn) to see if I could access
>> >> >>> > the database and read data from a table that has two rows.
>> >> See attached.
>> >> >>> > When it runs it displays the same SQL error code as ExecuteQuery --
>> >> >>> > 08001 -- which is the "can't connect error".
>> >> >>>
>> >> >>> You have a network configuration problem of some sort:
>> >> >>>
>> >> >>> > Caused by: java.net.SocketException: Network is unreachable
>> >> >>>
>> >> >>> (This isn't "connection refused", it's "I have no configured route to
>> >> >>> that address")
>> >> >>>
>> >> >>> Oliver
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> >> >> To make changes to your subscription:
>> >> >> http://www.postgresql.org/mailpref/pgsql-jdbc
>> >> >>
>> >> >
>> >> > --
>> >> > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> >> > To make changes to your subscription:
>> >> > http://www.postgresql.org/mailpref/pgsql-jdbc
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>
>

pgsql-jdbc by date:

Previous
From: Thomas Markus
Date:
Subject: Re: Connection Problem
Next
From: Fabien JALABERT
Date:
Subject: blocking