Connecting to MySQL with SSL

[desanip]

Hello everyone,

I have a talend job which connects to mysql database with ssl enabled. By default ssl will be used. How i do add the ssl to my additional jdbc parameters in the tmysqlconnection component?

I tried various combinations of :

"noDatetimeStringSync=true&useSSL=true&requireSSL=true" ,

"noDatetimeStringSync=true&useSSL=true&requireSSL=true"

 and "noDatetimeStringSync=true&verifyServerCertificate=false&useSSL=true"     

and nothing worked?

The jov failed with the following error:

Can somone help me ?

[Anonymous]

Hello,

Please refer to this article about:https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html.

Adding useSSL=true option in the additional parameters. And the java key store must be updated as described in the url above.

Let us know if it helps.

Best regards

Sabrina