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