topic Re: Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert in Talend Studio

Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert

tale103108 — Sat, 16 Nov 2024 08:38:25 GMT

Talend Open Studio 6.3
Windows 10
JDK 1.8.0.111
MySQL 5.6
-------------
I need an example of how to use the tAmazonMysqlConnection component with an Amazon cert bundle. I don't see anywhere in the component where you can specify the cert or cert location. I do know you have to add to the "Additional JDBC Parameters" the following:
useSSL=true
How is a connection accomplished using the tAmazonMysqlConnection component with a Amazon cert bundle? Where do you specify the cert bundle location?
Please provide images if possible.

What I need to do is create a connection similar to the following (file names anonymized):

mysql -h myinstance.c9akciq32.rds-us-east-1.amazonaws.com
--ssl-ca=rds-combined-ca-bundle.pem --ssl-verify-server-cert

The key mentioned above is a public key available from Amazon RDS.

Thank you.

Re: Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert

vapukov — Sat, 24 Feb 2018 01:37:49 GMT

did You already check this tutorial - https://community.talend.com/t5/Architecture-Best-Practices-and/Learned-By-Doing-How-to-connect-a-Studio-job-to-a-MySQL-Server/ta-p/35675 ?

Re: Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert

tale103108 — Thu, 01 Mar 2018 22:24:52 GMT

Your input was helpful.

However, I am using the tAmazonMySQLConnection component. And I used the keytool to store my AWS cert in the Java cert file jseecacerts under my JRE folder %JRE_HOME%\lib\security

Re: Connection to Amazon RDS with tAmazonsqlConnection fails -- how to use tSetKeystore with AWS cert

tale103108 — Mon, 05 Mar 2018 15:08:32 GMT

Here is a related issue -- sounds like I am not the only one having problems.

https://community.talend.com/t5/Design-and-Development/Unable-to-connect-using-tAmazonMySqlConnection-on-Remote-server/m-p/37312/highlight/false#M10089