Talend 7.3.1 Communication Failure/Driver Error when connecting to MySQL 8.0

[tvsr984]

Hi,

I am trying to connect to MySQL 8.0 and getting the following error

Connection String Used:

jdbc:mysql://test.mysql.database.azure.com:3306/test_db?noDatetimeStringSync=true&useSSL=true&requireSSL=false&&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

====================================

[statistics] connecting to socket on port 3743

[statistics] connected

Exception in component tMysqlInput_7 (ENCOUNTER_XML_0_HEADER)

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)

at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831)

at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)

at capella_cmg_pro.encounter_xml_0_header_0_1.ENCOUNTER_XML_0_HEADER.tMysqlInput_7Process(ENCOUNTER_XML_0_HEADER.java:9622)

at capella_cmg_pro.encounter_xml_0_header_0_1.ENCOUNTER_XML_0_HEADER.tMysqlInput_6Process(ENCOUNTER_XML_0_HEADER.java:3501)

at capella_cmg_pro.encounter_xml_0_header_0_1.ENCOUNTER_XML_0_HEADER.runJobInTOS(ENCOUNTER_XML_0_HEADER.java:10221)

at capella_cmg_pro.encounter_xml_0_header_0_1.ENCOUNTER_XML_0_HEADER.main(ENCOUNTER_XML_0_HEADER.java:10060)

Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)

at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)

at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:338)

at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777)

at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486)

at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)

at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1340)

at com.mysql.cj.NativeSession.connect(NativeSession.java:157)

at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850)

... 10 more

Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

at java.base/sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:170)

at java.base/sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:98)

at java.base/sun.security.ssl.TransportContext.kickstart(TransportContext.java:238)

at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:394)

at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:373)

at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:316)

at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188)

at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99)

at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:329)

... 16 more

[statistics] disconnected

===================================

[Anonymous · Accepted solution]

Hi

I found one similar issue reported Talend bugtracker, our developer suggested the quick fix/workaround,

Add ?enabledTLSProtocols=TLSv1.2 at the end of your jdbc URL in the payload to force the usage of TLSv1.2.

Can you try and let me know if it works.

Regards

Shong

[tvsr984]

Thanks. It worked