tSetKeyStore: SSL Connection required, but not supported by server

Anonymous — Mon, 14 Dec 2015 13:44:06 GMT

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

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

Anonymous — Tue, 22 Dec 2015 07:27:01 GMT

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

topic Re: tSetKeyStore: SSL Connection required, but not supported by server in Talend Studio

tSetKeyStore: SSL Connection required, but not supported by server

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