topic Re: [resolved] How can I connect with mysql database(SSL enabled) using TOS (5.2.2)? in Talend Studio

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

_AnonymousUser — Sat, 16 Nov 2024 11:58:37 GMT

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.

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

Anonymous — Tue, 09 Jul 2013 04:20:40 GMT

Hi,
Did the job run successfully if you don't use SSL? In addition, the image of setkeystore seem to be lost.
Best regards
Sabrina

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

_AnonymousUser — Tue, 09 Jul 2013 06:21:18 GMT

Hi Sabrina,
Thanks for your quick response.Yes,I am able to execute the job successfully..if I don't use SSL(if it is normal DB)

But not able to execute the job if the DB is SSL enabled(if I don't use SSL) and getting below exception.

Exception details :

Exception in component tMysqlConnection_1
java.sql.SQLException: Access denied for user 'yii'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4612)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
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)
disconnected
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)
regarding the image :
I uploaded the image several times(using Image Upload) but it is not appearing here..can you please guide how
can I do that.
Thanks in advance.

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

Anonymous — Tue, 09 Jul 2013 06:59:52 GMT

Hi,
For your SSL enabled DB, I need make a investigation about it and comeback to you asap.
For registered users, I realize the image upload feature is only available when clicking on "post reply" (not through the quick post")and a Image upload box allows to upload screen captures and images up to 200KB.
Best regards
Sabrina

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

_AnonymousUser — Tue, 09 Jul 2013 07:23:39 GMT

Hi Sabrina,
I have uploaded the image using "postreply" feature only and the image is having less then the mentioned size.

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

Anonymous — Tue, 09 Jul 2013 07:43:56 GMT

Hi,

I have uploaded the image using "postreply" feature only and the image is having less then the mentioned size.

What browser are you using?(I'm using Firefox, and it perfect). Could you use another one to test it? Is your pic under the size of 1024X768 pixels?
Best regards
Sabrina

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

_AnonymousUser — Tue, 09 Jul 2013 07:53:37 GMT

Hi Sabrina,

What browser are you using?(I'm using Firefox, and it perfect). Could you use another one to test it? Is your pic under the size of 1024X768 pixels?

Ok...I am using Google chrome till now.
I am in a need of urgency..so can u please guide me on the SSL configuraion.

Environment details :
OS : Windowx XP
java version : 1.7.0_07
Enabled in my java console :
use SSL : SSLv3.0
use TLS : TLSv1.0
Is there any thing that I'm missing apart from the above details?

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

_AnonymousUser — Tue, 09 Jul 2013 12:42:30 GMT

Can any one please help on this.

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

Anonymous — Tue, 09 Jul 2013 22:01:52 GMT

I am not 100% sure but parameters will be separated with a semicolon and not with a &. This parameters will usually not added to an URL as query.

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

_AnonymousUser — Wed, 10 Jul 2013 06:48:14 GMT

Hi jlolling,

I am not 100% sure but parameters will be separated with a semicolon and not with a &. This parameters will usually not added to an URL as query.

Thanks for your response.
Now I'm able to connect with local database(SSL enabled) with the same parameters.
But not for the remote database(SSL enabled)...Is there any thing that I need to configure in Talend for remote database?

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

_AnonymousUser — Wed, 10 Jul 2013 13:41:08 GMT

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.

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

Anonymous — Thu, 11 Jul 2013 04:21:42 GMT

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

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

shrikant_kp — Fri, 11 Nov 2016 15:07:43 GMT

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