Connection issue. (Ports that need to be opened?)

[jvmx]

I am connection to a corporate VPS living at Rackspace. On the VPS I am trying to connect to a MariaDB instance.

This connection is over SSH.

I am able to connect to the MariaDB using any number of Mysql utilizes. So I know the credentials are good and the there is no firewall blocking the ports.

I get the following error:

No matching clause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

We can see in the server logs that we are making the connection but it is disconnecting.

Jul 26 01:09:59 50177–dcbf8e5d-4225-4a7f-9a6a-bf3e0d393d18 sshd[20212]: Accepted password for dbadmin from 72.48.98.17 port 57057 ssh2
Jul 26 01:10:25 50177–dcbf8e5d-4225-4a7f-9a6a-bf3e0d393d18 sshd[20218]: Received disconnect from 72.48.98.17 port 57057:11: Client disconnecting normally

What Am I missing?

Could it be that I need to open an outbound port other than the ports we are connecting on?

[jornh]

I guess the deciding factor for you is ssh here.

Hope the pointers I just put in this post helps:

Can Metabase do passwordless ssh and obey ~/.ssh/config for ssh to Postgres?

Hi, Just found the answer to: Here: Enable SSH access to Postgres database Looks like most of those steps for testing got folded into the Admin Guide topic on database connectivity. Specially the section What if The Built in SSH Tunnels Don’t Fit My Needs NOTE: All above covers connecting to databases with your table sources. Using Postgres as the Metabase application database is handled differently.

Finally I also some time ago noted this unmerged PR: Fix SSH tunnel details by williamjacksn · Pull Request #6970 · metabase/metabase · GitHub (since I only recently saw the full array of possibilities mentioned in Admin Guide from above post, I am unsure if that PR would overall bettter the situation)