Does DB Solo support configuring an ssh tunnel to DB server

146 views
Skip to first unread message

moraj...@gmail.com

unread,
Jul 28, 2016, 1:51:03 PM7/28/16
to DB Solo
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

unread,
Jul 29, 2016, 3:45:56 PM7/29/16
to DB Solo, moraj...@gmail.com
What DBMS product are you using?

marko

moraj...@gmail.com

unread,
Jul 29, 2016, 5:15:55 PM7/29/16
to DB Solo, moraj...@gmail.com
MySQL 5.5.50

DB Solo Admin

unread,
Jul 30, 2016, 7:17:24 AM7/30/16
to DB Solo, moraj...@gmail.com
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

unread,
Aug 11, 2016, 9:21:48 PM8/11/16
to DB Solo, moraj...@gmail.com
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

unread,
Aug 11, 2016, 9:25:33 PM8/11/16
to DB Solo, moraj...@gmail.com
On Windows you can use Putty or other similar tool to achieve the same.

thanks
marko

ramgil...@gmail.com

unread,
Jan 18, 2018, 6:46:27 PM1/18/18
to DB Solo

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

unread,
Jan 18, 2018, 8:42:51 PM1/18/18
to DB Solo
You need to specify the remote host in your ssh command.

marko

Chrise

unread,
Sep 12, 2019, 1:49:54 PM9/12/19
to DB Solo

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

Chrise

unread,
Sep 22, 2019, 8:44:30 AM9/22/19
to DB Solo

I should add, other tools that are FREE have ssh tunnel built in. 
Reply all
Reply to author
Forward
0 new messages