How do I install the MySQL Driver on the VirtualBox?

UserBird
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
larispardo
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
wtuntana
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
larispardo
Level 3
Have you tried with "C" upper case, it might be because it is case sensitive.
0 Kudos
wtuntana
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
larispardo
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
wtuntana
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
larispardo
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
wtuntana
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
larispardo
Level 3
No problem, hope it helped in some fashion.
0 Kudos
Labels (1)
A banner prompting to get Dataiku DSS
Public