Home Forums Hortonworks Sandbox Netwoking Issue

This topic contains 14 replies, has 6 voices, and was last updated by  Sagar Prasad 3 weeks ago.

  • Creator
    Topic
  • #15027

    Todd Wilson
    Member

    Hi:

    I’ve read the other posts regarding networking and I’m still having issues.

    I’m trying to connect with ODBC from my laptop to the Sandbox running on Virtual Box. I’ve tried various network settings host-only/nat, host-only/bridged, bridged/bridged and a few others. I’m not a networking person, but I know that using the bridged connection on VMWare works for another company’s Hadoop “sandbox”. I’ve even tried using the VM version of the Horton Sandbox with no luck.

    The current ip I’m being told to connect to (Host-Only/Nat setup) is 192.168.56.102.

    The odbc error which I’m getting from the ThriftHiveClient is 10060.

    I can get to the sandbox from the browser where Virtual Box is running, but I’m unable to from my laptop.

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #58590

    Sagar Prasad
    Participant

    Even I am facing the same issue ODBC connection to HDP 2.1. Followed so many issues blog and tried with different user
    hive / hadoop / hue on different port 10000 & 10001 but still no luck.

    Mostly on 10000 port i am getting timedout error
    Driver Version: V1.4.8.1008

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][HiveODBC] (34) Error from Hive: ETIMEDOUT.

    TESTS COMPLETED WITH ERROR.

    and with 10001
    Driver Version: V1.4.8.1008

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][HiveODBC] (34) Error from Hive: No more data to read..

    TESTS COMPLETED WITH ERROR.

    Any help !!

    Collapse
    #50733

    Deepak Bitragunta
    Participant

    Hello Todd,

    Are you able to solve your problem ? I am facing the same issue with ODBC connection.

    Thanks,
    Deepak.

    Collapse
    #15050

    Todd Wilson
    Member

    I also had my firewall off and virus protection disabled when the driver was unresponsive. I’m wondering if there is something which needs to be added to the iptables file on the Linux box? Just a thought.. I’d still appreciate if someone could test this out to see if an ODBC connect is possible.

    –Todd

    Collapse
    #15049

    Todd Wilson
    Member

    Hell Ted:

    I’ve gotten a little bit farther so most people should be good, but I’m still having trouble using ODBC to connect to Hive. Just to be safe I removed the Hortonworks Sandbox from the VirtualBox Manager, deleted all the files and then reloaded it.

    I followed your instructions and here is what I can do.

    I can ping the ip address where the sandbox is running and I can access the sandbox through the web browser from both my laptop AND pc on the network.

    I can log on to the linux box using root/hadoop and access hive that way.

    *I still cannot access hive through the Hortonwork ODBC driver using port 10000 from either my laptop or my PC which is running VirtualBox.

    The thing is that I am not getting an error when trying to connect through the ODBC manager, but when testing the connection in the ODBC manager that process become unresponsive immediately and hangs indefinitely with the wait cursor showing and I eventually have to close it through the Task Manager.

    Host is set to the ip of the host: 192.168.1.7 in my case.
    Port :10000
    Database: default
    Advanced setting are their default settings:

    Row fetched per block: 10000
    Default string column length: 255
    Everything else unchecked.

    I should say that when I do end the process through Task Manager. I get this error returned from ODBC.

    Driver Version: V1.0.0.1009

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: Unknown: errno = 10053

    TESTS COMPLETED WITH ERROR.

    So, if possible I’d like to know if there might be an issue connecting to Hive on the Hortonworks sandbox using the ODBC driver? Thanks!!!

    Collapse
    #15038

    Todd Wilson
    Member

    Hello Tedr:

    Thank you for testing this. At least I know it is possible and I’m not going crazy. I’m starting to believe the issue is most likely with my machines now. I’m even more convinced now because I just tested my other connection to my other version of Hadoop running on VMWare and that thing isn’t working either!!! I guess it just is not my day. Something is messed up and now I’m pointing my finger back at myself. I’ll let you know how it turns out. Thank you again for your great assistance!!!

    Collapse
    #15037

    tedr
    Moderator

    Hi Todd,

    Ok, I’ve done some testing here and this is how we got it to work in VirtualBox. You will need two network interfaces in the Sandbox VM. Configure the first for host only with dhcp turned on (as mentioned in the sandbox instructions). Configure the second as a bridged interface bridged to the network interface that connects the PC to your network. You then should boot the sandbox, wait for it to fully come up and tell you where it thinks you should point your browser. click in the vm window and press the <alt>&plus;<f5> keys to get to a login prompt. Log in as root/hadoop. run an "ifconfig eht1" to get the ip address to connect your ODBC client to.

    I hope that this helps,
    Ted.

    Collapse
    #15036

    Todd Wilson
    Member

    If I just try to connect from my host pc to the virtual box I can connect through the web browser to the sandbox with no problem. However, I cannot connect through odbc. I can ping my ip, but I can’t telnet to the ip with the port 10000. I’ve use the MapR driver to test and also the Hortonworks ODBC driver and I can’t connect with either. I can log on to hive through the linux prompt and run a simple show databases so I know hive is running, but I just cannot figure out how to connect to this through ODBC.

    Could someone confirm that it is at least possible to create an ODBC connection to hive running on the virtual box? At least then I would know I’m not going crazy. Thank you.

    Here is the error I get back when trying to test the connection in the 64-bit Hortonworks driver.

    Driver Version: V1.0.0.1009
    Running connectivity tests…
    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: connect() failed: errno = 10061

    TESTS COMPLETED WITH ERROR.

    I guess I should say that although that I’m not a network person, however I’ve been able to connect through ODBC to Teradata, Vertica and Hadoop (not Hortonworks) all running on VMWare. I’ve always just selected bridge connection, ran ifconfig to get the ip, made sure I had the correct port in their odbc setup and they all seem to work. :/ I can also connect to the Netezza emulator which is not VMWare. This is my first time trying to use Virtual Box to connect to anything.

    I appreciate everyone’s help. I’m going to keep trying… :p

    Collapse
    #15035

    Todd Wilson
    Member

    Hello Carter and Tedr:

    Thank you both for your replies.

    Tedr – Thank you for the explanation with regards to host only. It makes perfect sense. I think my confusion was in the two adapters. Are they both needed? On VMWare you just set bridged only (at least for some other data sources I’ve conencted to). I had bridged and NAT setup, disabled windows firewall and my virus protection, but still no luck. I’ve tried to run netstat commands, but I can’t make any sense out of them. :p I did not see port 10000 anywhere which I would have expected because hive is running on that.

    Carter — My laptop’s processor doesn’t support virtualization so I have to run VirtualBox from my PC. :( I’m assuming once I change the NAT interface to bridged I would run ifconfig to find the ip address. I’m going to try this as that could be the problem in that I was always just using the original ip which was assigned.

    Thank you both for your help!

    Collapse
    #15034

    Carter Shanklin
    Participant

    Todd you could likely change the NAT interface to a bridged interface but will need to log in to the VM to determine what the IP address of the bridged interface is, it won’t be displayed on the console.

    Just for my curiosity, any reason you can’t run your client tool on your laptop or wherever else the VirtualBox VM is running?

    Thanks,

    Collapse
    #15032

    tedr
    Member

    HI Todd,

    Thanks for trying the Sandox.

    If you have the sandbox set to "host-only" in any fashion you’ll only be able to connect to from the box that the sandbox is running on. That is the definition of "host-only," as in the VM will only be seen on the host that it is running on. So you’ll need to use the bridged or NAT setting, and make sure that there is no firewall running that could be blocking the ports, or some other program using the ports.

    Thanks,
    Ted.

    Collapse
    #15031

    Todd Wilson
    Member

    Sorry about all the replies, but I kept getting 0 characters remaining when trying to paste the entire netstat entry. :/

    Collapse
    #15030

    Todd Wilson
    Member

    Persistent Routes:
    Network Address Netmask Gateway Address Metric
    169.254.0.0 255.255.0.0 192.168.1.3 1
    ===========================================================================

    IPv6 Route Table
    ===========================================================================
    Active Routes:
    If Metric Network Destination Gateway
    1 306 ::1/128 On-link
    22 276 fe80::/64 On-link
    12 276 fe80::/64 On-link
    18 276 fe80::/64 On-link
    19 276 fe80::/64 On-link
    18 276 fe80::553c:d9ed:5bf6:3966/128
    On-link
    19 276 fe80::8885:7536:e19b:fc57/128
    On-link
    22 276 fe80::997e:106b:3130:2188/128
    On-link
    12 276 fe80::b510:4ac7:7234:1e44/128
    On-link
    1 306 ff00::/8 On-link
    22 276 ff00::/8 On-link
    12 276 ff00::/8 On-link
    18 276 ff00::/8 On-link
    19 276 ff00::/8 On-link
    ===========================================================================
    Persistent Routes:
    None

    Collapse
    #15029

    Todd Wilson
    Member

    IPv4 Route Table
    ===========================================================================
    Active Routes:
    Network Destination Netmask Gateway Interface Metric
    0.0.0.0 0.0.0.0 192.168.1.1 192.168.1.5 20
    127.0.0.0 255.0.0.0 On-link 127.0.0.1 306
    127.0.0.1 255.255.255.255 On-link 127.0.0.1 306
    127.255.255.255 255.255.255.255 On-link 127.0.0.1 306
    169.254.0.0 255.255.0.0 On-link 169.254.57.102 276
    169.254.0.0 255.255.0.0 192.168.1.3 192.168.1.5 21
    169.254.57.102 255.255.255.255 On-link 169.254.57.102 276
    169.254.255.255 255.255.255.255 On-link 169.254.57.102 276
    192.168.1.0 255.255.255.0 On-link 192.168.1.5 276
    192.168.1.5 255.255.255.255 On-link 192.168.1.5 276
    192.168.1.255 255.255.255.255 On-link 192.168.1.5 276
    192.168.56.0 255.255.255.0 On-link 192.168.56.1 276
    192.168.56.1 255.255.255.255 On-link 192.168.56.1 276
    192.168.56.255 255.255.255.255 On-link 192.168.56.1 276
    192.168.111.0 255.255.255.0 On-link 192.168.111.1 276
    192.168.111.1 255.255.255.255 On-link 192.168.111.1 276
    192.168.111.255 255.255.255.255 On-link 192.168.111.1 276
    224.0.0.0 240.0.0.0 On-link 127.0.0.1 306
    224.0.0.0 240.0.0.0 On-link 192.168.56.1 276
    224.0.0.0 240.0.0.0 On-link 192.168.1.5 276
    224.0.0.0 240.0.0.0 On-link 169.254.57.102 276
    224.0.0.0 240.0.0.0 On-link 192.168.111.1 276
    255.255.255.255 255.255.255.255 On-link 127.0.0.1 306
    255.255.255.255 255.255.255.255 On-link 192.168.56.1 276
    255.255.255.255 255.255.255.255 On-link 192.168.1.5 276
    255.255.255.255 255.255.255.255 On-link 169.254.57.102 276
    255.255.255.255 255.255.255.255 On-link 192.168.111.1 276

    Collapse
    #15028

    Todd Wilson
    Member

    C:\Users\Todd>netstat -nr
    ===========================================================================
    Interface List
    12…00 25 64 eb da a9 ……Broadcom NetLink (TM) Gigabit Ethernet
    18…00 50 56 c0 00 01 ……VMware Virtual Ethernet Adapter for VMnet1
    19…00 50 56 c0 00 08 ……VMware Virtual Ethernet Adapter for VMnet8
    22…08 00 27 00 34 44 ……VirtualBox Host-Only Ethernet Adapter
    1………………………Software Loopback Interface 1
    13…00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter
    10…00 00 00 00 00 00 00 e0 Microsoft 6to4 Adapter
    11…00 00 00 00 00 00 00 e0 Teredo Tunneling Pseudo-Interface
    16…00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter #2
    17…00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter #3
    23…00 00 00 00 00 00 00 e0 Microsoft ISATAP Adapter #4
    ===========================================================================

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