Q & A
Governance & Security
Learn Dataiku DSS
Q & A
Ask a Question
Email or Username
I forgot my password
connection sqldatabase in vm
Hello, I am working in a vm and wanted to connect to my databases, on one of my computers I am able to do it, and when I checked my port connections using nmap in the virtual machine I receive "3306/tcp open mysql" telling me that the port is open, but when I copied the same jar var to another virtual machine with dss I do not see this message and I am not able to connect to the database as in my other virtual machine. Is there a step I am missing between sending the jar file to my computer and restarting dss that I am missing? do I need to do something else to install the jar files?
May 10, 2017
DSS should be able to access the database as soon as the network port for it is accessible from the DSS host (in your case, the VM). And of course this is a mandatory prerequisite.
You can test this by installing and running the mysql client on the VM, and checking that you can reach the database. Once this test works, installing the JAR in DSS and configuring the same JDBC parameters in DSS should be enough (you may need to restart DSS after installing the JAR though).
So the problem should be narrowed to configuring the different network elements between the VM and your database server to allow this connection. This would at least include the VM hypervisor network configuration, and maybe also the firewalls on the hypervisor host and the database host.
As you hinted in a previous message, configuring your DSS VM to be in bridge networking mode may help as it should simplify the problem. In any case, this issue is outside DSS scope and should be investigated with your network administrator.
With best regards
May 11, 2017
to add a comment.
to answer this question.
Most popular tags
How do I install the MS SQL Server Driver on the VirtualBox VM
mysql problem connection
connection 3rd computer
ms sql server problem virtual machine
How can I use MS SQL server with virtual machine
Welcome to Dataiku Answers, where you can ask questions and receive answers from other members of the community.
©Dataiku 2012-2018 -