Geek Answers Handbook

DatabaseError: cannot open db file, but only for Django admin

This may be the strangest problem in 4 years with Django.

My site is working fine. It also works great in a production environment, except when I try to access the admin site, I get a server error that is "OperationalError: cannot open database file" in the Apache error log.

The DB file is writable in the world, and the path in the settings is absolute. The production environment is Ubuntu Lucid / Python 2.6 / Sqlite3. I tried both with Django 1.2.4 and 1.3 beta.

The strange part is, I can syncdbon the server. It creates tables and the admin user. I can access the site without problems. I can run shelland create content on the python command line. The site is available for viewing. Only when I get access to the administrator do I get this error.

I have no reason for any reasoning. Any help is appreciated.

ps: The error occurs at the Apache level, and not from Django. Django tracing is in the Apache error log, which reads DatabaseError: unable to open database file.

+5
source share
2 answers

Dumb assumption.

Which user is working with apache?

, , , , sqlite db Apache !

+2
sudo chown www-data /var/www/yourproject/db.sqlite3

( Apache)

+1

More articles:


All Articles