Connecting to Maria DB table through Talend

[sushantk19]

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

[Anonymous]

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

[sushantk19]

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