Unable to connect using tAmazonMySqlConnection on Remote server

Anonymous — Tue, 19 Sep 2017 06:44:07 GMT

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

Re: Unable to connect using tAmazonMySqlConnection on Remote server

Anonymous — Tue, 19 Sep 2017 09:23:37 GMT

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

Re: Unable to connect using tAmazonMySqlConnection on Remote server

tale103108 — Mon, 05 Mar 2018 14:56:41 GMT

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.

topic Re: Unable to connect using tAmazonMySqlConnection on Remote server in Talend Studio

Unable to connect using tAmazonMySqlConnection on Remote server

Re: Unable to connect using tAmazonMySqlConnection on Remote server

Re: Unable to connect using tAmazonMySqlConnection on Remote server