search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.6k stars 111 forks source link

🐞 Error when connect to CockroachDB #786

Open yanecc opened 2 months ago

yanecc commented 2 months ago

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:

Fabio286 commented 1 week ago

Did you provided proper key, cert and other stuffs?

yanecc commented 1 week ago

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 commented 1 week ago

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

yanecc commented 1 week ago

Well, it works fine right now.

Fabio286 commented 1 week ago

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