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
