Connecting to Maria DB table through Talend

sushantk19 — Fri, 15 Nov 2024 22:19:25 GMT

Hello,

I am trying to connect to newly created Maria DB tables through Talend studio connectors. But I am getting the below error:

Hostname=

host=mwa-prod-db.ctfqz73k2kqj.eu-central-1.rds.amazonaws.com

Port No=3306

[FATAL] 14:18:12 lillydoodwh.job_staging_001_lma_midwife_address_0_1.job_Staging_001_LMA_Midwife_Address- tDBInput_1 Could not connect to address=(host=mwa-prod-db.ctfqz73k2kqj.eu-central-1.rds.amazonaws.com)(port=3306)(type=master) : Socket fail to connect to host:mwa-prod-db.ctfqz73k2kqj.eu-central-1.rds.amazonaws.com, port:3306. connect timed out

java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=mwa-prod-db.ctfqz73k2kqj.eu-central-1.rds.amazonaws.com)(port=3306)(type=master) : Socket fail to connect to host:mwa-prod-db.ctfqz73k2kqj.eu-central-1.rds.amazonaws.com, port:3306. connect timed out

I have attached the Maria DB & Talend Studio related screenshots. Please have a look and let me know why I am unable to connect to this DB? Am I missing any configurations here?

Regards,

Sushant

Re: Connecting to Maria DB table through Talend

Anonymous — Tue, 29 Nov 2022 02:20:55 GMT

Hello @Sushant Kapoor ,

Regarding to the error log, the problem is that the studio machine can't connect to the Maria DB due to network issue.

Could you please try to whitelist the studio machine ip in the security group of the Maria DB in AWS ?

Best regards

Aiming

Re: Connecting to Maria DB table through Talend

sushantk19 — Tue, 29 Nov 2022 15:08:44 GMT

this issue is now fixed by our IT Team. so closing this ticket

topic Re: Connecting to Maria DB table through Talend in Talend Studio

Connecting to Maria DB table through Talend

Re: Connecting to Maria DB table through Talend

Re: Connecting to Maria DB table through Talend