Does DB Solo support configuring an ssh tunnel to DB server

[moraj...@gmail.com]

Hi,

 When I try to add a new connection to a production DB server, I received the following error:

Error connecting to the database.Communcations link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Doing some investigation, I found out that I cannot connect directly to the production DB server using 3306.

In order to connect to the database requires configuring an SSH tunnel to the database server.

Does DB Solo support configuring an SSH tunnel to DB server?

Thanks.

[DB Solo Admin]

What DBMS product are you using?

marko

[moraj...@gmail.com]

MySQL 5.5.50

[DB Solo Admin]

You need to do something like this on the command line

ssh -C -N user...@myhost.com -L 3307:127.0.0.1:3306


Then configure DB Solo to connect to host 127.0.0.1 using port 3307.

The 3306 in the command above is the MySQL port on the remote host, so you need to use the actual
port instead.


Marko

[vlad]

Yes, of course somebody could do this ;-)... just not forget not all have Linux (or MacOS )

The Tools is good, but ssh tunnel it is function - "must have" for any high level product

best regards, Vlad

суббота, 30 июля 2016 г., 23:17:24 UTC+12 пользователь DB Solo Admin написал:

[DB Solo Admin]

On Windows you can use Putty or other similar tool to achieve the same.

thanks
marko

[ramgil...@gmail.com]

I'm facing the same issue. With Mysql and JDBC

I have a tunnel setup like this.

ssh -L 7006:127.0.0.1:3306 <IP>

In my db solo :

Host : 127.0.0.1

Port : 7006

My db username and password.

[DB Solo Admin]

You need to specify the remote host in your ssh command.

marko

[Chrise]

yeah, other tools have ssh tunnel built in.  Not so dbsolo - I won't be renewing

[Chrise]

I should add, other tools that are FREE have ssh tunnel built in.