python flask sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) attempt to write a readonly database

Question

i am trying now about two hours to fix this problem. I know there are already alot of topics about this, but none of them is helping me.

I am using python and flask to run my apache2 server.

in this folder is my .wsgi file and my database. /var/www/html/webApp

i gave the whole folder and the data base rights with:

chmod 777 /var/www/html/webApp
chmod 777 /var/www/html/webApp/users.sqlite3

i restarted after these comments the vps and the apache2 server multiple times, but still i am geting this error.

I really hope someone can help me.

regards

caldetas · Accepted Answer · 2021-02-22 12:51:18Z

2

I am working on the same issue, could resolve it with help from the following page: sqlite3.OperationalError

//do the follow
chown www-data /myproject
chown www-data /myproject/db.sqlite3
chmod 777 /myproject/db.sqlite3

The folder containing the db-file and the db-file itself must be owned by www-data. Otherwise the flask-application has no rights to change the db-file.

answered Feb 22, 2021 at 12:51

caldetas

462 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erick Audet Over a year ago

This does not work. At least when running under docker compose volume

Collectives™ on Stack Overflow

python flask sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) attempt to write a readonly database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related