Jyothsna Nayak Posted November 11, 2019 Share Posted November 11, 2019 We are facing the following error when creating a MySQL Datasource in TDV Studio. Unable to connect to data source "/shared/Admin Database/Data Sources/CACHE DATABASE/MySQL Cache" at "xx.xx.xx.xx:3306@" with the supplied connection information. [datasrc-3961050] Unable to connect to data source "/shared/Admin Database/Data Sources/CACHE DATABASE/MySQL Cache" at "jdbc:mysql://xx.xx.xx.xx:3306/DBNAME". Make sure the URL information, user name and password are correct. [datasrc-3961025] Cause: 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: 85a492e6-04c4-491a-be42-d9b29eb93472]What can be done to correct this error Link to comment Share on other sites More sharing options...
Jyothsna Nayak Posted November 18, 2019 Author Share Posted November 18, 2019 We raised a ticket with Tibco Support to resolve this issue. They instructed us to follow the following steps to resolve the issue. 1. Open the advanced settings panel for the datasource. Then change the connection format to "mysql://xx.xx.xx.xx:3306/DBNameuseSSL=false&allowPublicKeyRetrieval=true" 2. Change jar from mysql-connector-java-8.0.11.jar to mysql-connector-java-5.1.48.jar. Placethe jar file "mysql-connector-java-5.1.48.jar" in location "confadapterssystemmysql_5_5". Then restart the TDV server. 3. Createda new MySql 5.5 datasource with the same connection details as earlier. Create datasource and introspect to fetch underlying objects. This fixed the issue and we were able to connect and introspect the MySQL 8.0 database. Note: It is important that connectivity between the TDV server and the MySQL Database is active on port 3306. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now