On Wed, 2008-06-25 at 12:56 -0400, Birkin James Diana wrote:
> On Jun 25, 2008, at 8:59 AM, Eric Lease Morgan wrote:
> > Is there anyway to support SSH tunneling through a MySQL DSN?

I haven't used these, but see if they do what you need.

> Not sure if this is exactly relevant, but I used to need to access a  
> remote mysql database not open to internet access, and came to love  
> ssh tunneling. Some notes:
> <>
> Also, for a different reason, I needed to handle passwordless logins.  
> This might be of some use:
> <>

These are great howtos Birkin - the usefulness and reliability of SSH
far outweighs the pain in getting it setup.  I use it for many things
now, you can see my shortened passwordless login method here:

and a general tunneling howto here:

I use port forwarding to allow SSH from a box inside a firewall to go
out via an open port (I use the AIM port of 5190 often), connect to my
remote box, and then use Autossh ( -
to  monitor the ssh tunnels, and restart them if they go down.  That's
it, I now have all the abilities from the remote box that I do when I'm
inside the firewall.  Then just lock down sshd and change those
passwords regularly.  

SSH tunneling maintained by Autossh, beauty.


> ---
> Birkin James Diana
> Programmer, Integrated Technology Services
> Brown University Library
> [log in to unmask]
Open Source Development 
Missouri Botanical Garden  |  Lat: 38.6112700  |  Lon: -90.2583440 
Email: phildotcryeratmobotdotorg | IM GoogleTalk/Skype: phil.cryer