Re: [sqlite] Unable to write to database
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]>
Re: [sqlite] Unable to write to database
Gregary Hendricks 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? Check your base directory when you run using the CGI interface as opposed to the command line. Is it trying to open cgi-bin/dbdimp.c?
Re: [sqlite] Unable to write to database
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