django with sqlite unable to open database file

Question

I have sqlite database setting like in my production server :

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3',
    'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
}

}

I have also tried chown www-data path_to_db and chmod 777 path_to_db

I am using celery, rabbitmq and supervisor in this application.. but its still showing error saying unable to open database.. whats the issue here

Why aren't you using a proper database server in production? — Daniel Roseman
– Daniel Roseman, Commented Jul 25, 2015 at 18:03
@DanielRoseman Its a very small website so I used sqlite.. What might be the issue here ? — gamer
– gamer, Commented Jul 25, 2015 at 18:11
Are you sure, that DATABASES.default.NAME points to the correct location? How are you deploying your project? — Mischback
– Mischback, Commented Jul 25, 2015 at 18:17
I have did syncdb and created superuser too.. When I tried to login admin it said unable to write readonly database but after doing chown www-data path_to_db it gives unable to oepen database file error — gamer
– gamer, Commented Jul 25, 2015 at 18:22
@DanielRoseman I am also using celery, rabbitmq and supervisor .. but I am using all this in my local too and it worked fine with sqlite — gamer
– gamer, Commented Jul 25, 2015 at 18:23

gamer · Accepted Answer · 2015-07-25 18:38:38Z

3

This worked for me:

chown www-data path_to_directory_containing_db

answered Jul 25, 2015 at 18:38

gamer

5,90314 gold badges60 silver badges93 bronze badges

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

Comments

Serafim Suhenky · Accepted Answer · 2015-07-25 18:18:27Z

0

First lets find out the value of BASE_DIR. Add to your settings.py

print "base dir %s" % BASE_DIR

And run server. You'll see your base_dir and could ensure that file is in right place.

answered Jul 25, 2015 at 18:18

Serafim Suhenky

2,1581 gold badge17 silver badges19 bronze badges