Thank you everyone for your help so far. I'm at the cusp of completion and now the final test remains. I am testing my CF8 Enterprise datasource client connection to a Redhat 5 Postgresql server, and so far is failing:
Someone else created the certificates for me on the Redhat box and sent me them, so I am trusting that they are correct (they followed this instruction: http://developer.postgresql.org/pgdocs/postgres/ssl-tcp.html) For the record, I connect to the database without SSL fine, so I know the firewall and pg_hba.conf file is kosher. ===================================== JDBC URL: jdbc:postgresql://x.x.x.x/main?ssl=true Class: org.postgresql.Driver I've done the following steps: 1) E:\JRun4\jre\bin>keytool -importcert -noprompt -trustcacerts -alias dca -file "C :\dcacerts\root.crt" -keystore E:\JRun4\jre\lib\security\cacerts (Note: I used a .crt and not a .cer, which _should_ have no impact) 2) E:\JRun4\jre\bin>keytool -list -keystore E:\JRun4\jre\lib\security\cacerts (to validate import successful) 3) Restarted the service on the client box I get the oh-so-unhelpful "org.postgresql.util.PSQLException: The connection attempt failed" error. Is this an error on my end or is the certificate bad? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
