Re: [sqlite] Permissions

[Richard Hipp] > On Sun, Apr 22, 2012 at 12:40 PM, Steinar Midtskogen > wrote: > >> >> Any reason why sqlite doesn't use the same file permissions as the >> database file when creating these extra files? >> >> > There was a change in version 3.7.11 to do exactly that. >

Re: [sqlite] Permissions

On 22 Apr 2012, at 6:02pm, Richard Hipp wrote: > There was a change in version 3.7.11 to do exactly that. > http://www.sqlite.org/src/info/84b324606a Woo hoo. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Permissions

On Sun, Apr 22, 2012 at 12:40 PM, Steinar Midtskogen wrote: > > Any reason why sqlite doesn't use the same file permissions as the > database file when creating these extra files? > > There was a change in version 3.7.11 to do exactly that.

Re: [sqlite] Permissions

[Simon Slavin] > The solution I came up with is that the database file owner also > uses Apache to look at it: I use web-facing database administration > software rather than opening the database in another application. > (I wrote a simple one myself in PHP and JavaScript.) However this > is

Re: [sqlite] Permissions

Stephan Beal writes: > Try the sticky bit: > > chown user:apache theDir > chmod 4775 theDir I think the effect of that only is to restrict anyone but root or the owner of a file from deleting or renaming an otherwise writeable file in that directory. -- Steinar

Re: [sqlite] Permissions

On 22 Apr 2012, at 9:31am, Steinar Midtskogen wrote: > This might be slightly off topic, but perhaps a common problem for > many sqlite users. Common problem, and it would be nice to have a solution. > I have a database (wal mode) that apache (the web server) needs to >

Re: [sqlite] Permissions

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

Re: [sqlite] Permissions

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" wrote: > Patrik Nilsson writes: > > > You can

Re: [sqlite] Permissions

Patrik Nilsson 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.

Re: [sqlite] Permissions

You can try setting your user as member of group apache. 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

[sqlite] Permissions

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:

Re: [sqlite] Permissions issue with SQLite

On 09/23/2011 03:09 AM, Magnus Thor Torfason wrote: On 9/22/2011 10:25, Dan Kennedy wrote: For new versions, new db files are created with the permissions specified by compilation option SQLITE_DEFAULT_FILE_PERMISSIONS. Subject to umask of course.

Re: [sqlite] Permissions issue with SQLite

On 9/22/2011 10:25, Dan Kennedy wrote: For new versions, new db files are created with the permissions specified by compilation option SQLITE_DEFAULT_FILE_PERMISSIONS. Subject to umask of course. http://www.sqlite.org/compile.html#default_file_permissions Thanks for your help. But I take it

Re: [sqlite] Permissions issue with SQLite

On 09/22/2011 09:20 PM, Stephan Beal wrote: On Thu, Sep 22, 2011 at 4:16 PM, Magnus Thor Torfason< zulutime@gmail.com> wrote: SQLite version 3.3.6 Just to preempt the inevitable request to try it on a current version: this is reproducible on 3.7.2 (Ubuntu 10.10). For new versions,

Re: [sqlite] Permissions issue with SQLite

On Thu, Sep 22, 2011 at 4:16 PM, Magnus Thor Torfason < zulutime@gmail.com> wrote: > SQLite version 3.3.6 > Just to preempt the inevitable request to try it on a current version: this is reproducible on 3.7.2 (Ubuntu 10.10). -- - stephan beal http://wanderinghorse.net/home/stephan/

[sqlite] Permissions issue with SQLite

Hi, I'm having a permission issue with SQLite on my institution's computing grid/cluster. When I create a file using touch (or any other program for that matter, it correctly receives '-rw-rw' as the permission. However, when I create it from SQLite, it gets created with '-rw-r-'

[sqlite] permissions for created database files are too restrictive and do not obey umask setting

File permissions on database files created by the library libsqlite3 on Unix/Linux are created with a mask setting that restricts permissions beyond what the user may expect from the current umask setting. In the file src/os_unix.c a mask is defined as: ** Default permissions when creating a

[sqlite] PHP created sqlite permissions

I use PDF-PDO to create and populate sqlite tables as a backup - each time the backup process is run I get a table is locked error. Deleting the sqlite db allows the process to run without error. After the db is created I chmod the file to "0775"; I notice the result is ... -rwxrwxr-x 1