Python – Django error opening SQLite3 db file on when running off Apache

djangopythonsqliteUbuntu

I got this error:

OperationalError at /

unable to open database file

Things I've tried so far are setting the absolute path of my dev.db file in the settings.py. I've tried adding www-data to my admin group and setting the group of my project folder to the admin, and setting the group to www-data, none of which solved the problem.

I'm completely stuck here, if anyone has a solution it would be MUCH appreciated!

Shawn

Best Answer

Just passed the last 30 minutes banging my head on this problem ..

Solution

In your settings.py:

DATABASE_NAME = '/absolute/path/to/your/database.db'

Setting rights:

chown www-data /absolute/path/to/your/
chown www-data /absolute/path/to/your/database.db

Related Solutions

Sqlite – Django is “unable to open database file”

Solution from NewbieMistakes

Make sure Apache can also write to the parent directory of the database. SQLite needs to be able to write to this directory.

Make sure each folder of your database file's full path does not start with number, eg. /www/4myweb/db (observed on Windows 2000).

If DATABASE_NAME is set to something like '/Users/yourname/Sites/mydjangoproject/db/db', make sure you've created the 'db' directory first.

Make sure your /tmp directory is world-writable (an unlikely cause as other thing on your system will also not work). ls /tmp -ald should produce drwxrwxrwt ....

Make sure the path to the database specified in settings.py is a full path.

Ruby – sqlite3-ruby install error on Ubuntu

You need the SQLite3 development headers for the gem’s native extension to compile against. You can install them by running (possibly with sudo):

apt-get install libsqlite3-dev

Best Answer

Related Solutions

Sqlite – Django is “unable to open database file”

Ruby – sqlite3-ruby install error on Ubuntu

Related Topic