Question
Django db.sqlite3 database is not connected with apache server.
- Posted July 5, 2020
- ApacheDatabasesUbuntu 20.04Django
I got main problem in my project,actually Django db.sqlite3 database is not connected with apache server. that’s why when i open my site.I got this error OperationalError at / attempt to write a readonly database
So please tell me its solution. How to connect db.sqlite with apache server in django app on ubuntu.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi there @akshaykoshti401,
Can you share the exact database configuration that you are using in your settings.py file?
Usually, in order to configure SQLite with Django, you need to do the following:
- First install SQLite:
sudo apt install sqlite3
- Update your
settings.pyand adjust these 2 lines:
DATABASE_ENGINE = 'sqlite3'
DATABASE_NAME = '/path/to/your/project/yourdb'
- Then run your migrations
python manage.py migrate
Another thing that I could suggest is, rather than using SQLite is to use PostgreSQL, you can take a look at this step by step tutorial on how to configure that:
Hope that this helps! Regards, Bobby
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
DATABASE_NAME = '/path/to/your/project/yourdb yourdb can paste directory of database or database file name