0 votes
Excuse me I have this error when trying to make a mysql connection to dataiku " Connection failed: Failed to connect: 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., caused by: ConnectException: Connection refused (Connection refused)" I have seen there are many related questions around this, but none really saying how to solve it. I already have the driver in my jdbc folder. For what I  understand after making several trials I know it is connecting to the driver, but the port is not open which makes me think that it is trying to connect to the localhost of the virtual machine, not to mine in windows (where I have my port and database open). has anyone got a solution for this?
asked by
Hi

if the database you want to connect to is on the host computer (as opposed to: on the VM) you should indeed configure it on DSS using the IP address of the host as seen from the VM (configuring "localhost" or "127.0.0.1" would attempt to connect to a database server hosted on the VM)

The exact value of this address depends on your virtualization environment (VMWare or VirtualBox) and may also depend on the network settings of your virtualization software.
Ways to identify it include:
- looking in the settings menus of the virtualization software
- running command "ipconfig /all" on the windows host, and looking for a virtual interface named after the virtualization software
- logging onto the VM (dataiku/dataiku) and typing "ip route".  The address mentioned in the "default via ADDRESS..." line should be the one to use

Hope this helps. In case of difficulties, if you can provide the exact virtualization environment you are using (for example : VMWare version xxx on Windows) and if this virtualization environment is running with all-default settings, we should be able to reproduce it and give you a more precise answer.
awesome, it was this, I  believe I was trying the wrong IP address, I tried another similar to the one I got from this command. I suppose I have a long way to go till I become a Jedi master. I really appreciate your answer, I cannot up vote this since it appears as a comment, but if you make it as answer I will up vote it.

1 Answer

+1 vote
Best answer
If the database you want to connect to is on the host computer (as opposed to: on the VM) you should indeed configure it on DSS using the IP address of the host as seen from the VM (configuring "localhost" or "127.0.0.1" would attempt to connect to a database server hosted on the VM)

The exact value of this address depends on your virtualization environment (VMWare or VirtualBox) and may also depend on the network settings of your virtualization software.
Ways to identify it include:
- looking in the settings menus of the virtualization software
- running command "ipconfig /all" on the windows host, and looking for a virtual interface named after the virtualization software
- logging onto the VM (dataiku/dataiku) and typing "ip route".  The address mentioned in the "default via ADDRESS..." line should be the one to use

Hope this helps
Patrice Bertin
Dataiku
answered by
selected by
840 questions
866 answers
811 comments
992 users