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 (http://www.harding.motd.ca/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
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