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)
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
Note that this is a JDBC problem for example see https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database
