Neotys.com

Unanswered question

ERROR: node is running secure mode, SSL connection required when trying to connect cockroachdb?

Screenshot 2020-07-31 at 13.20.06.png Screenshot 2020-07-31 at 13.20.06.png
Screenshot 2020-0...
529 KB
July 31, 2020
Processed

I am trying to connect cockroachdb via Neoload and mentioned all the required parameter in the connection settings. It's still asking SSL connection is required.

Please suggest how to configure SSL parameter in the connection settings? I have attached the screenshot for reference.

Screenshot 2020-07-31 at 13.20.06.png Screenshot 2020-07-31 at 13.20.06.png
Screenshot 2020-0...
529 KB
July 31, 2020
Processed
Jabastin P.
Jabastin P.

Jabastin P.

Level
0
54 / 100
points
Answer count
2 answers
Category
Design
Author name
Jabastin P.
Date
July 31, 2020
over 4 years ago
Hits
viewed 394 times
question
q

Answers

Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

Have you tried to add such parameters: sslmode=verify-ca, sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory using the parameters connection.property for example like this: connection.sslfactory and connection.sslmode?

 

Author name
Nouredine A.
Date
answer
a
Jabastin P.
Jabastin P.

Jabastin P.

Level
0
54 / 100
points

Yes, I tried all the best possible settings already. I exposed the connection to my localhost with port 8080 and tried to connect the db with settings mentioned above.

I have a certificate files to connect to the postgreSQL (cockroachdb).
1) server.pk8 – private key
2) server.crt – server certificate
3) root.crt – trusted root certificate

Would like to know how to configure those cert files as a parameters (syntax) in neoload?

Author name
Jabastin P.
Date
answer
a