Django error opening SQLite3 db file on when running off Apache

Question

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

What is the output of "ls -l dev.db"? What OS and Django version are your running? What happens if you temporarily move the database file, then run ./manage.py syncdb? Does it create a new database, can you access that database. When you run "ls -l dev.db" does it report any difference in permissions or owner than when you ran it on your real database? — John Paulett
– John Paulett, Commented Nov 14, 2009 at 3:03
You may have changed the owner and group of www-data, but that doesn't mean it permeated down. Try chown -R you:www-data project && chmod -R g+w project. — Jed Smith
– Jed Smith, Commented Nov 14, 2009 at 4:10
Thanks for the suggestions guys, but I just switched to MySQL instead. Cheers! — shawnjan
– shawnjan, Commented Nov 14, 2009 at 23:10

h3. · Accepted Answer · 2010-01-15 16:33:08Z

8

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

answered Jan 15, 2010 at 16:33

h3.

11.1k15 gold badges55 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django error opening SQLite3 db file on when running off Apache

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related