after much research to various mail-lists, it seems that there is a bug in the beta versions of postgreSQL 8 which is causing the problem. Is there anyway to create a SSLv3 specific certificate?
regards
Andrew On 6 Dec 2004, at 12:28, Kris Jurka wrote:
On Mon, 6 Dec 2004, Andrew M wrote:
jdbc:postgresql://localhost:5432/mydatabase?ssl
When I launch Jboss, which handles the connection to postgresql, I get the following error:
javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found
Difficult to say. Perhaps JBoss is deciding to use an alternate
truststore? Perhaps it doesn't like your cert setup. I would suggest
first running a simple client program to test that it's working first.
Also adding -Djavax.net.debug=ssl to the java command will help debugging
ssl problems.
Further the 8.0 JDBC driver can create SSL connnections without doing authentication by adding using an additional url parameter:
sslfactory=org.postgresql.ssl.NonValidatingFactory
You should try to get it to authenticate correctly, but this is another useful test point.
Kris Jurka
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
