Re: SSL connection failure - Mailing list pgsql-jdbc

From David Patricola
Subject Re: SSL connection failure
Date
Msg-id 9B4BF0C805D04EC69B2A07D22AD71883@tjumst.jefferson.edu
Whole thread Raw
In response to Re: SSL connection failure  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Dave, the error logs only show the same error message as displayed on the
browser.

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer
Sent: Wednesday, March 30, 2011 4:50 PM
To: David Patricola
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] SSL connection failure

On Wed, Mar 30, 2011 at 11:27 AM, David Patricola
<david.patricola@jefferson.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

>
>

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc


pgsql-jdbc by date:

Previous
From: "Marc Mamin"
Date:
Subject: Re: JDBC gripe list
Next
From: "David Patricola"
Date:
Subject: Re: SSL connection failure