question Re: Hue configuration Error | Beewax | File Browser in Support Questions

Hue configuration Error | Beewax | File Browser

Nilesh — Tue, 29 Dec 2015 16:55:32 GMT

Hi Team,

I am facing following errors while browsing Hive UI and and File browser in Hue.

HiveUI Error -

QueryServerException at /beeswax/ Bad status for request TOpenSessionReq(username='hue', password='hue', client_protocol=4, configuration={'hive.server2.proxy.user': u'admin'}): TOpenSessionResp(status=TStatus(errorCode=0, errorMessage='Failed to open new session:

File Browser Error -

WebHdfsException at /filebrowser/ SecurityException: Failed to obtain user group information: org.apache.hadoop.security.authorize.AuthorizationException: User: hue is not allowed to impersonate admin (error 403)

Note : - Installation and configuration for Hue has been done using below URL

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-...

Re: Hue configuration Error | Beewax | File Browser

pardeep_kumar — Tue, 29 Dec 2015 18:35:11 GMT

Issue is related to impersonation. Ensure to follow these steps here.

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_installing_manually_book/content/configure_hdp_hue.html

Re: Hue configuration Error | Beewax | File Browser

Nilesh — Tue, 29 Dec 2015 19:31:10 GMT

Pradeep,

There are multiple hive-site.xml files found which one we can use to do hue configuration.

1./etc/hive/2.3.2.0-2950/0

2./etc/hive/conf

3./etc/hive/conf.install

Re: Hue configuration Error | Beewax | File Browser

SQLShaw — Tue, 29 Dec 2015 22:55:13 GMT

Try echo $HIVE_CONF_DIR and view the output. It shoudl be /etc/hive/conf

Re: Hue configuration Error | Beewax | File Browser

Matthew_Sharp — Tue, 29 Dec 2015 23:39:24 GMT

The hue proxy hosts/groups can easily be managed with Ambari, you will need to add properties within the HDFS, Oozie and Hive service configurations and then ensure those are pushed out to your hosts.

Re: Hue configuration Error | Beewax | File Browser

pardeep_kumar — Wed, 30 Dec 2015 07:48:04 GMT

@Nilesh Do it through Ambari, don't worry about these multiple hive-site.xml. In Hue.ini, its should be /etc/hive/conf

Re: Hue configuration Error | Beewax | File Browser

SK1 — Wed, 27 Jan 2016 00:56:56 GMT

Hi ,

I am also facing same issue and tried above solution with ambari, but unfortunately it did not work. So any other help please.

 raise QueryServerException(Exception('Bad status for request %s:\n%s' % (req, res)), message=message)

QueryServerException: Bad status for request TOpenSessionReq(username='hue', password='hue', client_protocol=4, configuration={'hive.server2.proxy.user': u'hue'}):

TOpenSessionResp(status=TStatus(errorCode=0, errorMessage='Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Unauthorized connection for super-user: hive from IP 192.168.56.42', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Unauthorized connection for super-user: hive from IP 192.168.56.42:13:12', 'org.apache.hive.service.cli.session.SessionManager:openSession:SessionManager.java:266', 'org.apache.hive.service.cli.CLIService:openSessionWithImpersonation:CLIService.java:202', 'org.apache.hive.service.cli.thrift.ThriftCLIService:getSessionHandle:ThriftCLIService.java:402', 'org.apache.hive.service.cli.thrift.ThriftCLIService:OpenSession:ThriftCLIService.java:297', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1253', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1238', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:ru

Re: Hue configuration Error | Beewax | File Browser

pd47 — Thu, 28 Jan 2016 03:32:11 GMT

make this change and will work.

hadoop.proxyuser.hive.groups = *

Re: Hue configuration Error | Beewax | File Browser

SK1 — Tue, 02 Feb 2016 17:04:43 GMT

Hi PD, Thanks for your reply. I ad same value for hadoop.proxyuser.hive.groups and still was facing issue.

Actually I upgraded my HDP stack from 2.2 to 2.3 so because and I did not syncdb for hue. On ce I did that it solved my issue.

If you are getting above error then try to update hue config with following command. /usr/lib/hue/build/env/bin/hue syncdb --noinput it will update your hue files.

[root@m1 hue]# build/env/bin/hue syncdb --noinput

Syncing...

Re: Hue configuration Error | Beewax | File Browser

aervits — Tue, 02 Feb 2016 20:10:46 GMT

Why not use Ambari Views, Hue is deprecated in HDP 2.3 @Saurabh Kumar

Re: Hue configuration Error | Beewax | File Browser

SK1 — Mon, 08 Feb 2016 13:42:25 GMT

Yes,you are right @artem Evits we should use views but for that we should have a dedicated server which would manage views,otherwise it may create overload on our ambari servers and we do some changes and restart ambari then users also may get impacted.

Re: Hue configuration Error | Beewax | File Browser

divakarreddy_a — Mon, 08 Feb 2016 14:03:23 GMT

Can you cross check webhdfs_url propertie in hue.conf

webhdfs_url=http://NameNodeHost:14000/webhdfs/v1/

# webhdfs_url=http://NN Host:50070/webhdfs/v1/

Can you check hadoop-httpfs status?

Re: Hue configuration Error | Beewax | File Browser

SK1 — Mon, 08 Feb 2016 14:24:09 GMT

Divakar: Thanks for your consideration, but as I have mentioned above problem has been resolved by running build/env/bin/hue syncdb --noinput

Re: Hue configuration Error | Beewax | File Browser

divakarreddy_a — Mon, 08 Feb 2016 14:47:16 GMT

Thanks for informing me the correct solution.

Re: Hue configuration Error | Beewax | File Browser

aervits — Mon, 08 Feb 2016 21:06:57 GMT

Our best practice is to have a dedicated ambai views server (standalone) separate from Ambari server node. You can add more Ambari Views servers by the way and Hue is in the same situation I'd it goes down impact felt by everyone. @Saurabh Kumar please refer to ambai views user guide http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_ambari_views_guide/content/ch_using_ambari_views.html