Re: Have some problem about the SSL connection by JDBC

to Dave
    http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php this is
useful.
    After I read it.
    I just import the server certificate into the client's keystore. (^-^)
    I do it with this command:
# keytool -keystore $JAVA_HOME/jre/lib/security/cacerts -alias [any name for
the cert you like (i.e. postgres)] -import -file server.crt.der
And then it works.
    By the way you should use JDBC Driver after 7.4.

----- Original Message -----
From: "Dave Cramer" <pg@fastcrypt.com>
To: <zhang-x@cnt.mxy.nes.nec.co.jp>
Cc: "Oliver Jowett" <oliver@opencloud.com>; <pgsql-jdbc@postgresql.org>
Sent: Wednesday, April 07, 2004 9:47 PM
Subject: Re: [JDBC] Have some problem about the SSL connection by JDBC


> Can you share the solution with the list?
>
> Dave
> On Wed, 2004-04-07 at 08:24, zhang-x@cnt.mxy.nes.nec.co.jp wrote:
> > Thanks for your help I have resolve my problem.
> > Thanks.
> > ----- Original Message -----
> > From: "Oliver Jowett" <oliver@opencloud.com>
> > To: <zhang-x@cnt.mxy.nes.nec.co.jp>
> > Cc: <pgsql-jdbc@postgresql.org>
> > Sent: Wednesday, April 07, 2004 8:17 AM
> > Subject: Re: [JDBC] Have some problem about the SSL connection by JDBC
> >
> >
> > > zhang-x@cnt.mxy.nes.nec.co.jp wrote:
> > >
> > > > An I/O error has occured while flushing the output - Exception:
> > > > javax.net.ssl.SSLHandshakeException:
> > > > sun.security.validator.ValidatorException: No trusted certificate
found
> > >
> > > You need to import the server certificate into the client's keystore.
> > > See http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php for
> > > details.
> > >
> > > -O
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
> --
> Dave Cramer
> 519 939 0336
> ICQ # 14675561
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html