There are three issues here. 1 – Forget about the SSH tunnel for now You cannot bind MySQL to more than one specific IP. The first bind-address clause is overridden (therefore, ignored) by the second one. Your server only listens to 99.99.99.99. The reason why you can connect with -h localhost but not with -h … Read more
Yes, you can. Having now gone down this path: yes, it is possible to set up an SSH tunnel from heroku to an external database. [NOTE: My particular app was written in Ruby on Rails, but the solution given here should work for any language hosted on Heroku.] Statement of the problem I am running … Read more
At work we usually create ssh tunnels forwarding ports. The way we do that is, by using the standard command ssh -L port:addr:port addr with subprocess running in a separate thread. I found this useful link: https://github.com/paramiko/paramiko/blob/master/demos/forward.py with an example of doing port forwarding with paramiko.
Using your hosts network as network for your containers via –net=host or in docker-compose via network_mode: host is one option but this has the unwanted side effect that (a) you now expose the container ports in your host system and (b) that you cannot connect to those containers anymore that are not mapped to your … Read more
Solved it! The thing was to connect to the correct server when creating the tunnel itself – should’ve seen that one coming. ssh -f [email protected] -L 3307:mysql1.example.com:3306 -N Then mysql -h 127.0.0.1 -P 3307 worked as intended. 🙂
With the PuTTY suite, you can set up a tunnel either using the PuTTY itself (GUI) or using the command-line tool plink.exe. With the plink.exe, you use the same arguments as with the OpenSSH ssh, except for the -f, which does not have an equivalent in Windows. plink.exe -N -L 2000:SomeIp:2000 myusername@myLinuxBox Reference: Using the … Read more
The Java Secure Channel (JSCH) is a very popular library, used by maven, ant and eclipse. It is open source with a BSD style license.