I use sqlite3 for a PHP app. The functions I use are from the Sqlite3 package built in to PHP.
I do not normal CRUD actions, including restarting the DB for testing. This includes dropping tables and reinserting dummy data.
The DB file has file permissions of
sudo chmod a+rw
and sudo chown $USER:www-data
.
This all works fine.
But at least once per day, I will get a no write error. And when I look at the DB, the permissions and ownership has changed.
The user and group changes to $USER:$USER
and the file permissions change to -rw-r--r--
What could be causing this behavior?
OS: Debian 12
Asked by Vinn
(236 rep)
Jan 20, 2024, 03:05 PM
Last activity: Jan 20, 2024, 11:27 PM
Last activity: Jan 20, 2024, 11:27 PM