Java SSL error with postgresql

TeamSQL / desktop-app

This repository is currently being used for hosting the official issue & bug tracker of TeamSQL Desktop App.

102 stars 6 forks source link

Java SSL error with postgresql #381

Closed SkipMike closed 5 years ago

SkipMike commented 6 years ago

I'm on 4.0.341 on ubuntu 18.04. When I try to connect to a production Google CloudSQL, I get screenshot-20180905-10 39 59 this error. I can connect to my local stuff just fine. I think I also got some server error from TeamSQL last night.

murtezao commented 6 years ago

Hi @SkipMike ,

Thank you for reaching out to us. Let me check with the team and get back to you

cbailly42 commented 6 years ago

I have the exact same error on MacOS 10.13.6 since i have installed the version 4.0.341 of TeamSQL. Everything was working fine previously.

I try to connect to a Heroku Postgres database.

The same database setup work with the previous version of teamSQL that i have on another Mac with the same version of MacOS (which proves that the problem comes from the latest version of teamsql).

Hope you will find a solution soon, do not hesitate if you need more informations to locate the bug 😃

SkipMike commented 6 years ago

I've updated to 4.0.357 with the same error still happening.

barisozanguler commented 6 years ago

Hi @SkipMike @cbailly42

We are still investigating this bug. It's looks like happen in some service providers which cause of root certificates and JDBC's keystore as we think. We will keep you updated for progress.

Thanks.

murtezao commented 5 years ago

Hi @SkipMike @cbailly42 ,

We released a new version yesterday. Can you update and try again, please?

lastgleam commented 5 years ago

Hi @murteza

I still get the same error on version 4.0.376. (desktop OS is macOS 10.14 Mojave) I tried to connect to Google CloudSQL too. with pgAdmin4, It has been connected with no errors.

I wish I could connect to Google CloudSQL via TeamSQL.

cbailly42 commented 5 years ago

Hi @murteza, Sadly it still doesn't work on v4.0.376 on MacOS 10.13.6 to connect to a Heroku Postgres Database ...

I hope you will find and resolve the bug so that i can use TeamSQL again ! 😄

murtezao commented 5 years ago

Hi @lastgleam

You can connect Google Cloud PG via SSL after converting your private key file to .pk8 format with command as below ;

openssl pkcs8 -topk8 -inform PEM -outform DER -in client-key.pem -out client-key.pk8 -nocrypt

urossmolnik commented 5 years ago

I am still getting this error with new build: Version 4.0.379 (4.0.379.379)

getsalmon commented 5 years ago

getting this error on win10, v4.0.379 when try to connect to PG server

in pgAdmin I use SSL Mode=Prefer

george commented 5 years ago

I got it working by enabling SSL in the connection config. Then, in the SSL options section that becomes visible, select Yes for Reject Unauthorized. HTH