Skip to content
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

🐞 Error when connect to CockroachDB #786

Open
yanecc opened this issue Apr 6, 2024 · 5 comments
Open

🐞 Error when connect to CockroachDB #786

yanecc opened this issue Apr 6, 2024 · 5 comments
Assignees
Labels
bug 🪲 Something isn't working PostgreSQL 🐘

Comments

@yanecc
Copy link

yanecc commented Apr 6, 2024

Describe the bug
When try to connect to the CockroachDB database, I received an error message: Error: server requires encryption.

Expected behavior
Set PostgreSQL as the database type and enable SSL, the CockroachDB connection should be valid.

Application:

  • App version 0.7.22
  • OS name: Windows 11
  • DB name CockroachDB
@Fabio286
Copy link
Member

Did you provided proper key, cert and other stuffs?

@yanecc
Copy link
Author

yanecc commented Jun 20, 2024

I just selected the database type as PostgreSQL and then entered the connection string provided by CockroachDB (like postgresql://user:passwd@host:port/dbname?sslmode=verify-full). When I enabled the SSL setting, imported the CA Cert and tested the connection, it was turned off and I got a pop-up message: "Error: server requires encryption."
However, when I use the connection string in other database tools (such as DataGrip, Beekeeper Studio), I was able to connect successfully.

@Fabio286 Fabio286 added bug 🪲 Something isn't working PostgreSQL 🐘 labels Jun 20, 2024
@Fabio286
Copy link
Member

Fabio286 commented Jun 20, 2024

Can you try to add to the connection string ssl=true?

@yanecc
Copy link
Author

yanecc commented Jun 20, 2024

Well, it works fine right now.

@Fabio286
Copy link
Member

Thank you for trying.
A fix will come on next update.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug 🪲 Something isn't working PostgreSQL 🐘
Projects
Status: Done
Development

No branches or pull requests

2 participants