Hello Everyone,
I am having a problem with setting up port forwarding from one of our local CentOS machines to an AWS EC2 instance. We are wanting to make mysql connections over an ssh tunnel.
In this case, lets say that hostA is our local machine, and hostB is the Amazon EC2 instance. I have tried several different variations (that I have found from google searching), including: from hostA: ssh -L 22222:hostB:3306 user@hostB from hostA: ssh -L 22222:localhost:3306 user@hostB from hostA: ssh -L 22222:hostB:3306 user@localhost
No matter which variation I have tried, in every case, it will actually create an ssh connection to the hostB, and log me into hostB, giving me its prompt. If I try the port (22222) for the localhost (hostA) in another terminal window, it doesn't allow the connection. netstat also doesn't show port 22222 to be opened on the local machine (hostA).
I have turned on AllowTcpForwarding on both the remote machine and the local machine.
I have also made sure that port 22222 is opened on both machine firewalls (including the EC2 security group).
What am I doing incorrectly or missing? -- Doug
Registered Linux User #285548 (http://counter.li.org) ---------------------------------------- Never trust a computer you can't throw out a window. -- Steve Wozniak
________________________________ From: Ski Dawg centos@skidawg.org To: CentOS mailing list centos@centos.org Sent: Thursday, July 12, 2012 10:20 AM Subject: [CentOS] ssh port forwarding
We are wanting to make mysql connections over an ssh tunnel.
In this case, lets say that hostA is our local machine, and hostB is the Amazon EC2 instance. I have tried several different variations (that I have found from google searching), including: from hostA: ssh -L 22222:hostB:3306 user@hostB from hostA: ssh -L 22222:localhost:3306 user@hostB from hostA: ssh -L 22222:hostB:3306 user@localhost
-- Doug
==
Doug: Depending on how the mysql is bound on hostB, either variation 1 or 2 should work. Variation 3 doesn't look very useful, since it implies hostA can already access tcp/3306 on hostB. After you build the port forwards, and open another terminal on HostA, and do:
$ telnet localhost 22222
What does it do?
Also, just to verify, if you're on hostB and do:
$ telnet localhost 3306
Does it 'connect' to a tcp port?