Try the sticky bit: chown user:apache theDir chmod 4775 theDir
:-? ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal On Apr 22, 2012 1:19 PM, "Steinar Midtskogen" <stei...@latinitas.org> wrote: > Patrik Nilsson <nipatriknils...@gmail.com> writes: > > > You can try setting your user as member of group apache. > > That's already done, but the trouble is that when the shm and wal > files are created by and therefore owned by "apache", then "user" > can't change that file unless it's group writeable. Having apache run > with umask 002 should fix this, but I wonder if there is another > workaround (and I haven't figured yet out how to configure apache to > do this, anyway). > > -Steinar > > > > > On 04/22/2012 10:31 AM, Steinar Midtskogen wrote: > >> This might be slightly off topic, but perhaps a common problem for > >> many sqlite users. > >> > >> I have a database (wal mode) that apache (the web server) needs to > >> access, readonly. Since it needs to be able to lock it for reading, > >> apache needs write access. So the database has these permissions: > >> > >> -rw-rw-r-- 1 user apache 1837704192 2012-04-22 09:58 database.db > >> > >> The directory is also group writeable. > >> > >> The trouble is that when apache is accessing the database, the > >> database file owner can't access it, not even for reading. The result > >> is "unable to open database file". I believe that the cause is that > >> apache creates these files: > >> > >> -rw-r--r-- 1 apache apache 32768 2012-04-22 10:15 > database.db-shm > >> -rw-r--r-- 1 apache apache 0 2012-04-22 09:58 > database.db-wal > >> > >> which other users have no write access to. So access to the database > >> is locked until sqlite remove these files. > >> > >> Is there a way to work around this, other than to set umask 002 for > >> apache? > >> > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users