It might be more trouble than it's worth but you might could use CygWin to maintain the tunnel. Since cygwin runs as a service, the tunnel could be init'd as part of the cygwin process. I know Cygwin has an sshd module that might help. Just a thought. mf
mark fennell athens regional medical center athens, ga ----- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. ----- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Staver Sent: Wednesday, October 13, 2010 3:44 PM Cc: [email protected] Subject: Re: [ACFUG Discuss] ColdFusion Datasource to MySQL over SSH tunnel on windows I think I found a little tutorial that I just used to set this up: http://realprogrammers.com/how_to/set_up_an_ssh_tunnel_with_putty.html I'm a little bummed I can't just have this fire up with windows automagically, but this will do for now. Thanks again Frank and Steve. On 10/13/2010 12:24 PM, Frank Moorman wrote: > Assuming that you have the ssh daemon running already on your > MySql/Linux box... > > Download and install PuTTY. http://www.putty.org/ > > You can then create a tunnel in Putty and tell it which ports to > forward. (in this case, 3306) > > It is fairly easy, I can help some more if you have questions about it. > Personally I use a linux client to connect to cygwin SSH on a windows > server, but I have instructed the non-techie owner of the website how > to use Putty to connect from his own windows PC. > > Once Putty is installed and is running you can connect with the normal > MySql Query Browser/Admin tools. You just replace the server IP with > 127.0.0.1 in order to utilize the forwarding provided by Putty. > > --Frank > > On 10/13/2010 12:56 PM, Mike Staver wrote: >> I'm trying to set up a remote dev instance for one of my >> applications, and what I would like to do is have it connect to my >> mysql instance on a linux box I run. I don't plan on opening up port >> 3306 to the outside world for obvious reasons, and I shouldn't need >> to if I'm correct in my thinking here. Currently, I use Navicat to >> connect to the DB over an SSH tunnel and it works great. I'm not >> entirely sure how Navicat does this behind the scenes, and I'd love >> to know how to duplicate this on both windows and Mac OS Has anyone >> done this before? On the Mac or Linux side, I would imagine you'd >> just set up some kind of port forwarding that would do this for you. >> I'm very unsure of how that would work on windows. >> >> >> ------------------------------------------------------------- >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists Archive @ >> http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> ------------------------------------------------------------- >> >> >> >> ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
