You can translate the question and the replies:

DEN70EDUD02 MySQL server connection issues for DEN70EDUD2002LAB04

I am trying to go through DEN70EDUD2002LAB04 and noticed there are issues with connection to a MYSQL server. I followed the steps of adding the jar file from the MYSQL website (adding both the 5.x and 8.x jar files in the lib-external/jdbc-drivers/mysql-5 folder but upon testing the connection for ds_call_center the result shows "Unable to establish connection: Communications link failure".. From what i can see in the Initial configuration walk through pdf, there is no MYAQL server set up in the DQVM that we install in Oracle VM.. I can't find anything anywhere else on how to resolve this issue. Is there a guide provided somewhere on what you are wanting me to do in order to get a server in DQVM?
25-11-2019 16:31:05 -0500

3 Answers

Hi, This error could have occured if the configuration of the data source is incorrect. I would perform the following checks to establish a successful connection. * Check the host name or ip address provided in the connection URI * Ensure that the MYSQL server is started and running For more information, refer to the similar community [here]( Starting from Denodo 7.0, our recommendation for doing the labs is to use the Denodo Quickstart Virtual Machine. All the data sources needed for doing the labs are already available in the Virtual Machine, you just need to download and configure the VM and when it is running you will be able to do all the labs. Refer to the **Configuration** module of the on-demand course for information related to Virtual Machine. Hope this helps!
Denodo Team
27-11-2019 07:25:44 -0500
In repsonse to the previous person. The IP is correct for the VM data source as I am able to connect to all other DS coming from the VM. Also, I am using the Denodo Quickstart Virtual Machine (DQVM) as stated in my original question. Looking in the VM, I do not see anything related to MYSQL loaded so I am unsure how to make sure a MYSQL server is running. Lastly, the **Configuration** module for the on-demand course is the same one for the previous course it seams and does not mention anything about MYSQL so I am unsure what I am missing here. Still need assistance please, thank you.
27-11-2019 10:39:50 -0500
Hi, The VQL script in the lab DEN70EDUD2002LAB04 has been updated. For creating the ds_call_centre datasource you could utilize the Oracle data source other than MYSQL. For more information, refer to the lab module DEN70EDUD1104 of the Introduction course. For doing the lab DEN70EDUD2002LAB04, MYSQL datasource is not needed as you can utilize the oracle source. Hope this helps!!
Denodo Team
11-12-2019 07:54:39 -0500
You must sign in to add an answer. If you do not have an account, you can register here