From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | David Patricola <david(dot)patricola(at)jefferson(dot)edu> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: SSL connection failure |
Date: | 2011-03-30 20:50:22 |
Message-ID: | AANLkTinx5jEgsC+f5mzhyrfBL_yOhKp5BaXiiScWMvRa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Wed, Mar 30, 2011 at 11:27 AM, David Patricola
<david(dot)patricola(at)jefferson(dot)edu> wrote:
> The server I am connecting to is Redhat with postgres 8.2, running with ssl
> enabled. The client I am connecting from is Windows 2003 with ColdFusion 8
> Enterprise (runs on a Java engine). I set up all the certificates and can
> connect securely on my desktop with pgAdmin3. I copied the same root.crt to
> the above Windows box, and installed it in the keystore using the following:
>
>
>
> E:\JRun4\jre\bin>keytool -importcert -alias dca –file
> E:\Jrun4\jre\lib\security\root.crt -keystore
> E:\Jrun4\jre\lib\security\cacerts
>
>
>
> After restarting java services, I retest the datasource connection
> (jdbc:postgresql://x.x.x.x/main?ssl) and get the fail message
> “org.postgresql.util.PSQLException: The connection attempt failed.” with no
> details in any logs to provide details. The connection works without ssl
> fine.
>
>
>
> I’m at a loss for where the handshake failure is occurring. Please note
> that this is the closest to working with java I’ve ever done.
>
>
>
> David Patricola | Senior Cold Fusion Developer | Web Applications & Services
> | Jefferson Information Technologies
>
>
>
> Thomas Jefferson Universtiy | Philadelphia, PA | 215.503.1715 (Office)
David,
There are no server logs either ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2011-03-30 20:55:08 | Re: SSL connection failure |
Previous Message | Basil Bourque | 2011-03-30 19:51:53 | Re: JDBC gripe list |