OperationalError: unable to open database file

Any ideas as to what the cause of this might be?

Is it another directory permission issue? Which dir? What should the permission be?

Thanks in advance.

-Jac

Did you run manage.py syncdb ?

Oh, I had no idea I had to run that command. Ok, I ran it with "sudo" and it produced this:

Creating tables ...
Creating table account_profile
Creating table account_variable
Creating table account_view
Creating table account_window
Creating table account_mygraph
Creating table dashboard_dashboard_owners
Creating table dashboard_dashboard
Creating table events_event
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_session
Creating table django_admin_log
Creating table django_content_type
Creating table tagging_tag
Creating table tagging_taggeditem

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (Leave blank to use 'root'):
E-mail address: jac@localhost
Password:
Password (again):
Superuser created successfully.
Installing custom SQL ...
Installing indexes ...
No fixtures found.

After that /opt/graphite/storage/graphite.db is created (owned by root:root).

Back to the webapp and refreshed the page and now get a different error:

  File "/usr/lib/pymodules/python2.7/django/db/backends/sqlite3/base.py", line 234, in execute
    return Database.Cursor.execute(self, query, params)
DatabaseError: attempt to write a readonly database

So, what's next? Am I still missing some file permission issues somewhere? Should graphite.db belong to apache2 user:group? Just for kicks I did that and it gave me "Unable to open database file" error again, so I switched it back to root:root.

Please advise.

Thank you again for all your help.

-Jac

Nicholas, thanks for your reply. There's no user named "graphite" on my Ubuntu 11.10 server, but I had a hunch you meant to say the Apache user (www-data). So I made the following changes:

sudo chown www-data:www-data /opt/graphite/storage/
sudo chown www-data:www-data /opt/graphite/storage/graphite.db
sudo chown www-data:www-data /opt/graphite/storage/index

...and now the graphite home page comes up! Excellent! Thanks a bunch for everyone's help.

A follow-up question... Should everything under /opt/graphite/storage be owned by the Apache user?

Currently lists, log, rrd, whisper subdirs are still owned by root. Should they be owned by Apache user as well?

Thanks.

-Jac

Yea, you may want to just chown -R www-data:www-data /opt/graphite.

Joseph Schmoley <email address hidden> wrote:

>Question #178172 on Graphite changed:
>https://answers.launchpad.net/graphite/+question/178172
>
> Status: Answered => Solved
>
>Joseph Schmoley confirmed that the question is solved:
>Nicholas, thanks for your reply. There's no user named "graphite" on my
>Ubuntu 11.10 server, but I had a hunch you meant to say the Apache user
>(www-data). So I made the following changes:
>
>sudo chown www-data:www-data /opt/graphite/storage/
>sudo chown www-data:www-data /opt/graphite/storage/graphite.db
>sudo chown www-data:www-data /opt/graphite/storage/index
>
>...and now the graphite home page comes up! Excellent! Thanks a bunch
>for everyone's help.
>
>A follow-up question... Should everything under /opt/graphite/storage
>be owned by the Apache user?
>
>Currently lists, log, rrd, whisper subdirs are still owned by root.
>Should they be owned by Apache user as well?
>
>Thanks.
>
>-Jac
>
>--
>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 : <email address hidden>
>Unsubscribe : https://launchpad.net/~graphite-dev
>More help : https://help.launchpad.net/ListHelp

Thanks Nicholas Leskiw, that solved my question.

hi can any body explain what this error is
Traceback:
File "/usr/lib/pymodules/python2.7/django/core/handlers/base.py" in get_response
  178. response = middleware_method(request, response)
File "/usr/lib/pymodules/python2.7/django/contrib/sessions/middleware.py" in process_response
  36. request.session.save()
File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py" in save
  56. session_key = self.session_key,
File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py" in _get_session_key
  175. self._session_key = self._get_new_session_key()
File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py" in _get_new_session_key
  167. if not self.exists(session_key):
File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py" in exists
  29. Session.objects.get(session_key=session_key)
File "/usr/lib/pymodules/python2.7/django/db/models/manager.py" in get
  132. return self.get_query_set().get(*args, **kwargs)
File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in get
  344. num = len(clone)
File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in __len__
  82. self._result_cache = list(self.iterator())
File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in iterator
  273. for row in compiler.results_iter():
