[SOLVED] - Connection to mysql using certificates

[Alessandro Camel]

Hello all,
I'm trying to connect to mysql server using ssl ( the only way it accepts connections).

First of all this is my perl code:

$openssl  = '/CERTIFICATES/mysql4';
$dns = "DBI:mysql:$DATABASE:$HOST;mysql_ssl=1;mysql_ssl_client_key=$openssl/client-key.pem;mysql_ssl_client_cert=$openssl/client-cert.pem;mysql_ssl_ca_file=$openssl/cacert.pem";

and it works without any problem.

This is my java code :

Connection connection = null;
String url = "jdbc:mysql://192.168.0.1/ER"+
"?verifyServerCertificate=true"+ "&useSSL=true"+ "&requireSSL=true";

System.setProperty("javax.net.ssl.keyStore","/CERTIFICATES/mysql4/cacert.pem");
System.setProperty("javax.net.ssl.keyStorePassword","/CERTIFICATES/mysql4/client-cert.pem");
System.setProperty("javax.net.ssl.trustStore","/CERTIFICATES/mysql4/client-key.pem");
//System.setProperty("javax.net.ssl.trustStorePassword","/CERTIFICATES/mysql4/client-key.pem");

connection = DriverManager.getConnection(url,"my_user", "my_password");

As you can see, I'm a little confused about the values that I have to put as "javax.net.ssl.*
I have read about the java keytool utility, but I'm not sure if I have to use it! (I'm really a java newbie!!!)

Last thing: if I use verifyServerCertificate=false, I can connect to the mysql server, but I'm not allowed to do anything else.

Thanks for any help.
Alessandro

[Alessandro Camel]

Sometimes the solution is only one: Try it!

I found this very clear page:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html

I followed the instructions and everything is working!

End of my first ( and useless ) post !

[Sagar Rohankar]

I generally set properties as:

System.getProperties().setProperty("javax.net.ssl.keyStore","/CERTIFICATES/mysql4/cacert.pem");  

Alessandro wrote: Sometimes the solution is only one: Try it!

That's whay SearchFirst

And welcome to JavaRanch