MySQLdb + SSH Tunnel

[Riley Crane]

Got it working.  Thanks for your help!

1) login to B
2) setup a tunnel in the shell   machine-B> ssh -L
B_ip_address:B_port:C_ip_address:C_port user at C_ip_address

   for example:
     machine-B has ip 1.1.1.1
     machine-C has ip 2.2.2.2

   then I would type:
   machine-B> ssh -L 1.1.1.1:3307:2.2.2.2:3306 user at 2.2.2.2

   now the code that is running on machine-A would use MySQLdb in the
following way

   import MySQLdb
   connection = MySQLdb.connect
(user='myname',passwd='mypass',db='mydb',host='1.1.1.1',port=3307)

   NOTE: the port is an integer, NOT a string


On Jul 12, 9:18 pm, Riley Crane <vodkal... at gmail.com> wrote:
> OVERVIEW:
> I am running a script on one machine that connects to a MySQL database
> on another machine that is outside of our university's domain.
> According to the administrator, network policies do not allow the
> compute nodes to access machines outside of our university's domain.
>
> COMPUTERS:
> A = compute node within university (I do not have shell access)
> B = 2nd machine within university that does not block outside
> connections (I have root access)
> C = machine outside of university (I have root access)
> mysqldb on A cannot connect to C ....but.....
> mysqldb on A can connect to B
>
> WHAT I WOULD LIKE TO DO:
> Is it possible to set something up where A talks to a port on B, and
> that port is actually nothing more than 3306 on C?  Can I do this with
> an SSH tunnel?
>
> Can anyone please give precise instructions?