graphite-dev team mailing list archive

[FRLinux <question186300@xxxxxxxxxxxxxxxxxxxxx>]

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

I have tried to setup graphite webapp 0.9.9 for MySQL rather than using sqlite3 and I am having some trouble diagnosing what is wrong. 

I have created a database in MySQL called graphite and a user called graphite will all permissions,  yet when i try to save data from the dashboard it fails with this error:

aceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py", line 99, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "/opt/graphite/webapp/graphite/dashboard/views.py", line 147, in save
    dashboard = Dashboard.objects.get(name=name)
  File "/usr/lib/python2.4/site-packages/django/db/models/manager.py", line 119, in get
    return self.get_query_set().get(*args, **kwargs)
  File "/usr/lib/python2.4/site-packages/django/db/models/query.py", line 301, in get
    num = len(clone)
  File "/usr/lib/python2.4/site-packages/django/db/models/query.py", line 82, in __len__
    self._result_cache = list(self.iterator())
  File "/usr/lib/python2.4/site-packages/django/db/models/query.py", line 239, in iterator
    for row in self.query.results_iter():
  File "/usr/lib/python2.4/site-packages/django/db/models/sql/query.py", line 284, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/usr/lib/python2.4/site-packages/django/db/models/sql/query.py", line 2347, in execute_sql
    cursor.execute(sql, params)
  File "/usr/lib/python2.4/site-packages/django/db/backends/sqlite3/base.py", line 201, in execute
    return Database.Cursor.execute(self, query, params)
OperationalError: no such table: dashboard_dashboard

Although when querying the MySQL server: 


mysql> use graphite

Database changed
mysql> show tables;
+----------------------------+
| Tables_in_graphite         |
+----------------------------+
| account_mygraph            | 
| account_profile            | 
| account_variable           | 
| account_view               | 
| account_window             | 
| auth_group                 | 
| auth_group_permissions     | 
| auth_message               | 
| auth_permission            | 
| auth_user                  | 
| auth_user_groups           | 
| auth_user_user_permissions | 
| dashboard_dashboard        | 
| dashboard_dashboard_owners | 
| django_admin_log           | 
| django_content_type        | 
| django_session             | 
| events_event               | 
| tagging_tag                | 
| tagging_taggeditem         | 
+----------------------------+


*************************** 9. row ***************************
                 Host: localhost
                 User: graphite
             Password: xxxxxxxxxx
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
     Create_view_priv: Y
       Show_view_priv: Y
  Create_routine_priv: Y
   Alter_routine_priv: Y
     Create_user_priv: Y
             ssl_type: 
           ssl_cipher: 
          x509_issuer: 
         x509_subject: 
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0

Have also set that in /opt/graphite.webapp/graphite/local_settings.py

DATABASE_ENGINE = 'mysql' 
DATABASE_NAME = 'graphite'
DATABASE_USER = 'graphite'
DATABASE_PASSWORD = 'xxxxxxx'
DATABASE_HOST = 'localhost'
DATABASE_PORT = '3306'

Also ran python manage.py syncdb but still no joy.

What am I missing?

Thanks in advance,
Steph

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