Google gives: http://docs.oseems.com/application/apache/change-user-and-group
---- If for some reason you need to run Apache as different user and group, the trick is to just change the User and Group directive in Apache configuration file. The configuration file is normally in /etc/apache2/httpd.conf, though that depends on the system you're using. The following example will make Apache run as the user nobody and the group nobody; User nobody Group nobody ---- On 04/22/2012 01:19 PM, Steinar Midtskogen 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
