When I run

python manage.py runserver

I get this error

File "/usr/local/lib/python2.7/dist-packages/", line 209, in get_new_connection conn = Database.connect(**conn_params) django.db.utils.OperationalError: unable to open database file

my settings.py:

DATABASES = { 'default': dj_database_url.config( default="sqlite:///{}".format( os.path.join(BASE_DIR, 'db/db.sqlite3') ) )
}

11 Answers

Suffering for a while from the same issue and I believe I have found a solution, finally!

sudo python manage.py runserver

and that did the trick for me.

My permissions were telling me that everything is how it should be. Regardless, I still had to type in sudo at the beginning of the command at the terminal.

2

Basically there are two answers, either user which running server don't have rights to open database file. You can try to fix this by:

sudo chown $(whoami):$(whoami) /path/to/dir/db/db.sqlite3

Or you don't have this file, you can create it by applying migrate command:

./manage.py migrate

1

I had the same problem, just solved it. Make sure www-data (or whatever daemon running your web server) has access to both the db.sqlite3 file, and also the path to it. So:

sudo chown :www-data <project_folder>/
sudo chown :www-data <project_folder>/db.sqlite3
sudo chmod 664 <project_folder>/db.sqlite3

Just remove the first db in your settings.py file.

You have os.path.join(BASE_DIR, 'db/db.sqlite3') if you remove the first db, you'll have os.path.join(BASE_DIR, 'db.sqlite3')

Your database settings will be

DATABASES = { 'default': dj_database_url.config( default="sqlite:///{}".format( os.path.join(BASE_DIR, 'db.sqlite3') ) )
}

For me, the issue was that I had two settings files; one for production and one for development. In my manage.py, I'd specified the deployment settings file and forgotten to add manage.py to my .gitignore, so when I ran the project locally it failed when trying to find the production database.

TO ANY WINDOWS USERS:

I got the same error while creating my first django project. I couldn't use sudo on windows, so the command python manage.py runserver only worked when I ran my terminal as administrator.

0

I have similar problem.

You just run command with sudo

sudo python3 manage.py runserver

Enjoy!

0

If you are experiencing this problem on AWS EC2 node and using apache, to solve the problem I had to:

chown -R apache:apache project_folder

For many users(like myself), who might have this error while using another DB engine but have set the default engine via your env variable invocation as sqllite3, you might want to either remove that default value or check that the env variable you're checking is named the same way in your .env file.

Rookie mistake but well,

@whinytween96 : I have seen this problem occur more when sudo is used to run some commands and not for others. You need to be consistent with the usage of sudo to fix this problem. I had the DB issue and I fixed it by running the command again with sudo prefixed.

i.e.

1. sudo python manage.py runserver
2. sudo python manage.py makemigrations
3. sudo python manage.py migrate

fixed the problem for me.

check folder name, you store database file

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy