I am trying to connect to mysql using SSL. The certificate files for: Private Key, CA Cert, and Cert files have all been installed on the machine running Talend. This machine is the windows development machine running TOS
I have added this to the "additional parameters" input of the Talend mysql connection:
noDatetimeStringSync=true&verifyServerCertificate=true&useSSL=true&requireSSL=true&ssl_ca=C:/Users/Desktop/SQL Dev/ca-cert.pem&ssl_key=C:/Users/Desktop/SQL Dev/client-key.pem&ssl_cert=C:/Users/Desktop/SQL Dev/client-cert.pem
I keep getting a "connection timeout" error in TOS when trying to run the job in the IDE.
When deploying the code to a linux box with syntax just like above, but using different folders, it work, so I know the syntax format should be ok. I just cannot get this to work on the windows development machine.
I can connect through TOAD for mysql on the same windows box, so I know the SSL and db connection works fine. Unfortunately TOAD does not display a complete connection string like Talend does in its IDE
Any ideas?
Dave
Is there any more error info when you click "Details" on Metadata DB Connection? Best regards Sabrina Does Talend have consulting that might be able to resolve this? Dave
I am using Talend Open Studio Big Data v5.5.1r118616
I am attempting to connect to a MySQL database that requires SSL. I can connect perfectly with MySQL Workbench using SSL. The database is live and available.
tMysqlConnection is consistently throwing an exception as follows with a variable number of milliseconds. Is this really a timeout, or is something else going on?
Exception in component tMysqlConnection_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Exception in component tMysqlConnection_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 219 milliseconds ago. The last packet sent successfully to the server was 211 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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)
disconnected
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(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at big_data_demos.filemakertolaptopmongodb_0_1.FilemakerToLaptopMongoDB.tMysqlConnection_1Process(FilemakerToLaptopMongoDB.java:732)
at big_data_demos.filemakertolaptopmongodb_0_1.FilemakerToLaptopMongoDB.tMongoDBConnection_1Process(FilemakerToLaptopMongoDB.java:637)
at big_data_demos.filemakertolaptopmongodb_0_1.FilemakerToLaptopMongoDB.tOracleConnection_1Process(FilemakerToLaptopMongoDB.java:518)
at big_data_demos.filemakertolaptopmongodb_0_1.FilemakerToLaptopMongoDB.runJobInTOS(FilemakerToLaptopMongoDB.java:3210)
at big_data_demos.filemakertolaptopmongodb_0_1.FilemakerToLaptopMongoDB.main(FilemakerToLaptopMongoDB.java:3069)
Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:524)
at sun.security.ssl.InputRecord.read(InputRecord.java:506)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1312)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1339)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1323)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:89)
... 22 more
I am using Talend Open Studio Big Data v5.5.1r118616 I am attempting to connect to a MySQL database that requires SSL. I can connect perfectly with MySQL Workbench using SSL. The database is live and available. tMysqlConnection is consistently throwing an exception as follows with a variable number of milliseconds. Is this really a timeout, or is something else going on? Exception in component tMysqlConnection_1 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
I have same result with TOS 5.6.1 - communication link failure.
Is it a bug?
(parameters: noDatetimeStringSync=true&useSSL=true&ssl_ca=c:/DDS/aws/rds-combined-ca-bundle.pem)
Hi haddadous, Could you please indicate the build version you are using? Would you mind posting your mysql DB connection setting screenshot in metadata into forum? Best regards Sabrina
Hi every one,
I have the same problem, below the stackoverflow :
java.lang.RuntimeException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
java.net.SocketException: java.net.ConnectException: Connection timed out: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485) at com.m
