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

2 REPLIES
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.
Six Stars

Re: Unable to connect using tAmazonMySqlConnection on Remote server

Talend Open Studio 6.3.1

Windows 10

I am having the same issue -- using tAmazonMysqlConnection, I cannot connect to my Amazon RDS.

I can connect to my Amazon RDS using NodeJS without any issues.

The Amazon RDS certificate is in the working folder of the NodeJS application as well as in the JRE 1.8.131 lib\security folder truststore ( in a file called jseecacerts ).

 

Here is the error (from Talend):

Exception in component tAmazonMysqlConnection_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 851 milliseconds ago. The last packet sent successfully to the server was 846 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:104)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:5285)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1720)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

Can we get a screen shot of the job you are using?

Can we get a screen shot from someone of a successful job setup?

 

Please advise.