New question #197624 on Graphite:
https://answers.launchpad.net/graphite/+question/197624

I need to setup a MySQL database for Graphite, as we will be clustering 3 
servers.  I set up the database following the commented examples in 
local_settings.py (of course I created the database first using MySQL), then 
ran manage.py syncdb.

This succeeds, but actually creates the database in sqlite.  When I hit the 
graphite web page, I see the following exception:

Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py", line 
101, in get_response
    request.path_info)
  File "/usr/lib/python2.7/site-packages/django/core/urlresolvers.py", line 
252, in resolve
    sub_match = pattern.resolve(new_path)
  File "/usr/lib/python2.7/site-packages/django/core/urlresolvers.py", line 
158, in resolve
    return ResolverMatch(self.callback, args, kwargs, self.name)
  File "/usr/lib/python2.7/site-packages/django/core/urlresolvers.py", line 
164, in _get_callback
    self._callback = get_callable(self._callback_str)
  File "/usr/lib/python2.7/site-packages/django/utils/functional.py", line 124, 
in wrapper
    result = func(*args)
  File "/usr/lib/python2.7/site-packages/django/core/urlresolvers.py", line 91, 
in get_callable
    lookup_view = getattr(import_module(mod_name), func_name)
  File "/usr/lib/python2.7/site-packages/django/utils/importlib.py", line 35, 
in import_module
    __import__(name)
  File "/opt/graphite/webapp/graphite/browser/views.py", line 20, in <module>
    from graphite.util import getProfile, getProfileByUsername, defaultUser, 
json
  File "/opt/graphite/webapp/graphite/util.py", line 55, in <module>
    defaultUser = User.objects.get(username='default')
  File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 
132, in get
    return self.get_query_set().get(*args, **kwargs)
  File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 344, 
in get
    num = len(clone)
  File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 82, 
in __len__
    self._result_cache = list(self.iterator())
  File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 273, 
in iterator
    for row in compiler.results_iter():
  File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", 
line 680, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", 
line 735, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/python2.7/site-packages/django/db/backends/mysql/base.py", 
line 86, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib/python2.7/site-packages/MySQLdb/cursors.py", line 174, in 
execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in 
defaulterrorhandler
    raise errorclass, errorvalue
DatabaseError: (1146, "Table 'graphite.auth_user' doesn't exist")

I guess this is a bug, but I'm hoping an answer will be forthcoming.

We are running Graphite 0.9.10, installed via pip.

Thanks,
Steve Keller
skel...@ea.com

-- 
You received this question notification because you are a member of
graphite-dev, which is an answer contact for Graphite.

_______________________________________________
Mailing list: https://launchpad.net/~graphite-dev
Post to     : graphite-dev@lists.launchpad.net
Unsubscribe : https://launchpad.net/~graphite-dev
More help   : https://help.launchpad.net/ListHelp

Reply via email to