Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-1763

[dbquery] Autocomplete doesn't work for a new dbquery setup

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.5.0
    • Fix Version/s: 3.5.0
    • Component/s: app.editor
    • Labels:
      None

      Description

      After setting up the up with

      [rdbms]
      [[databases]]
      [[[mydb]]]
      engine=mysql
      host=192.168.202.1
      port=8889
      user=root
      password=root

      I can see a list of the databases on the UI but the autocomplete generates an HTTP 500.

      Stacktrace:

      192.168.202.1 - - [27/Nov/2013 07:21:50] "GET /rdbms/api/servers/mydb/databases/hue/tables HTTP/1.1" 500 -
      Traceback (most recent call last):
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/contrib/staticfiles/handlers.py", line 67, in _call_
      return self.application(environ, start_response)
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/wsgi.py", line 241, in _call_
      response = self.get_response(request)
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/base.py", line 179, in get_response
      response = self.handle_uncaught_exception(request, resolver, sys.exc_info())
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/base.py", line 228, in handle_uncaught_exception
      return callback(request, **param_dict)
      File "/home/hue/Development/hue/desktop/core/src/desktop/views.py", line 399, in serve_500_error
      return django.views.debug.technical_500_response(request, *exc_info)
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/base.py", line 111, in get_response
      response = callback(request, *callback_args, **callback_kwargs)
      File "/home/hue/Development/hue/apps/rdbms/src/rdbms/api.py", line 82, in tables
      'tables': db.get_tables(database)
      File "/home/hue/Development/hue/apps/rdbms/src/rdbms/server/dbms.py", line 87, in get_tables
      return self.client.get_tables(database)
      File "/home/hue/Development/hue/apps/rdbms/src/rdbms/server/mysql_lib.py", line 102, in get_tables
      cursor.execute("SHOW TABLES")
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.3c1-py2.7-linux-x86_64.egg/MySQLdb/cursors.py", line 173, in execute
      self.errorhandler(self, exc, value)
      File "/home/hue/Development/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.3c1-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
      OperationalError: (1046, 'No database selected')

        Attachments

          Activity

            People

            • Assignee:
              abe Abraham Elmahrek
              Reporter:
              enricoberti Enrico Berti
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: