How do I install the MySQL Driver on the VirtualBox?

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker

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,

Tagged:

Answers

  • larispardo
    larispardo Registered Posts: 28 ✭✭✭✭✭
    Options
    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
  • wtuntana
    wtuntana Registered Posts: 10 ✭✭✭✭
    Options
    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)
  • larispardo
    larispardo Registered Posts: 28 ✭✭✭✭✭
    Options
    Have you tried with "C" upper case, it might be because it is case sensitive.
  • wtuntana
    wtuntana Registered Posts: 10 ✭✭✭✭
    Options
    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?
  • larispardo
    larispardo Registered Posts: 28 ✭✭✭✭✭
    Options
    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>"
  • wtuntana
    wtuntana Registered Posts: 10 ✭✭✭✭
    Options
    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
  • larispardo
    larispardo Registered Posts: 28 ✭✭✭✭✭
    Options
    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.
  • wtuntana
    wtuntana Registered Posts: 10 ✭✭✭✭
    Options
    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.
  • larispardo
    larispardo Registered Posts: 28 ✭✭✭✭✭
    Options
    No problem, hope it helped in some fashion.
Setup Info
    Tags
      Help me…