From: Jari Vauhkonen <jari.vauhkonen@joensuu.fi>
To: Ben Suffolk <ben@vanilla.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: TCP/IP connection problem
Date: Thu, 26 Oct 2006 18:52:23 +0300
Message-ID: <1161877943.4540d9b7b6215@wwwmail.joensuu.fi> (raw)
In-Reply-To: <A51A624C-E469-4462-8021-A168E1E50628@vanilla.net>
References: <1161867721.4540b1c933417@wwwmail.joensuu.fi>
<60FA14B7-0C97-47FF-90BC-5B3DA77DC5C3@vanilla.net>
<1161876175.4540d2cf3f0b0@wwwmail.joensuu.fi>
<20061026152611.GA31183@alvh.no-ip.org>
<1161876543.4540d43fe1969@wwwmail.joensuu.fi>
<A51A624C-E469-4462-8021-A168E1E50628@vanilla.net>
Quoting Ben Suffolk <ben@vanilla.net>:
> >>>> actually have done anything.
> >>>
> >>> thank you for your reply. A truly amateurish mistake by me :)
> >>>
> >>> BUT fixing that one did no good. The problem remains.
> >>
> >> Did you restart the server after changing those lines?
> >>
> >> --
> >
> > Yes.
>
> When you try and connect check /var/log/messages for any errors, and
> let us know what (if any) errors are reported.
>
1) These are the latest messages ( /var/log/messages )
Only my test of closing down & reopening postgresql.
Oct 26 18:33:25 joymap su(pam_unix)[4901]: session opened for user postgres by
root(uid=0)
Oct 26 18:33:25 joymap su(pam_unix)[4901]: session closed for user postgres
Oct 26 18:33:33 joymap postgresql: postmaster shutdown succeeded
Oct 26 18:33:35 joymap su(pam_unix)[4951]: session opened for user postgres by
root(uid=0)
Oct 26 18:33:35 joymap su(pam_unix)[4951]: session closed for user postgres
2) Enrico's firewall propotion:
There is a firewall in WinXP ( F-Secure ). I allready tried disabling it. I have
also configured the Red Hat security level. Right now it allows all traffic
thru eth0.
3) I managed to get a connection-lookalike:
netstat print:
tcp 0 0 <my_psql_server_domain>:postgres <my_client_domain>:2429 TIME_WAIT
What next?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jari.vauhkonen@joensuu.fi, ben@vanilla.net
Subject: Re: TCP/IP connection problem
In-Reply-To: <1161877943.4540d9b7b6215@wwwmail.joensuu.fi>
References: <1161867721.4540b1c933417@wwwmail.joensuu.fi> <60FA14B7-0C97-47FF-90BC-5B3DA77DC5C3@vanilla.net> <1161876175.4540d2cf3f0b0@wwwmail.joensuu.fi> <20061026152611.GA31183@alvh.no-ip.org> <1161876543.4540d43fe1969@wwwmail.joensuu.fi> <A51A624C-E469-4462-8021-A168E1E50628@vanilla.net> <1161877943.4540d9b7b6215@wwwmail.joensuu.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox