Hello,
I am facing an issue when trying to use an internal MySQL database as the desktop database, as configured in hue.ini
However, when I use the below configuration, I get an error below. I know that the MySQL database (huedb) exists, so I am not really sure on how to move forward.
Configuration
[[database]]
engine = mysql
name = huedb
case_insensitive_collation = utf8_unicode_ci
test_charset = utf8
host = our-dns-name
port = 3306
user = hue
password = our-password
Error
Traceback (most recent call last):
File “/usr/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py”, line 1228, in communicate
req.respond()
File “/usr/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py”, line 589, in respond
self._respond()
File “/usr/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py”, line 601, in _respond
response = self.wsgi_app(self.environ, self.start_response)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/wsgi.py”, line 157, in call
response = self.get_response(request)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/base.py”, line 140, in get_response
response = self.handle_uncaught_exception(request, get_resolver(get_urlconf()), sys.exc_info())
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/base.py”, line 234, in handle_uncaught_exception
return handle_uncaught_exception(request, resolver, exc_info)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/exception.py”, line 143, in handle_uncaught_exception
return callback(request, **param_dict)
File “/usr/lib/hue/desktop/core/src/desktop/views.py”, line 429, in serve_500_error
return render(“500.mako”, request, {‘traceback’: traceback.extract_tb(exc_info[2])})
File “/usr/lib/hue/desktop/core/src/desktop/lib/django_util.py”, line 241, in render
**kwargs
File “/usr/lib/hue/desktop/core/src/desktop/lib/django_util.py”, line 154, in _render_to_response
return django_mako.render_to_response(template, *args, **kwargs)
File “/usr/lib/hue/desktop/core/src/desktop/lib/django_mako.py”, line 127, in render_to_response
return HttpResponse(render_to_string(template_name, data_dictionary), **kwargs)
File “/usr/lib/hue/desktop/core/src/desktop/lib/django_mako.py”, line 116, in render_to_string_normal
result = template.render(**data_dict)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/template.py”, line 462, in render
return runtime.render(self, self.callable, args, data)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 838, in _render
**kwargs_for_callable(callable, data))
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 873, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Mako-1.0.7-py2.7.egg/mako/runtime.py”, line 899, in exec_template
callable(context, *args, **kwargs)
File “/tmp/tmpkWQK6u/desktop/500.mako.py”, line 90, in render_body
__M_writer(unicode( commonfooter(request, messages) ))
File “/usr/lib/hue/desktop/core/src/desktop/views.py”, line 559, in commonfooter
hue_settings = Settings.get_settings()
File “/usr/lib/hue/desktop/core/src/desktop/models.py”, line 131, in get_settings
settings, created = Settings.objects.get_or_create(id=1)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/manager.py”, line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py”, line 464, in get_or_create
return self.get(**lookup), False
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py”, line 374, in get
num = len(clone)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py”, line 232, in len
self._fetch_all()
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py”, line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py”, line 53, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File “/usr/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
ProgrammingError: (1146, “Table ‘huedb.desktop_settings’ doesn’t exist”)