SSL with tSetKeyStore to DB no secure

[Anonymous]

Hi,

Currently we wish to execute jobs in the Talend Cloud.
Our data DB MySql are on another space and the DB is not secure ( only use our private cloud Amazon) .
The solution was to place a Amazon ELB to IP redirection not secure DB to outer IP SSL.
Certificates are operational and the only external IP is available from the IP office.
All are validate by DevOps.

We used the component Talend to conduct local testing ( IP Office ) before white list other external IP .

tSetKeyStore uses local TrustStore and KeyStore with the password .
tMysqlConnection points to the external IP ( mysql-ssl.mydomain.com ) and port 43306 Secure .
We have added the additional parameters UseSSL = true & noDatetimeStringSync = true.

Despite all this we do not have to connect to the DB .


Regards
Jeremie

[Anonymous]

Jeremie,

just using the tMySQL connection does not open the one. You have to also use say tMySQLInput for it to happen.

Thomas

[Anonymous]

Thanks Thomas,
but if the tMySQL connection failed, the related tMySQLInput can't be run.
Regards
Jeremie