Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
0683p000009MChN.png
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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