Skip to content
This repository has been archived by the owner on Nov 5, 2019. It is now read-only.

Can't connect to remote PostgreSQL database over SSL with self-signed certificate #456

Open
mstgelais opened this issue Nov 29, 2018 · 1 comment

Comments

@mstgelais
Copy link

mstgelais commented Nov 29, 2018

OS: Ubuntu Budgie x64 4.15.0-39-generic
VERSION: 4.0.392

Database Type: PostgreSQL 10.6

With this latest version (and possibly a bit before, but it was working a couple of months ago), I can no longer connect over SSL to a remote PostgreSQL database using a self-signed certificate.

From PostgreSQL's logs:
2018-11-28 21:51:47.378 EST [19656] [unknown]@[unknown] LOG: could not accept SSL connection: sslv3 alert certificate unknown

This seems to explain this issue:
https://stackoverflow.com/questions/43689461/postgresql-could-not-accept-ssl-connection-sslv3-alert-certificate-unknown

Here's what I get when hit the "Test Connection" button in TeamSQL:

screenshot from 2018-11-28 21-58-01

Thanks a lot for your help!

@mstgelais
Copy link
Author

I just made some tests, and this is working well when using TeamSQL version 3.4.230.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant