🐞 Error when connect to CockroachDB

[yanecc]

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]

Did you provided proper key, cert and other stuffs?

[yanecc]

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]

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

[yanecc]

Well, it works fine right now.

[Fabio286]

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