Skip to main content

Question

 REDDI RANI PULIKANTI (REDDIRANIP)
Citigroup Inc
Vice President
Citigroup Inc
US
REDDIRANIP Member since 2018 5 posts
Citigroup Inc
Posted: Sep 7, 2023
Last activity: Apr 3, 2024
Posted: 7 Sep 2023 7:25 EDT
Last activity: 3 Apr 2024 18:12 EDT

PEGA - JDBC connect over SSL

Hi Team,

We need to configure the JDBC connection with ssl. Please let us know how we can do that. We are using the PEGA platform 8.8.2 and Tomcat server 9.0.50. 

Thanks in Advance.

***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.8.2
Data Integration
Installation and Deployment

  • Reply
Posted: 9 months ago
Posted: 3 Apr 2024 18:12 EDT
Venkata Doppalapudi (Venkat_Anthem)
Anthem INC

Anthem INC
US

@REDDIRANIP Did you get any response on this? I am trying to connect using the jdbc URL in below format: jdbc:postgresql://dbhost:dbport/dbname?sslmode=verify-full

However, the database connection is failed with the below error. It is because Pega is looking for the root certificates in /home/jboss. I don't know how we can redirect Pega to look for the certificate in a specific location instead of the default location. Did you find any solution to this?

Could not open SSL root certificate file /home/jboss/.postgresql/root.crt. | SQL Code: 0 | SQL State: 08006 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice