Django Lightsail - attempt to write a readonly database

Question

I am trying to deploy my Djago app on AWS Lightsail.

When I try to login/register, I am getting this error:

Attempt to write a readonly database

I have been googling solutions for quite some time and have tried setting different permissions, even giving away all permissions which might be huge security risk, however it still doesn't work.

Could anyone help me.

Answer 1

check that your file is owned by bitnami:bitnami. (I've been having the same exact issue and yours and i havent been able to fix it either)

Answer 2

So, in case someone else has this problem, what should work and what worked for me:

I moved db.sqlite3 file to one folder outside of main project dir.

Then I changed address to this file in settings.py to os.path.join(BASE_DIR, '..', 'db.sqlite3')

Though I feel like it's really a problem of user permissions, but that's above my current skill level.

Answer 3

I found another solution that worked for me.

See: https://github.com/mchesler613/django_adventures/blob/main/deploy_django_aws_bitnami.md

Author goes into detail about the details behind the error. See "Error: Attempt to write a readonly database"

---

Change group ownership of the project root directory and the database file to daemon. For example:

$ sudo chgrp daemon project_directory project_directory/database_file

Make the project root directory and the database file writable by the daemon group. For example:

$ sudo chmod g+w project_directory project_directory/database_file

To see if the database error goes away, try reloading the Django app on the browser.

Answer 4

I had the same problem. Changing db.sqlite3 mode to writable doesn't work for me. I can use django shell to add data to db.sqlite3 but from apache2, it doesn't work.

Finally, I changed owner of the directory where db.sqlite3 locates to www-data:www-data, and it worked.