Re: [sqlite] Re: seem to need write permission on db's parent directory

2005-12-16 Thread raf 
Igor Tandetnik wrote:

> raf wrote:
> >using sqlite-3.2.7 via the perl module, DBD-SQLite-1.11,
> >from a cgi script via apache on linux on a local filesystem,
> >i received this error:
> >
> > DBD::SQLite::st execute failed: unable to open database file(1) at
> >dbdimp.c line 398
> >
> >the database was publically writable (for use via apache)
> >but its parent directory wasn't. making its parent
> >directory world writable as well made the insert work
> >and made the error message stop appearing.
> 
> SQLite needs to be able to create a journal file in the same directory 
> as the DB, before any modifications can take place. The journal is used 
> to support transaction rollback.
> 
> Igor Tandetnik 

thanks for the explanation.

cheers,
raf

[sqlite] Re: seem to need write permission on db's parent directory

2005-12-16 Thread Igor Tandetnik 

raf wrote:

using sqlite-3.2.7 via the perl module, DBD-SQLite-1.11,
from a cgi script via apache on linux on a local filesystem,
i received this error:

 DBD::SQLite::st execute failed: unable to open database file(1) at
dbdimp.c line 398

the database was publically writable (for use via apache)
but its parent directory wasn't. making its parent
directory world writable as well made the insert work
and made the error message stop appearing.


SQLite needs to be able to create a journal file in the same directory 
as the DB, before any modifications can take place. The journal is used 
to support transaction rollback.


Igor Tandetnik