tSetKeyStore: SSL Connection required, but not supported by server

One Star

tSetKeyStore: SSL Connection required, but not supported by server

Hi guys,
I need your help:
I have a talent job running on server A that needs to connect to MySqlServer B (koko) via SSL and then import some table back in server A.
The owner of server B gave me a certificate file:  "xyz.com.crt"
I don't need a password and I left blank the field: "TrustStore password"
I suppose I need to use the "tSetKeyStore" component and I tried to set the parameters but I have this error:

Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: SSL Connection required, but not supported by server........


Please see the screenshot attached.
Do I need to set up something in the JVM outside the Talend job?
Is there something wrong?
If I try to connect using terminal from A to B the connection works well:
>> mysql -u users -p xxx -h koko.server.com --ssl --ssl-ca="./xyz.com.crt" --ssl-cipher=AES256-SHA
Thanks in advance!
Mary
Moderator

Re: tSetKeyStore: SSL Connection required, but not supported by server

Hi,
Did you add SSL encryption onto the MySqlServer B? Have you tried to enable SSL on your server B?
 Could you please take a look at the jira issue https://jira.talendforge.org/browse/TDI-32738 to see if it works for you?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download