Re: Connecting via ssh tunnel

Ok I have fixed it.

My port fowarding was fine but i needed to set AllowTcpForwarding to
yes in sshd_config.

Ben

On 11/27/06, Weerts, Jan <j.weerts@i-views.de> wrote:
> Hi all!
>
> pgsql-general-owner@postgresql.org wrote:
> > On Friday 24 November 2006 12:56, ben short wrote:
> >> I have a postgresql server setup on a Solaris 10 box. I can
> >> connect to the db via psql from the local machine. What I have
> >> been trying to do it connect with pgAdmin from my workstation. I
> >> have setup the tunnel correctly, local port 5432 and destination
> >> localhost:5432. Everytime I try to connect I get the following
> >> message.
> >
> > I guess the tunnel isn't correct. You connect on the same ports -
> > seems wrong to me. I'm using a tunnel like this:
> >
> > ssh -l <user> -L 5555:localhost:5432 <servername>
>
> actually
>   ssh -l USER -L 5432:localhost:5432 SOMEOTHERHOSTTHANLOCALHOST
>
> is ok. the "localhost" part is evaluated on the SOMEOTHERHOST
> and dns lookup is done there. I have been bitten by this before.
> If SOMEOTHERHOST is the same host, this would obviously not
> work, since the ssh tunnel and the postgres server cannot
> listen on the same port.
>
> I am not sure if the error message you are seeing is the same
> one you would get when a connection is impossible. To me it
> looks like a connection was initiated by the server closed
> it.
>
> Regards
>   Jan
>