Support Questions
Find answers, ask questions, and share your expertise

New Hue user is not able to see database

Highlighted

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/api.py', 758, 'info_system', "response = self._root.get('admin/info/system', params=params)"), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/resource.py', 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/resource.py', 80, 'invoke', 'log_response=log_response)'), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/resource.py', 99, '_invoke', 'clear_cookies=clear_cookies)'), ('/usr/local/hue/desktop/core/src/desktop/lib/rest/http_client.py', 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?user.name=hue&doAs=anurag.srivastava&wt=json (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/solr_client.py', 65, 'get_indexes', 'if self.is_solr_cloud_mode():'), ('/usr/local/hue/desktop/libs/indexer/src/indexer/solr_client.py', 223, 'is_solr_cloud_mode', 'self._fillup_properties()'), ('/usr/local/hue/desktop/libs/indexer/src/indexer/solr_client.py', 322, '_fillup_properties', 'properties = self.api.info_system()'), ('/usr/local/hue/desktop/libs/libsolr/src/libsolr/api.py', 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/decorators.py", line 97, in decorator
    return func(*args, **kwargs)
  File "/usr/local/hue/desktop/libs/notebook/src/notebook/api.py", 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/solr.py", line 47, in decorator
    raise QueryError(message)
QueryError


2 REPLIES 2

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.

Highlighted

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.