Postgres SSL/TLS

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2012 01:06 PM
Good day,
I am trying to setup a TLS/SSL connection between my Alfresco box and Postgres Database server. I have not seen any documentation on this, and am not sure if it is even supported. My database config works fine without encryption, but if I configure my Postgres conf file to require SSL and modify the jdbc string to: db.url=jdbc
ostgresql://server:5432/alfresco?ssl=true per some jdbc docs, but it still doesn't seem to function. Any pointers/guidance would be very much appreciated.
I am trying to setup a TLS/SSL connection between my Alfresco box and Postgres Database server. I have not seen any documentation on this, and am not sure if it is even supported. My database config works fine without encryption, but if I configure my Postgres conf file to require SSL and modify the jdbc string to: db.url=jdbc

Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2012 04:05 PM
I found the issue. The jdbc string is correct, but I had an expired certificate on the pgsql server. After I updated the certificate on pgsql, I also had to import the intermediate cert with the java keystore util. Verified OTW encryption is working with tcpdump.
