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(at)fastcrypt(dot)com>
To: <zhang-x(at)cnt(dot)mxy(dot)nes(dot)nec(dot)co(dot)jp>
Cc: "Oliver Jowett" <oliver(at)opencloud(dot)com>; <pgsql-jdbc(at)postgresql(dot)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(at)cnt(dot)mxy(dot)nes(dot)nec(dot)co(dot)jp wrote:
> > Thanks for your help I have resolve my problem.
> > Thanks.
> > ----- Original Message -----
> > From: "Oliver Jowett" <oliver(at)opencloud(dot)com>
> > To: <zhang-x(at)cnt(dot)mxy(dot)nes(dot)nec(dot)co(dot)jp>
> > Cc: <pgsql-jdbc(at)postgresql(dot)org>
> > Sent: Wednesday, April 07, 2004 8:17 AM
> > Subject: Re: [JDBC] Have some problem about the SSL connection by JDBC
> >
> >
> > > zhang-x(at)cnt(dot)mxy(dot)nes(dot)nec(dot)co(dot)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(at)postgresql(dot)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