Sharing how to solve HUE and HBase connect problem on CDH 6.0.1

[#1]

Hi there,

Recently, we faced a problem: our Hue can't connect to our Hbase on CDH 6.0.1

Later, we had other task which need python(happyhbase) to do the operation on hbase.

We recieved: "No protocol version header error"

Finally, we resolved both problem at same time.

First of all, I have to declare this: we opened hbase thrift server before the above two issue happened.

Then, the default HBase setting in CM:

hbase.regionserver.thrift.http

and

hbase.thrift.support.proxyuser

They was checked. In /etc/hbase/conf/hbase-sit.xml, Their values are "true"

We found a link: https://github.com/wbolster/happybase/issues/161

So, we unchecked both of them. ( In hbase-sit.xml, They become "false" )

And two problems solevd.

I saw a lot people had this issue, I hope my sharing will be helpful.

[#2]

Thanks!

[#3]

Thanks for sharing!!

[#4]

Thanks. That solved some problems for me too. Been at it for a few days now.

After changing the settings i no longers get the TTransport exceptions, but now Hue seems to not be able to authenticate with Hbase. Can you share your authentication settings? 
I have HBase Thrift Authentication set to none and all the groups, hosts, users settings are set to *.

Hbase log: 

ERROR Failed to authenticate to HBase Thrift Server, check authentication configurations.
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-6.0.1-1.cdh6.0.1.p0.590678/lib/hue/apps/hbase/src/hbase/conf.py", line 88, in config_validator
api.getTableList(cluster_name)
File "/opt/cloudera/parcels/CDH-6.0.1-1.cdh6.0.1.p0.590678/lib/hue/apps/hbase/src/hbase/api.py", line 142, in getTableList
return [{'name': name, 'enabled': client.isTableEnabled(name, doas=self.user.username)} for name in client.getTableNames(doas=self.user.username)]
File "/opt/cloudera/parcels/CDH-6.0.1-1.cdh6.0.1.p0.590678/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 413, in wrapper
raise StructuredException('THRIFTSOCKET', str(e), data=None, error_code=502)
StructuredException: timed out (code THRIFTSOCKET): None

Thank you!

[#5]

Hi minsirv,

Unfortunately, we didn't involve to much about HBase Thrift Authentication.

But Let me share one more thing about HUE Authentication.

HUE default account is "admin", this account maybe cause some permission decline problem.

Please try to set account such as "hive" in HUE, and avoid using "admin".

Hope this poor experience can help you.