Re: [Squirrel-sql-users] SQL access to MySQL over SSH tunnel

[<co...@in...>]

I haven't tried this but as far as I know it should work.
You may need to set some SSH related driver properties in
the URL.

http://dev.mysql.com/doc/connector/j/en/index.html#id2801034

Take a look in Table 2.1 under Security. The properties you
may need are useSSL and requireSSL.

In the SQuirreL 1.2 betas you can set these through the
Driver properties dialog but in 1.1 you'll need to put them
directly into the URL.

Col

> Hi all,
> 
> Is it possible to ssh tunnel a connection to a MySQL
> database using Squirrel?
> 
> On a remote machine I can do the following
> 
> > ssh -C -L 3307:the.mysql.server.node:3306 user@
> > the.mysql.server.node mysql -h localhost -P 3307 -u user
> -p database_name
> 
> - this connects fine. However, if I set up the ssh tunnel
> and try a Squirrel alias with the contact string
> 
> jdbc:mysql://localhost:3307/database_name
> 
> It tells me 
> 
> Unexpected Error occured attempting to open an SQL
> connection. Any advice very welcome... I'm using the
> 1.1final1 Squirrel on Mac OS X 10.3.4...