[resolved] How can I connect with mysql database(SSL enabled) using TOS (5.2.2)?

[_AnonymousUser]

Hi all,
I am trying to connect with mysql database using tmysqlconnection component and I have configured keystore and
truststore files in tsetkeystore component also.But I am not able to connect with the database.

Configured tmysqlconnection like this in TOS ESB(5.2.2):
Additional JDBC Parameters :
useSSL=true
Exception details :
Exception in component tMysqlConnection_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 203 milliseconds ago. The last packet sent successfully to the server was 203 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:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:105)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:5167)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1342)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
disconnected
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
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:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at pragatisap_proj.keystorejob_0_1.keystoreJOB.tMysqlConnection_1Process(keystoreJOB.java:478)
at pragatisap_proj.keystorejob_0_1.keystoreJOB.tSetKeystore_1Process(keystoreJOB.java:405)
at pragatisap_proj.keystorejob_0_1.keystoreJOB.runJobInTOS(keystoreJOB.java:1237)
at pragatisap_proj.keystorejob_0_1.keystoreJOB.main(keystoreJOB.java:1105)
Caused by: javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
at sun.security.ssl.InputRecord.readV3Record(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:90)
... 20 more
I have attached image of the setkeystore also with this post.
Can any one please help me on this.

[_AnonymousUser · Accepted solution]

The issue has been resolved.
The problem with MySQL server configuration on remote machine not with the Talend.
Now I'm able to connect with the client as well remote databases.
Thank u all.

[Anonymous]

Hi,
It is great. Thanks for sharing your experience with us.
Best regards
Sabrina

[shrikant_kp]

Hi Team,
We are facing similar issue while connecting to oracle fusion DB with SSL while connecting it from client machine.
We are trying to connect with tcps protocol.  Also tried by importing .jks .p7b in tksetKeystore component.
Can anybody please help me on how to set oracle wallet & connect server DB from client machine.
Thanks, 
Shrikant