[Solved] how to write to sqlite database?

[taotao]

Here is the error:

 

Django Version: 2.1.4

Exception Type: OperationalError

Exception Value: attempt to write a readonly database

 

The database is sqlite.

 

1) It worked fine locally, but error when deployed to tommy.

2) Changed the sqlite database file permission to 777, got the same error.

 

Please help.

 

Thanks,

jayjay

Edited June 28, 2019 by taotao

[Luigi123]

Let’s get out root admin to help you with this.

 

Escalating

[taotao]

Here are the settings of file permissions which will work:

 

1. sqlite database file must in public_html folder (why the server put this limitation???)

2. public_html must have group write permission

3 sqlite database file must have both group and world write permission.

 

Even though it is working, but not a safe configuration anyway. 

 

Sqlite3 seems requires the write permission to both database and the holding directory. So if the 1 is lift, it will be safer.

[Krydos]

We recommend using mysql instead of sqlite because it's a lot easier to set up and more secure.