File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in results_iter
  680. for rows in self.execute_sql(MULTI):
File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in execute_sql
  734. cursor = self.connection.cursor()
File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py" in cursor
  250. cursor = self.make_debug_cursor(self._cursor())
File "/usr/lib/pymodules/python2.7/django/db/backends/sqlite3/base.py" in _cursor
  207. self.connection = Database.connect(**kwargs)

Exception Type: OperationalError at /auth/login/
Exception Value: unable to open database file

As a start i'd recommend either running the django syncdb or perhaps the
sqlite file has the wrong ownership / permissions. Could potentially be
another cause but that is an initial suggestion.
On Mar 18, 2012 8:57 PM, "sanjaya dahal" <
<email address hidden>> wrote:

> Question #178172 on Graphite changed:
> https://answers.launchpad.net/graphite/+question/178172
>
> sanjaya dahal posted a new comment:
> hi can any body explain what this error is
> Traceback:
> File "/usr/lib/pymodules/python2.7/django/core/handlers/base.py" in
> get_response
> 178. response = middleware_method(request, response)
> File "/usr/lib/pymodules/python2.7/django/contrib/sessions/middleware.py"
> in process_response
> 36. request.session.save()
> File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> in save
> 56. session_key = self.session_key,
> File
> "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py" in
> _get_session_key
> 175. self._session_key = self._get_new_session_key()
> File
> "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py" in
> _get_new_session_key
> 167. if not self.exists(session_key):
> File "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> in exists
> 29. Session.objects.get(session_key=session_key)
> File "/usr/lib/pymodules/python2.7/django/db/models/manager.py" in get
> 132. return self.get_query_set().get(*args, **kwargs)
> File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in get
> 344. num = len(clone)
> File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in __len__
> 82. self._result_cache = list(self.iterator())
> File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in iterator
> 273. for row in compiler.results_iter():
> File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> results_iter
> 680. for rows in self.execute_sql(MULTI):
> File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> execute_sql
> 734. cursor = self.connection.cursor()
> File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py" in
> cursor
> 250. cursor = self.make_debug_cursor(self._cursor())
> File "/usr/lib/pymodules/python2.7/django/db/backends/sqlite3/base.py" in
> _cursor
> 207. self.connection = Database.connect(**kwargs)
>
> Exception Type: OperationalError at /auth/login/
> Exception Value: unable to open database file
>
> --
> 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 : <email address hidden>
> Unsubscribe : https://launchpad.net/~graphite-dev
> More help : https://help.launchpad.net/ListHelp
>

hi i tried to run django-admin sync db got following errors
django-admin syncdb
Traceback (most recent call last):
  File "/usr/bin/django-admin", line 5, in <module>
    management.execute_from_command_line()
  File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
line 429, in execute_from_command_line
    utility.execute()
  File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
line 261, in fetch_command
    klass = load_command_class(app_name, subcommand)
  File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
line 67, in load_command_class
    module = import_module('%s.management.commands.%s' % (app_name, name))
  File "/usr/lib/pymodules/python2.7/django/utils/importlib.py", line 35,
in import_module
    __import__(name)
  File
"/usr/lib/pymodules/python2.7/django/core/management/commands/syncdb.py",
line 7, in <module>
    from django.core.management.sql import custom_sql_for_model,
emit_post_sync_signal
  File "/usr/lib/pymodules/python2.7/django/core/management/sql.py", line
6, in <module>
    from django.db import models
  File "/usr/lib/pymodules/python2.7/django/db/__init__.py", line 14, in
<module>
    if not settings.DATABASES:
  File "/usr/lib/pymodules/python2.7/django/utils/functional.py", line 276,
in __getattr__
    self._setup()
  File "/usr/lib/pymodules/python2.7/django/conf/__init__.py", line 40, in
