topic Re: mysql SSL connection in Talend Studio

mysql SSL connection

Anonymous — Thu, 20 Nov 2014 23:31:30 GMT

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

Re: mysql SSL connection

Anonymous — Fri, 21 Nov 2014 06:56:34 GMT

Hi,

Is there any more error info when you click "Details" on Metadata DB Connection?
Best regards
Sabrina

Re: mysql SSL connection

Anonymous — Fri, 21 Nov 2014 16:14:15 GMT

Hi,

Is there any more error info when you click "Details" on Metadata DB Connection?
Best regards
Sabrina

Just "connection timeout". I know this is because of the SSL.
Dave

Re: mysql SSL connection

Anonymous — Mon, 24 Nov 2014 13:10:23 GMT

Hi,

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

Re: mysql SSL connection

_AnonymousUser — Mon, 09 Feb 2015 22:18:27 GMT

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

Re: mysql SSL connection

Anonymous — Fri, 13 Mar 2015 19:58:04 GMT

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)

Re: mysql SSL connection

_AnonymousUser — Mon, 01 Aug 2016 17:40:24 GMT

Hello,
I have the same error,
have you find a solution to your problem,
thanks in advance.

Re: mysql SSL connection

Anonymous — Wed, 03 Aug 2016 11:05:05 GMT

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

Re: mysql SSL connection

Anonymous — Fri, 19 Aug 2016 16:59:10 GMT

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:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

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

To see the whole post, download it here
OriginalPost.pdf