topic MySQL with SSL connection in Talend Studio

MySQL with SSL connection

Anonymous — Mon, 25 Jan 2016 17:51:31 GMT

Hi all,
I need to connect from a local server to a MySQLserver using SSL with a certificate xxx.crt.
What should I do, in general?
Just change the parameters in the jdbc connection? How?
Is this correct: noDatetimeStringSync=true&VerifyServerCertificate=true&useSSL=true&requireSSL=true
Or use the tSetKeystore component?
Or add manually to the key tool/cacerts the certificate?
When is it necessary to use the component tSetKeystore?
I'm having a lot of troubles and I don't know which is the riga way to procede
Do you have some example to give me?
Thanks a lot in advance!

Mary

Re: MySQL with SSL connection

Anonymous — Tue, 26 Jan 2016 06:46:50 GMT

Hi,
Could you please check the solution in this jira issue: https://jira.talendforge.org/browse/TDI-32738 to see if it works for you?
Best regards
Sabrina

Re: MySQL with SSL connection

Anonymous — Tue, 26 Jan 2016 13:51:31 GMT

Hi,
thanks for the reply but I'm not using Sql Server but MySQL.
Please can you tell me which is the right path to use the certificate that I have?
Is it mandatory to use the tSetKeystore component? Which is the easier way to connect to MySQL using ssl?
[font=Verdana, Helvetica, Arial, sans-serif]Thanks a lot in advance![/font]
[font=Verdana, Helvetica, Arial, sans-serif]mary[/font]