Community Conundrum 25: Feature Visualization is now live! Read More

How do I install the MySQL Driver on the VirtualBox?

Dataiker
Dataiker
How do I install the MySQL Driver on the VirtualBox?

Hello,



I used to read this topic https://answers.dataiku.com/1054/how-do-i-install-the-ms-sql-server-driver-on-the-virtualbox-vm



But I still cannot do it. I really newbie in this area.



I try connect with 127.0.0.1:2222 and 22 it did not work for me.



By the way, the driver is a zip file (mysql-connector-java-5.1.27.zip) I cannot find JAR file inside there. How to get it?



Would you mind to explain more a bit or give me a link for beginner guide.



 



Thank you,

0 Kudos
9 Replies
Level 3
to get the jar file unzip it and open the folders until you get to one that is full of files (for me I had to open two folders using the default options to unzip "mysql-connector-java-5.1.43\mysql-connector-java-5.1.43")and there should be the jar file called "mysql-connector-java-5.1.43-bin.jar"

then, you use scp comand from the comand line example "scp -P (port) /file/to/send username@remote:/where/to/put" for example I believe I used "scp -P 2222 C:/(..).jar dataiku@127.0.0.1:/dss/lib/JDBC" or something along those lines.

also when you try to do the connection with the database administrator be sure to not put 127.0.0.1 as the host, but the ip (i think is) 10.0.2.2 that appears on top of the vm terminal when DSS is up
0 Kudos
Level 2
I try this command
"scp -P 2222 c:/mysql-connector-java-6.0.6/mysql-connector-java-6.0.6-bin.jar dataiku@localhost:/dss/lib/JDBC"

It show
ssh: Could not resolve hostname c: Name or service not known

I am not sure, but it may mean it cannot find my pc?
(I use SSH command through google chrome)
0 Kudos
Level 3
Have you tried with "C" upper case, it might be because it is case sensitive.
0 Kudos
Level 2
I used to try, but it still same problem.

I am not sure but I try to connect dataiku before send the command
the command line is " [dataiku@localhost ~]$ "
is it correct?
0 Kudos
Level 3
Oh, no, it should be the comand line of your host machine (which I guess is windows) where your file is.
Should be something like
"C:/Lenovo/Username>"
0 Kudos
Level 2
ChangeLog/release notes: https://goo.gl/YnmXOs
Unable to parse destination: scp -P 2222 C:/mysql-connector-java-6.0.6/mysql-connector-java-6.0.6-bin.jar dataiku@localhost:/dss/lib/JDBC
NaCl plugin exited with status code 1.
(R)econnect, (C)hoose another connection, or E(x)it?

but if I do not connect to the destination first where can I put the password?

[FYI] I use 'Secure Shell' in google Chrome
0 Kudos
Level 3
Okey, I am no expert with Secure shell, but I found this:
https://stackoverflow.com/questions/21291634/255-error-when-using-ssh
https://bugs.chromium.org/p/chromium/issues/detail?id=216233
I hope this are useful,
For the question when you use scp and conects successfully, then you put the password to log into Dataiku's vm, after you introduce it correctly, then the file is copied.
0 Kudos
Level 2
I see. I may change the program for SSH and do this again.

I really thank you for your help.

Thank you a lot, larispardo.
0 Kudos
Level 3
No problem, hope it helped in some fashion.
0 Kudos
Labels (1)