On May 13, 2006, at 6:18 PM, Tom Lane wrote:
> Jerry LeVan <jerry.levan@eku.edu> writes:
>> How ever if I turn it around, and on the mac issue
>> the command
>> ssh -L 6666:linuxbox:5432 -l jerry linuxbox
>> Then I am not able to connect to the linux box
>> via psql or any Gui front ends.
>
> [ tries it ... ] Worksforme, using the stock ssh in OS X 10.4.6.
>
> Maybe you've got the OS X firewall configured to prevent
> connections to
> port 6666? That doesn't seem to be default, because I didn't have to
> adjust the firewall for my experiment.
>
> Another possibility is that the ssh daemon on the linux box is
> restricted from opening local connections. It wouldn't surprise
> me if this is disabled by default by SELinux for instance :-(
>
> regards, tom lane
I am still puzzled. I don't think it is a postgresql problem since I
can't forward to other daemons running on the linux box.
I have noticed a error in the message file on the linux box that
is generated when ever I try to connect from the mac.
**********
debug1: Connection to port 2224 forwarding to linuxbox port 2224
requested.
debug2: fd 9 setting TCP_NODELAY
debug2: fd 9 is O_NONBLOCK
debug2: fd 9 is O_NONBLOCK
debug1: channel 3: new [direct-tcpip]
channel 3: open failed: administratively prohibited: open failed
debug1: channel 3: free: direct-tcpip: listening port 2224 for
linuxbox port 2224, connect from ::1 port 50663, nchannels 4
debug3: channel 3: status: The following connections are open:
#2 client-session (t4 r0 i0/0 o0/0 fd 6/7)
#3 direct-tcpip: listening port 2224 for linuxbox port 2224,
connect from ::1 port 50663 (t3 r-1 i0/0 o0/0 fd 9/9)
debug3: channel 3: close_fds r 9 w 9 e -1
May 13 19:22:05 localhost sshd[5844]: error: connect_to linuxbox:
unknown host (Name or service not known)
***********
It appears that I have to somehow tell the linux box about the Mac....
This does not appear to be necessary when talking to the mac from the
linux box.
Sigh,
Jerry