New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Java SSL error with postgresql #381

Closed
SkipMike opened this Issue Sep 5, 2018 · 10 comments

Comments

@SkipMike

SkipMike commented Sep 5, 2018

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.

@murteza

This comment has been minimized.

murteza commented Sep 6, 2018

Hi @SkipMike ,

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

@cbailly42

This comment has been minimized.

cbailly42 commented Sep 6, 2018

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

This comment has been minimized.

SkipMike commented Sep 13, 2018

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

@barisozanguler

This comment has been minimized.

barisozanguler commented Sep 14, 2018

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.

@murteza murteza added this to Near Term in TeamSQL Sep 17, 2018

@murteza murteza moved this from Near Term to Currently Working On in TeamSQL Sep 17, 2018

@murteza murteza moved this from Currently Working On to Completed in TeamSQL Sep 26, 2018

@murteza

This comment has been minimized.

murteza commented Sep 26, 2018

Hi @SkipMike @cbailly42 ,

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

@lastgleam

This comment has been minimized.

lastgleam commented Sep 27, 2018

Hi @murteza

image
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

This comment has been minimized.

cbailly42 commented Sep 27, 2018

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

image

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

@murteza

This comment has been minimized.

murteza commented Sep 27, 2018

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

This comment has been minimized.

urossmolnik commented Oct 3, 2018

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

@getsalmon

This comment has been minimized.

getsalmon commented Oct 15, 2018

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

in pgAdmin I use SSL Mode=Prefer

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment