topic Re: Talend connection with MySQL(remote) database in Talend Studio

Talend connection with MySQL(remote) database

Anonymous — Wed, 11 Mar 2020 13:05:42 GMT

Dear Expert,

I am trying to connect mySQL database which is hosted in remote and talend is giving error.

from Metadata option:

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

from direct tDBinput option:

Wed Mar 11 18:31:08 IST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

After adding:

&useSSL=false&requireSSL=false

nothing happining

After change:

&useSSL=true&requireSSL=true

getting the above error communication link failure.

if this related SSL setting in mySQL db side or firewall than i dont understand how Tableau able to connect ( i can able to connect the same database from tableau and able to create report)

Regards

prithivt

Re: Talend connection with MySQL(remote) database

Anonymous — Sun, 15 Mar 2020 09:55:09 GMT

Hi
Please provides the following information, it will help us to more easily evaluate your issue:
- Product and Version which you used (for example, Talend Data Fabric 7.3.1)
- Operating System, for example, Windows Server 2008 R2 SP1 (64bit)
- Version of Java Platform JDK / JRE in use (for example, ORACLE JDK 1.8.0_161)
- Mysql version

Regards
Shong

Re: Talend connection with MySQL(remote) database

Anonymous — Tue, 17 Mar 2020 14:15:27 GMT

Dear Shoung,

Thank you and find the info below.

Talend Open Studio DI - 7.2.1

OS - Mac

JDK 1.8.0

mySQL- 8.0

Re: Talend connection with MySQL(remote) database

DM_J — Tue, 09 Nov 2021 15:18:36 GMT

Dear Shoung

change requireSSL=true to useSSL=true

Note that this is a JDBC problem for example see https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database