Re: ssh tunnel problem - Mailing list pgsql-general

From Doug McNaught
Subject Re: ssh tunnel problem
Date
Msg-id m33cpxl0zh.fsf@varsoon.wireboard.com
Whole thread Raw
In response to ssh tunnel problem  ("Craig H. Anderson" <craig@coot.net>)
List pgsql-general
"Craig H. Anderson" <craig@coot.net> writes:

> I am trying to use psql over an ssh tunnel for the first time.
>
> I am able to login to the remote system with
> $ ssh 216.38.48.94
>
> I can use psql logged into the remote system
> as the username.
>
> Here is a log:
>
> $ ssh -N -f -L 5430:216.38.48.94:5432 username@216.38.48.94 $ psql
> --host localhost --port 5430 --username username --dbname template1
> channel 1: open failed: connect failed: Connection timed out psql:
> could not receive server response to SSL negotiation packet: Success
> Can anyone explain what is the problem?
> I did not expect that ssl would be used over the SSH port forward.

That does seem odd.  Check your pg-hba.conf entries on the server.
Remember that the connection on the server side will appear to be
coming from 127.0.0.1 (I *think* that's how SSH port forwarding
works)...

-Doug

pgsql-general by date:

Previous
From: "Craig H. Anderson"
Date:
Subject: ssh tunnel problem
Next
From: Andreas Tille
Date:
Subject: Handling images using Python