Linux – Ssh Tunnelling

[Ritesh]

When you are using SSH Tunneling, you create a background tunnel process which listens on a local port and forwards all the details to the actual MySQL server. SJA connects to host and port provided in host and port element.

You can assign the local port for the SSH Tunneler in the “Port” element of the XML schema.

If you specify the same local port for the SSH Tunneling as your local MySQL port, the data are sent to the MySQL server rather then the SSH process. Thus instead of connecting to you remote server it connects to your local server.

Just assign port 3310 (provided its not used by any other application) for the local port and try the connection.

[gberz3]

Thanks, Ritesh. I don't know what was going on, but none of the other ports I used seemed to work. I tried ports like 5555, and 5551, etc. . .But apparently SJA saw that these were in use and went with default 3306? Either way, 3310 worked!

[Ritesh]

This is very strange as we dont have any hardcoded port number programmed in SJA.

[gberz3]

*shrug* Maybe when you make your calls into MySQL to connect, etc. it defaults to 3306? Either way 3310 works. 😉

[Author]

Posts