Home Forums Hortonworks Sandbox Issue on Tutorial 7

Tagged: 

This topic contains 4 replies, has 2 voices, and was last updated by  Carolus Holman 9 months, 1 week ago.

  • Creator
    Topic
  • #46931

    Carolus Holman
    Participant

    How to Install and Configure the Hortonworks ODBC driver on Windows 7, I am getting the following error when trying to connect the 64-BIT ODBC Driver after clicking the Test Connection Button: SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: connect() failed: errno = 10060. TESTS COMPLETED WITH ERROR.

    The host machine IP is 127.0.0.1

    ODBC Driver is v1.2.0.1005 64 Bit.
    Host IP: 192.168.56.101
    Port: 1000
    Hive Server 2
    User Name

    The user name it started with was “sandbox”, I have tried “hue” (Hue) and “root”

    I am using Oracle-VB
    1st adapter is NAT
    2nd is Host-Only

    Host Only Network Details: IPv4 Address: 192.168.56.1
    DHCP: 192.168.56.1
    Lower: 192.168.56.101
    upper: 192.168.56.110

    I have tried telnet to the IP but get no response. On port 10000.

    I have tried many different ways to connect, nothing is working, in every case i get the same error.

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #46938

    Carolus Holman
    Participant

    That worked flawlessly! I don’t think I could have figured that one out, thanks for your help.
    So ODBC Host 127.0.0.1
    Port 2200
    Also I changed the User to root.

    Collapse
    #46937

    Dave
    Moderator

    Hi Carolus,

    If you go into Oracle Virtual Box and highlight the sandbox, then go to settings and go to Network – if you click on the “Port Forwarding Tab” you will see that 10000 maps to port 2200 (by default)

    So you should point your ODBC driver at port 2200 on 127.0.0.1 and see if that works for you.

    Thanks

    Dave

    Collapse
    #46933

    Carolus Holman
    Participant

    Thanks Dave for your prompt response, however I am not following what you are saying. I can connect to the Sandbox on port 127.0.0.1:8888 and other utilities, I can telnet to 127.0.0.1 2222 no problem.

    I followed the instructions for the ODBC connection. The Host adapter IP address is different, when I try to change it, it goes back to the 192.168.56.1.

    What I think you are trying to tell me is that my Host machine is listening on the same port, therefore can’t forward the 192 ODBC request?
    How is this remedied?

    Thanks!

    Collapse
    #46932

    Dave
    Moderator

    Hi Carolus,

    This is because you are trying to connect to localhost on 127.0.0.1 and it is your machine which wont be listening on this.
    Oracle VirtualBox allows for port forwarding which works around this issue – if you look into the network configuration of the machine you will see the port forwarding and the port you need to use to telnet & connect the driver to.

    Let me know how you get on,

    Thanks

    Dave

    Collapse
Viewing 4 replies - 1 through 4 (of 4 total)