_setup
    raise ImportError("Settings cannot be imported, because environment
variable %s is undefined." % ENVIRONMENT_VARIABLE)
ImportError: Settings cannot be imported, because environment variable
DJANGO_SETTINGS_MODULE is undefined.

On Mon, Mar 19, 2012 at 3:10 AM, cbrinley <
<email address hidden>> wrote:

> Question #178172 on Graphite changed:
> https://answers.launchpad.net/graphite/+question/178172
>
> cbrinley posted a new comment:
> As a start i'd recommend either running the django syncdb or perhaps the
> sqlite file has the wrong ownership / permissions. Could potentially be
> another cause but that is an initial suggestion.
> On Mar 18, 2012 8:57 PM, "sanjaya dahal" <
> <email address hidden>> wrote:
>
> > Question #178172 on Graphite changed:
> > https://answers.launchpad.net/graphite/+question/178172
> >
> > sanjaya dahal posted a new comment:
> > hi can any body explain what this error is
> > Traceback:
> > File "/usr/lib/pymodules/python2.7/django/core/handlers/base.py" in
> > get_response
> > 178. response = middleware_method(request, response)
> > File "/usr/lib/pymodules/python2.7/django/contrib/sessions/middleware.py"
> > in process_response
> > 36. request.session.save()
> > File
> "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> > in save
> > 56. session_key = self.session_key,
> > File
> > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py"
> in
> > _get_session_key
> > 175. self._session_key = self._get_new_session_key()
> > File
> > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py"
> in
> > _get_new_session_key
> > 167. if not self.exists(session_key):
> > File
> "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> > in exists
> > 29. Session.objects.get(session_key=session_key)
> > File "/usr/lib/pymodules/python2.7/django/db/models/manager.py" in get
> > 132. return self.get_query_set().get(*args, **kwargs)
> > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in get
> > 344. num = len(clone)
> > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in __len__
> > 82. self._result_cache = list(self.iterator())
> > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in iterator
> > 273. for row in compiler.results_iter():
> > File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> > results_iter
> > 680. for rows in self.execute_sql(MULTI):
> > File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> > execute_sql
> > 734. cursor = self.connection.cursor()
> > File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py" in
> > cursor
> > 250. cursor = self.make_debug_cursor(self._cursor())
> > File "/usr/lib/pymodules/python2.7/django/db/backends/sqlite3/base.py" in
> > _cursor
> > 207. self.connection = Database.connect(**kwargs)
> >
> > Exception Type: OperationalError at /auth/login/
> > Exception Value: unable to open database file
> >
> > --
> > 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 : <email address hidden>
> > Unsubscribe : https://launchpad.net/~graphite-dev
> > More help : https://help.launchpad.net/ListHelp
> >
>
> --
> You received this question notification because you are a direct
> subscriber of the question.
>

Hi Sanjaya,
This just means django can't find the graphite settings module. That is its
not defined as an environmental variable or in the apache config.
Attached is doc on this. A typical setting looks like this: export
DJANGO_SETTINGS_MODULE=graphite.settings
Your setup may differ so please consult the django documentation.
https://docs.djangoproject.com/en/dev/topics/settings/

On Sun, Mar 18, 2012 at 10:15 PM, sanjaya dahal <
<email address hidden>> wrote:

> Question #178172 on Graphite changed:
> https://answers.launchpad.net/graphite/+question/178172
>
> sanjaya dahal posted a new comment:
> hi i tried to run django-admin sync db got following errors
> django-admin syncdb
> Traceback (most recent call last):
> File "/usr/bin/django-admin", line 5, in <module>
> management.execute_from_command_line()
> File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
> line 429, in execute_from_command_line
> utility.execute()
> File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
> line 379, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
> File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
> line 261, in fetch_command
> klass = load_command_class(app_name, subcommand)
> File "/usr/lib/pymodules/python2.7/django/core/management/__init__.py",
> line 67, in load_command_class
> module = import_module('%s.management.commands.%s' % (app_name, name))
> File "/usr/lib/pymodules/python2.7/django/utils/importlib.py", line 35,
> in import_module
> __import__(name)
> File
> "/usr/lib/pymodules/python2.7/django/core/management/commands/syncdb.py",
> line 7, in <module>
> from django.core.management.sql import custom_sql_for_model,
> emit_post_sync_signal
> File "/usr/lib/pymodules/python2.7/django/core/management/sql.py", line
> 6, in <module>
> from django.db import models
> File "/usr/lib/pymodules/python2.7/django/db/__init__.py", line 14, in
> <module>
> if not settings.DATABASES:
> File "/usr/lib/pymodules/python2.7/django/utils/functional.py", line 276,
> in __getattr__
> self._setup()
> File "/usr/lib/pymodules/python2.7/django/conf/__init__.py", line 40, in
> _setup
> raise ImportError("Settings cannot be imported, because environment
> variable %s is undefined." % ENVIRONMENT_VARIABLE)
> ImportError: Settings cannot be imported, because environment variable
> DJANGO_SETTINGS_MODULE is undefined.
>
>
> On Mon, Mar 19, 2012 at 3:10 AM, cbrinley <
> <email address hidden>> wrote:
>
> > Question #178172 on Graphite changed:
> > https://answers.launchpad.net/graphite/+question/178172
> >
> > cbrinley posted a new comment:
> > As a start i'd recommend either running the django syncdb or perhaps the
> > sqlite file has the wrong ownership / permissions. Could potentially be
> > another cause but that is an initial suggestion.
> > On Mar 18, 2012 8:57 PM, "sanjaya dahal" <
> > <email address hidden>> wrote:
> >
> > > Question #178172 on Graphite changed:
> > > https://answers.launchpad.net/graphite/+question/178172
> > >
> > > sanjaya dahal posted a new comment:
> > > hi can any body explain what this error is
> > > Traceback:
> > > File "/usr/lib/pymodules/python2.7/django/core/handlers/base.py" in
> > > get_response
> > > 178. response = middleware_method(request, response)
> > > File
> "/usr/lib/pymodules/python2.7/django/contrib/sessions/middleware.py"
> > > in process_response
> > > 36. request.session.save()
> > > File
> > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> > > in save
> > > 56. session_key = self.session_key,
> > > File
> > > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py"
> > in
> > > _get_session_key
> > > 175. self._session_key = self._get_new_session_key()
> > > File
> > > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/base.py"
> > in
> > > _get_new_session_key
> > > 167. if not self.exists(session_key):
> > > File
> > "/usr/lib/pymodules/python2.7/django/contrib/sessions/backends/db.py"
> > > in exists
> > > 29. Session.objects.get(session_key=session_key)
> > > File "/usr/lib/pymodules/python2.7/django/db/models/manager.py" in get
> > > 132. return self.get_query_set().get(*args, **kwargs)
> > > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in get
> > > 344. num = len(clone)
> > > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in
> __len__
> > > 82. self._result_cache = list(self.iterator())
> > > File "/usr/lib/pymodules/python2.7/django/db/models/query.py" in
> iterator
> > > 273. for row in compiler.results_iter():
> > > File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> > > results_iter
> > > 680. for rows in self.execute_sql(MULTI):
> > > File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py" in
> > > execute_sql
> > > 734. cursor = self.connection.cursor()
> > > File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py" in
> > > cursor
> > > 250. cursor = self.make_debug_cursor(self._cursor())
> > > File "/usr/lib/pymodules/python2.7/django/db/backends/sqlite3/base.py"
> in
> > > _cursor
> > > 207. self.connection = Database.connect(**kwargs)
> > >
> > > Exception Type: OperationalError at /auth/login/
> > > Exception Value: unable to open database file
> > >
> > > --
> > > 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 : <email address hidden>
> > > Unsubscribe : https://launchpad.net/~graphite-dev
> > > More help : https://help.launchpad.net/ListHelp
> > >
> >
> > --
> > You received this question notification because you are a direct
> > subscriber of the question.
> >
>
> --
> 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 : <email address hidden>
> Unsubscribe : https://launchpad.net/~graphite-dev
> More help : https://help.launchpad.net/ListHelp
>

--

Chris Brinley
Cleartrial

e: <email address hidden>
p: 312-460-3038
m: 219-789-2811

LinkedIn
------------

I'd like to add you to my professional network on LinkedIn.

- sanjaya

sanjaya dahals
Student at Kungliga tekniska högskolan
Stockholm County, Sweden

Confirm that you know sanjaya dahals:
https://www.linkedin.com/e/-9mjpd6-h0qk9cup-4j/isd/6586144846/jnAzXv6z/?hs=false&tok=3sgZNM2o2YcRc1

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/-9mjpd6-h0qk9cup-4j/XS1FbuttxsN-i4U0Sc5Qq6tVPR9k_67Ul3ev8nZyTi-QieUWKiW-vz/goo/question178172%40answers%2Elaunchpad%2Enet/20061/I2282845163_1/?hs=false&tok=0wM41exkiYcRc1

(c) 2012 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.

Wrong answer, bobfranis.
I urge everyone to stay away from that software he linked to in his post.
God only knows what it really does.