Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 534FB11BF5 for ; Wed, 27 Aug 2014 05:46:43 +0000 (UTC) Received: (qmail 64785 invoked by uid 500); 27 Aug 2014 05:46:35 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 64669 invoked by uid 500); 27 Aug 2014 05:46:35 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 64659 invoked by uid 99); 27 Aug 2014 05:46:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2014 05:46:35 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of murat.migdisoglu@gmail.com designates 209.85.213.53 as permitted sender) Received: from [209.85.213.53] (HELO mail-yh0-f53.google.com) (209.85.213.53) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2014 05:46:31 +0000 Received: by mail-yh0-f53.google.com with SMTP id c41so13052711yho.12 for ; Tue, 26 Aug 2014 22:46:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=XUS4C9m+TubZVxnEYLh0KWISlFAnxH13WyWaQj3/S9k=; b=moOmz1Bo/CdBqaPlc01u8zu8Qp/WlWO48btMHbVPhFh5ooH/gK3O0SoCpi05oq6Cfn i00kls2tIWPMoDuD1iS/ful1YpBOuJQ47895a+K62l5SG1AwumON7qc3983OpFQbFT69 5nFDAsRdOuP1fNnFoQz2I9aPg2BWrEUiL7xb0ZPCPAVBsH0ehAYlyylLg1wbFZP1fiW0 yY5rePKNLr6C974AIMUTNps0yKqLC/gkNfmez3Ublai2L5YOmA5/dhUjq+n7JzcAfEnE ZuJ/Zr8ni2ns2kedL74UkO1TBkWx4o01+XG5YzOaLbeD7Y5pg4ddPcetAVL1zFmjZmxz NhdA== MIME-Version: 1.0 X-Received: by 10.220.182.73 with SMTP id cb9mr27239228vcb.9.1409118370078; Tue, 26 Aug 2014 22:46:10 -0700 (PDT) Received: by 10.221.62.74 with HTTP; Tue, 26 Aug 2014 22:46:09 -0700 (PDT) In-Reply-To: References: Date: Wed, 27 Aug 2014 08:46:09 +0300 Message-ID: Subject: Re: connecting hiveserver2 through ssh tunnel - time out From: murat migdisoglu To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=001a1132f17ee54d00050195efff X-Virus-Checked: Checked by ClamAV on apache.org --001a1132f17ee54d00050195efff Content-Type: text/plain; charset=ISO-8859-1 Hello, I solved the problem by tunneling ports 10000 and 8021. But besides that, the ugly odbc of the ugly windows uses the ugly registries to keep the url of the the webhdfs.. Thus regedit and change HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/[systemdsn]/WEBHDFSHost to localhost.. That did the trick.. Thx for your support Cheers On Tue, Aug 26, 2014 at 12:55 PM, Kadir Sert wrote: > http://community.jaspersoft.com/jaspersoft-aws/connect-emr > > I think that's because of hive version. > > 2014-08-26 12:13 GMT+03:00 murat migdisoglu : > > Hi, thx for your answer. I don't think that ssh tunnel is the issue(btw, > why > > port 10004 and not 10000?) > > > > > > Does ODBC driver connects to any other port?service(hive metastore etc..) > > > > > > On Tue, Aug 26, 2014 at 9:55 AM, Kadir Sert > wrote: > >> > >> Hi, > >> > >> could you please try, > >> > >> ssh -o ServerAliveInterval=10 -L 10004:localhost:10004 murat@10.0.0.100 > >> > >> > >> > >> 2014-08-25 20:52 GMT+03:00 murat migdisoglu >: > >> > Hello, > >> > > >> > Due to some firewall restrictions, I need to connect from tableau to > the > >> > hiveserver2 through ssh tunnel.. > >> > > >> > I tried tunneling from port range 10000 -10004 but tableau still times > >> > out.. > >> > > >> > my hiveserver2 is running on 10.0.0.100 and I'm on 192. network. > >> > > >> > I tried > >> > ssh murat@10.0.0.100 -L 10000:localhost:10000 and configured tableau > to > >> > connect to localhost:10000 with no success.. > >> > > >> > What am I missing? > >> > > >> > Thanks > > > > > > > > > > -- > > "Find a job you enjoy, and you'll never work a day in your life." > > Confucius > -- "Find a job you enjoy, and you'll never work a day in your life." Confucius --001a1132f17ee54d00050195efff Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hello,=A0

I solved the problem by tunne= ling ports 10000 and 8021.=A0

But besides that, th= e ugly odbc of the ugly windows uses the ugly registries to keep the url of= the the webhdfs.. Thus regedit and change
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/[systemdsn]/WEBHDFSHost to l= ocalhost..=A0

That did the trick..

<= /div>
Thx for your support

Cheers



On Tue, Aug 26, 2014 at 12:55 PM, Kadir Sert <kadirsert80@gmail.com= > wrote:
http://community.jaspersoft.co= m/jaspersoft-aws/connect-emr

I think that's because of hive version.

2014-08-26 12:13 GMT+03:00 murat migdisoglu <murat.migdisoglu@gmail.com>:
> Hi, thx for your answer. I don= 't think that ssh tunnel is the issue(btw, why
> port 10004 and not 10000?)
>
>
> Does ODBC driver connects to any other port?service(hive metastore etc= ..)
>
>
> On Tue, Aug 26, 2014 at 9:55 AM, Kadir Sert <kadirsert80@gmail.com> wrote:
>>
>> Hi,
>>
>> could you please try,
>>
>> ssh -o ServerAliveInterval=3D10 -L 10004:localhost:10004 murat@10.0.0.100
>>
>>
>>
>> 2014-08-25 20:52 GMT+03:00 murat migdisoglu <murat.migdisoglu@gmail.com>:
>> > Hello,
>> >
>> > Due to some firewall restrictions, I need to connect from tab= leau to the
>> > hiveserver2 through ssh tunnel..
>> >
>> > I tried tunneling from port range 10000 -10004 but tableau st= ill times
>> > out..
>> >
>> > my hiveserver2 is running on 10.0.0.100 and I'm on 192. n= etwork.
>> >
>> > I tried
>> > ssh murat@10.0.0.100 = -L 10000:localhost:10000 and configured tableau to
>> > connect to localhost:10000 with no success..
>> >
>> >=A0 What am I missing?
>> >
>> > Thanks
>
>
>
>
> --
> "Find a job you enjoy, and you'll never work a day in your li= fe."
> Confucius



--
= "Find a job you enjoy, and you'll never work a day in your life.&q= uot;
Confucius
--001a1132f17ee54d00050195efff--