Django django.db.utils.OperationalError: attempt to write a readonly database

nguyennamdsn | April 27, 2022, 1:58 a.m.

I had this issue and I solved it by creating a directory in mysite folder to hold my db.sqlite3 file. so I did /home/user/src/mysite/database/db.sqlite3. In my django setting file I change my


DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.sqlite3',
    'NAME': "/home/user/src/mysite/database/db.sqlite3" ,
}}

I did this to make Django aware that I am storing my database in a sub directory of the base directory, which mysite in my case. Now you need to grant the permission to apache to be able read write the database.


chown user:www-data database/db.sqlite3
chown user:www-data database 
chmod 755 database
chmod 755 database/db.sqlite3

0
0

Leave a comment:

Comments: