Sample Header Ad - 728x90

SQLite3 randomly changes file permissions and owner

0 votes
1 answer
335 views
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