Postgresql Java jdbc connect via SSL tunnel to a DB running in Virtualbox using .pem file

Question

Hi I am trying to connect to a local Postgres Db running in Virtualbox Centos, which connects through SSL tunnel. Example of how I connect via DBeaver is below.

DBeaver I am using a SSL tunnel tab and
I am using a pem file, and user and password

Postgres local connection

The Virtualbox is set to forward port as follows

Postgres Virtualbox port forward

My Java code without ssl tunnel is this

DriverManager.getConnection("jdbc:postgresql://localhost:5432/dbName?user=postgresuser&password=givepassword");

This is failing saying pg_hba.conf not found etc or if I give ssl=true in connection string , says its not supported.. How do I connect to Local DB using ssl tunnel? [ My assumption in that pg_hba.conf file would be available on the Virtualbox Host Vm only.]

I dont have any other except above: this one connects :: DriverManager.getConnection("jdbc:postgresql://localhost:5432/dbName?user=postgresuser&password=givepassword"); — Nx Fi
– Nx Fi, Commented Jun 27, 2017 at 15:34
does this work - stackoverflow.com/questions/16835761/postgresql-via-ssh-tunnel — Woot4Moo
– Woot4Moo, Commented Jun 27, 2017 at 15:36
It already works, I am able to connect. The issues is not if i can connect or not. I want code example in Java how to do same. — Nx Fi
– Nx Fi, Commented Jun 28, 2017 at 15:12
@NxFi did you manage to get a working example to replicate what DBeaver was doing to establish the ssh tunnel? can you share your solution — bachr
– bachr, Commented Dec 13, 2021 at 19:55

bachr · Accepted Answer · 2021-12-14 01:08:41Z

0

You may try using jsch which is an implementation of SSH in Java.

Here is a complete example of how to do it https://cryptofreek.org/2012/06/06/howto-jdbc-over-an-ssh-tunnel/

Note that in this case all your traffic will go to the proxy hence you need to close the session after reading/writting to the database.

edited Dec 14, 2021 at 1:08

answered Dec 13, 2021 at 20:03

bachr

6,05613 gold badges67 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql Java jdbc connect via SSL tunnel to a DB running in Virtualbox using .pem file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related