Unable to open database file Django/sqlite3

Question

I get the error

    OperationalError: unable to open database file

The path leading to my .db file is

    ~/Development/Django/django_prac/practice/database

Here is my Settings.py

    DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
    'NAME': '/Home/Development/Django/django_prac/practice/database/practice.db',                      # Or path to database file if using sqlite3. 
      # The following settings are not used with sqlite3:
    'USER': '',
    'PASSWORD': '',
    'HOST': '',                      # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
    'PORT': '',                      # Set to empty string for default.
        }
    }

I have also tried

    ~/Development/Django/django_prac/practice/database$

in my 'NAME' but yet same error occurs

First, you should simply check if the file exists, like "ls /Home/Development/Django/django_prac/practice/database/practice.db" — schneck
– schneck, Commented Jul 22, 2013 at 12:05
Are you using Apache? In this case, check code.djangoproject.com/wiki/… - you should anyway check if the user running the project has enough permissions to open the file. — schneck
– schneck, Commented Jul 22, 2013 at 12:16

Leandro · Accepted Answer · 2013-07-22 12:40:05Z

3

OK, that is my suggestion:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3', 
    'NAME': 'practice.db', # Just the name
    'USER': '',
    'PASSWORD': '',
    'HOST': '',             
    'PORT': '',             
        }
    }

I think you maybe have an error in the path, try pwd over /Home/Development/Django/django_prac/practice/database/ directory and copy the output. Then plus the db name

hope helps

answered Jul 22, 2013 at 12:40

Leandro

2,25717 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Unable to open database file Django/sqlite3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related