Wisser/Jailer

PSQLException: SSL error: Received fatal alert: handshake_failure

guettli opened this issue · 4 comments

guettli commented

Description of the Issue

I want to connect to my PG database running on localhost.

I get:

PSQLException: SSL error: Received fatal alert: handshake_failure

Connection string:

jdbc:postgresql://localhost:5432/mydb

I guess that Jailer wants to connect to an encrypted socket, but mine is not encrypted.

I use: jailer-database-tools_12.8-x64.deb

Wisser commented

If your PG server doesn't use SSL, you could try;
jdbc:postgresql://localhost:5432/mydb?sslmode=disable

  • 👍1
guettli commented

Thank you

johanleroux commented

I'm trying to connect to a server that requires an SSL connection and getting the same error as above

PSQLException: SSL error: Received fatal alert: handshake_failure

Changing the sslmode without any success, the ca.crt for the database is installed on my system and connecting via the CLI psql works as expected even with sslmode=verify-full

How would you specify a ca.crt in Jailer or even ignore the certificate completely?