Error during the creation of a MySQL data source for TIBCO Data Virtualization

[Manoj Chaurasia]

Hi,

on my local machine I've TIBCO Data Virtualization Studio and Server vers. 8.5 and a MySQL vers. 8.0.28 installation.

I've created a sample MySQL database in order to try to connect it by TDV.

I've tried to create a MySQL data source by specifying localhost as the Host and 3306 as the Port and then the necessary login and

password, but I've obtained this error when testing the connection:

Unable to connect to data source "/shared/examples/dv_test" at "localhost:3306@db_test" with the supplied connection information. [datasrc-3961050]

Unable to connect to data source "/shared/examples/dv_test" at "jdbc:mysql://localhost:3306/db_test". Make sure the URL information, user name and password are correct. [datasrc-3961025]

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. [Log ID: 0ab94cf5-e4e5-4adf-ba89-e6f258e7a3ae]

Now, any suggests to me in order to solve this issue, please Thanks

[Alain Martens]

Hi Pasquale,

Are you able to successfully connect using DB client (like DBeaver) from the same machine where TDV is running With this you can exclude that the issue is within TDV (or not).

Thanks,

Alain

[Seung Jae Jeong]

Hi Pasquale,

MySQL 8 use SSL as default. You need to disable a SSL mode as adding "useSSL=false" in JDBC URL.

 

Thanks,

Seungjae Jeong