On Wed, 2006-07-12 at 01:12 +0100, Nuno Lucas wrote: > On 7/12/06, Gregary Hendricks <[EMAIL PROTECTED]> wrote: > > Greetings fellow SQLiters, > > > > I am having a bad hair day as a result of an error I am getting with my > > SQLite database. > > > > I am running SQLite 3.3.6 on SuSE linux 9.3 > > I am trying to access it via a Perl CGI script on my website. I am using > > the Perl DBD::SQLite module to access the database. I am able to read > > from it without any difficulty, the problems arise when I try to do an > > insert. I get the following error: > > > > Errors: 1, unable to open database file(1) at dbdimp.c line 398 > > > > The strange thing is that if I run the cgi script from the command line, > > it works just fine. This seems point to a permissions issue but the file > > and directories are set to open write (666 and 777 respectively). > > > > Any pointers? > > Maybe sqlite is not able to create the temporary journal file? > Try to add perl code to create a file on the same directory to make > sure it's writable by the cgi user. > > Just my .02 cents, as don't know much about perl. > > Regards, > ~Nuno Lucas
This worked. Thanks -- Gregary Hendricks <[EMAIL PROTECTED]>
