Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

New Hue user is not able to see database

New Hue user is not able to see database

I created new users in Hue, Old users can access all the database but new users can't see any database.

Below is the error log from hue error.log

[06/Jan/2019 19:35:55 +0530] middleware   ERROR    Could not audit the request: [Errno 2] No such file or directory: '/var/local/hue/logs/audit.log'
[06/Jan/2019 19:36:19 +0530] exceptions_renderable ERROR    Potential trace: [('/usr/local/hue/desktop/libs/libsolr/src/libsolr/', 758, 'info_system', "response = self._root.get('admin/info/system', params=params)"), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/', 126, 'get', 'return self.invoke("GET", relpath, params, headers=headers, allow_redirects=True, clear_cookies=clear_cookies)'), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/', 80, 'invoke', 'log_response=log_response)'), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/', 99, '_invoke', 'clear_cookies=clear_cookies)'), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/', 215, 'execute', 'raise self._exc_class(ex)')]
[06/Jan/2019 19:36:19 +0530] exceptions_renderable ERROR    Potential detail: HTTPConnectionPool(host='localhost', port=8983): Max retries exceeded with url: /solr/admin/info/system? (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x2aab3ef50d90>: Failed to establish a new connection: [Errno 111] Connection refused',))
[06/Jan/2019 19:36:19 +0530] exceptions_renderable ERROR    Potential trace: [('/usr/local/hue/desktop/libs/indexer/src/indexer/', 65, 'get_indexes', 'if self.is_solr_cloud_mode():'), ('/usr/local/hue/desktop/libs/indexer/src/indexer/', 223, 'is_solr_cloud_mode', 'self._fillup_properties()'), ('/usr/local/hue/desktop/libs/indexer/src/indexer/', 322, '_fillup_properties', 'properties = self.api.info_system()'), ('/usr/local/hue/desktop/libs/libsolr/src/libsolr/', 761, 'info_system', "raise PopupException(e, title=_('Error while accessing Solr'))")]
[06/Jan/2019 19:36:19 +0530] decorators   ERROR    Error running autocomplete
Traceback (most recent call last):
  File "/usr/local/hue/desktop/libs/notebook/src/notebook/", line 97, in decorator
    return func(*args, **kwargs)
  File "/usr/local/hue/desktop/libs/notebook/src/notebook/", line 567, in autocomplete
    autocomplete_data = get_api(request, snippet).autocomplete(snippet, database, table, column, nested)
  File "/usr/local/hue/desktop/libs/notebook/src/notebook/connectors/", line 47, in decorator
    raise QueryError(message)


Re: New Hue user is not able to see database

Expert Contributor

@Harish More

Please can you confirm whether new user having appropriate permission to access all database like old user, you can check all defined policies in Ranger/Sentry depend on your cluster security access configuration.


Re: New Hue user is not able to see database

Hi @Jagadeesan A S

Yes the new users has proper permission in Ranger. Have enough permission to access all database.

Don't have an account?
Coming from Hortonworks? Activate your account here