Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-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 3EB17119D9 for ; Tue, 26 Aug 2014 09:56:16 +0000 (UTC) Received: (qmail 1972 invoked by uid 500); 26 Aug 2014 09:56:11 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 1834 invoked by uid 500); 26 Aug 2014 09:56:11 -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 1815 invoked by uid 99); 26 Aug 2014 09:56:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Aug 2014 09:56:10 +0000 X-ASF-Spam-Status: No, hits=-0.5 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kadirsert80@gmail.com designates 209.85.220.169 as permitted sender) Received: from [209.85.220.169] (HELO mail-vc0-f169.google.com) (209.85.220.169) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Aug 2014 09:56:06 +0000 Received: by mail-vc0-f169.google.com with SMTP id le20so16885412vcb.0 for ; Tue, 26 Aug 2014 02:55:45 -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=t8YMPNaGtAuDJAiGE9kXasov4veBIKLQ9Wm5zg4yN64=; b=FHcybIgnB7syA6d+vtLcs+/Xw0cSL8Acw+ZrvigKez0qTkpsrHhKczmbHH4IxG1Ret 0WFrUvTfZkFZWFO1olHOmtBVCVmJz4oN3i2BoGpSTKDHYJDl4AV9G/ee+38fBA00q52/ XAoy3uQxYa5cGHf/5ZqLAqfbHJEIugV7CjCgzfwDHP/an9dYeRQMvm6Cso0l64pkeRvQ +OfwT159dNVKwwLyTD2gQ3sQTBHegMqmb3gBDODBrMdR36af0YNJUQUZtngrZEqy3cA5 wFRXZv1wshC9DU4vSF5v8UMUrYYdwaM2blG7MTLq9ObLZexb/7mKbonKx94qAuCmTsCy qVnQ== MIME-Version: 1.0 X-Received: by 10.52.97.233 with SMTP id ed9mr13180519vdb.16.1409046945515; Tue, 26 Aug 2014 02:55:45 -0700 (PDT) Received: by 10.220.5.134 with HTTP; Tue, 26 Aug 2014 02:55:45 -0700 (PDT) In-Reply-To: References: Date: Tue, 26 Aug 2014 12:55:45 +0300 Message-ID: Subject: Re: connecting hiveserver2 through ssh tunnel - time out From: Kadir Sert To: user@hadoop.apache.org Content-Type: text/plain; charset=UTF-8 X-Virus-Checked: Checked by ClamAV on apache.org 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