Re: [CODE4LIB] ssh tunneling through a mysql dsn

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. http://www.webyog.com/en/index.php > Not sure if thi

Re: [CODE4LIB] ssh tunneling through a mysql dsn

On Wed, 25 Jun 2008, Eric Lease Morgan wrote: On Jun 25, 2008, at 11:21 AM, Nate Vack wrote: $ ssh -T -L 3306:mysql.example.org:3306 [EMAIL PROTECTED] & $ mysql -h mysql.example.org Yeah -- this is (probably) the way you want to do it, though. You'll need to: * Set up SSH keys such that b

Re: [CODE4LIB] ssh tunneling through a mysql dsn

Have you tried changing the source port to e.g. 3307 so you avoid the conflict with your localhost MySQL port? Genny Engel Internet Librarian Sonoma County Library [EMAIL PROTECTED] 707 545-0831 x581 www.sonomalibrary.org >>> [EMAIL PROTECTED] 06/25/08 05:59AM >>> Is there anyway to sup

Re: [CODE4LIB] ssh tunneling through a mysql dsn

[EMAIL PROTECTED] On Behalf Of Steve Oberg Sent: Wednesday, June 25, 2008 10:05 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] ssh tunneling through a mysql dsn Not sure if I'm understanding Eric's original scenario correctly but...This setup of needing to support SSH tunneling thro

Re: [CODE4LIB] ssh tunneling through a mysql dsn

Not sure if I'm understanding Eric's original scenario correctly but...This setup of needing to support SSH tunneling through to an Oracle database is exactly what we have setup in my library using SecureCRT ( http://www.vandyke.com/products/securecrt/). I think this software is quite useful and s

Re: [CODE4LIB] ssh tunneling through a mysql dsn

On Jun 25, 2008, at 8:59 AM, Eric Lease Morgan wrote: Is there anyway to support SSH tunneling through a MySQL DSN? 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:

Re: [CODE4LIB] ssh tunneling through a mysql dsn

f Nate Vack Sent: Wednesday, June 25, 2008 8:21 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] ssh tunneling through a mysql dsn On Wed, Jun 25, 2008 at 7:59 AM, Eric Lease Morgan <[EMAIL PROTECTED]> wrote: > Is there anyway to support SSH tunneling through a MySQL DSN? > >

Re: [CODE4LIB] ssh tunneling through a mysql dsn

On Jun 25, 2008, at 11:21 AM, Nate Vack wrote: $ ssh -T -L 3306:mysql.example.org:3306 [EMAIL PROTECTED] & $ mysql -h mysql.example.org Yeah -- this is (probably) the way you want to do it, though. You'll need to: * Set up SSH keys such that building the tunnel doesn't prompt for a passw

Re: [CODE4LIB] ssh tunneling through a mysql dsn

On Wed, Jun 25, 2008 at 7:59 AM, Eric Lease Morgan <[EMAIL PROTECTED]> wrote: > Is there anyway to support SSH tunneling through a MySQL DSN? > > I would like to open a database connection to remote host through Perl's > DBI. The remote database is MySQL, but the server hosting the database does >

[CODE4LIB] ssh tunneling through a mysql dsn

Is there anyway to support SSH tunneling through a MySQL DSN? I would like to open a database connection to remote host through Perl's DBI. The remote database is MySQL, but the server hosting the database does not allow outside connections. Instead the systems administrators suggest first