You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by murat migdisoglu <mu...@gmail.com> on 2014/08/25 19:52:05 UTC
connecting hiveserver2 through ssh tunnel - time out
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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@gmail.com>.
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 <ka...@gmail.com> 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 <mu...@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 <ka...@gmail.com>
> 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 <murat.migdisoglu@gmail.com
> >:
> >> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@gmail.com>.
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 <ka...@gmail.com> 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 <mu...@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 <ka...@gmail.com>
> 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 <murat.migdisoglu@gmail.com
> >:
> >> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@gmail.com>.
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 <ka...@gmail.com> 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 <mu...@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 <ka...@gmail.com>
> 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 <murat.migdisoglu@gmail.com
> >:
> >> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@gmail.com>.
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 <ka...@gmail.com> 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 <mu...@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 <ka...@gmail.com>
> 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 <murat.migdisoglu@gmail.com
> >:
> >> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
>> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
>> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
>> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
>> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by murat migdisoglu <mu...@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 <ka...@gmail.com> 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 <mu...@gmail.com>:
> > 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@gmail.com>:
> 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@gmail.com>:
> 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@gmail.com>:
> 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
Re: connecting hiveserver2 through ssh tunnel - time out
Posted by Kadir Sert <ka...@gmail.com>.
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 <mu...@gmail.com>:
> 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