mysql connector & ssl

[drieh]

Hi,

I have enabled ssl on my mysql server and am using useSSL=true&requireSSL=true in my jdbc connector url.

I am getting the following error:

The root cause was that: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** javax.net.ssl.SSLHandshakeException MESSAGE: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target STACKTRACE: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:174) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1591)  at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Handshaker.java:187) at

If anyone had any success connecting to mysql via ssl I would appreciate any help.

Thanks!

[injun__576871_]

If you can connect with DB without SSL, problem in your certificate.

[drieh]

I used the mysql odbc connector with the certificate and it worked fine so

the problem is not the certificate.

2009/4/8 Alexei Yakovenko <forums@adobe.com>

drieh,

>

A new message was posted in the thread "mysql connector & ssl":

>

http://forums.adobe.com/message/1877560#1877560

>

Author : Alexei Yakovenko

Email : 576871@gmail.com

Profile : http://forums.adobe.com/people/injun%20%5B576871%5D

>

Message:

[ukb_kumar]

As per the exception the problem seems to be the request which you are firing over SSL is not able to gather the certificate as the certificate is not present in the correct path. Where have you uploaded the certificate? Have you added the certificate in the trusted Store?

Regards

UKB