How do I install the MySQL Driver on the VirtualBox?

Highlighted
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
Have you tried with "C" upper case, it might be because it is case sensitive.
0 Kudos
wtuntana
Level 2
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
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
Re: How do I install the MySQL Driver on the VirtualBox?
No problem, hope it helped in some fashion.
0 Kudos
Labels (1)