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
1 REPLY
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.