Search code examples
djangosqlitebitnami

"attempt to write a readonly database" - Give permissions to db.sqlite3


I am trying to deploy my Django project on a Bitnami server, but when I try to login through admin with my superuser i get the following error:

attempt to write a readonly database
Exception Location: /opt/bitnami/python/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py, line 413, in execute

I have the following permissions to my project files:

drwxrwxr-x 6 bitnami www-data   4096 Mar 12 08:01 .
drwxr-xr-x 3 bitnami root       4096 Mar 11 10:00 ..
drwxr-xr-x 2 bitnami bitnami    4096 Mar 11 11:48 conf
-rw-rw-r-- 1 bitnami www-data 147456 Mar 12 08:01 db.sqlite3
-rw-r--r-- 1 bitnami bitnami     287 Mar 11 13:29 .env
drwxr-xr-x 5 bitnami bitnami    4096 Mar 11 10:26 app
-rwxr-xr-x 1 bitnami bitnami     667 Mar 11 10:00 manage.py
drwxr-xr-x 3 bitnami bitnami    4096 Mar 11 13:52 django_project
drwxr-xr-x 5 bitnami bitnami    4096 Mar 11 10:26 users

and this to the project directory

drwxrwxr-x  6 bitnami www-data 4096 Mar 12 08:01 django_project

I tried to run the following to give permission but without luck:

sudo chown :www-data /opt/bitnami/projects/django_project/db.sqlite3
sudo chmod 664 /opt/bitnami/projects/django_project/db.sqlite3
sudo chown :www-data /opt/bitnami/projects/django_project/
sudo chmod 775 /opt/bitnami/projects/django_project/

Can you help me? :)


Solution

  • Bitnami developer here. You are setting the group to www-data. The Bitnami Apache user is "daemon".