Hi Folks,
Does anyone on the list have experience connecting to a remote database
through an SSH tunnel? Here's the problem I've been handed:
Write a series of CGI scripts for use on a publicly hosted website which
are capable of retrieving data from an MS SQL server running on a private,
internal LAN.
I feel that an SSH tunnel is the idea answer since it provides host
authentication (the request comes from client's web host), user
authentication (it's one of my scripts) and data encryption (protects the
database access parameters).
Here's what I have in mind. They can run Vandyke's VShell behind their
corporate firewall. VShell can be configured to provide ODBC connectivity
to any system DSN on the internal LAN. I can create an SSH connection using
Net::SSH::Perl but this is as far as I get. How do I bring DBI's methods
together with the the tunnel? Can I pass the socket connection to DBD::ODBC
as part of the datasource parameter?
Any input or alternative suggestions are greatly appreciated.
>> Ken Clarke
>> Contract Web Programmer / E-commerce Technologist
>> http://PerlProgrammer.net
