Five Stars

Unable to connect using tAmazonMySqlConnection on Remote server

Hello,

 

I am using Talend 6.3.1 with Java 8 installed. In Talend job when I use tAmazonMySqlConnection component then I am able to establish the connection with "RDS" if executed on LocalHost. But when I change target execution to one of the remote server job fails and error is on above component as "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communication link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."

 

Can anyone please let me know what am I missing here?

 

 

Thanks & Regards

Vikas Jagadale

1 REPLY
Moderator

Re: Unable to connect using tAmazonMySqlConnection on Remote server

Hello,

From the error message, we see that it is failed to connect to AmazonMySql server from the production server. 

Please check whether you are able to ping to the AmazonMySql server from the production server.

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.