Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: Tunneling DBD::mysql connections over SSH without using external programs

by wwinfrey (Acolyte)
on Apr 12, 2013 at 15:15 UTC ( [id://1028394]=note: print w/replies, xml ) Need Help??


in reply to Re: Tunneling DBD::mysql connections over SSH without using external programs
in thread Tunneling DBD::mysql connections over SSH without using external programs

Net::OpenSSH looks like a prime candidate. In my original post, I wrote:
I've also looked for similar questions about tunneling in general, and have looked at say, the Tunnels section of the Net::OpenSSH perldoc, but can't wrap my head around how I would create a driver handle that connects over the pipes created by Net::OpenSSH's open_ex method...
So really, I suppose my entire post could have been distilled down to "How do you make DBI connect with DBD::mysql over Net::OpenSSH tunnels?" but I did not want to necessarily dis-avail myself of other possible solutions. I shouldn't have been so quick to dismiss the VPN solution out-of-hand, especially seeing that is, as Salva alluded to above, what Net::OpenSSH's perldoc "Tunnels" section is referring to.
However, these are just wrappers over the sytem-installed ssh and not pure Perl solutions, so if they 'hide the underlying system' enough or not for you remains your decision.
In the absence of any other viable solution, I suppose I may have to settle for something in this approach. The reason I'm hesitant to use wrappers for system binaries is because I'd like to wrap this up in an easily-distributed module to my local team of co-devs, and did I mention the target OS will eventually be Windows?

Replies are listed 'Best First'.
Re^3: Tunneling DBD::mysql connections over SSH without using external programs
by wwinfrey (Acolyte) on Apr 12, 2013 at 16:48 UTC

    Looks like Net::OpenSSH isn't supported on Windows, so that's out. Probably should have checked that requirement beforehand. Tunneling and VPNs likely would not have worked here either because, Windows.

    I suppose I'll have to find another path.

      In my experience, the MinGW ssh client (as distributed with "Git for Windows") and the plink.exe as distributed with PuTTy work very well with port forwarding.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1028394]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (3)
As of 2024-03-28 17:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found