"be consistent" | |
PerlMonks |
cgi can't write to sqlite databaseby Anonymous Monk |
on Jul 03, 2008 at 20:42 UTC ( [id://695467]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question: O monks, I have a little embedded database app that is purely for my own use, implemented as a cgi. I'm running apache on ubuntu, and the database is a sqlite file, accessed through the DBI package. I got the whole thing working great for read access. However, I can't seem to set it up so that apache can write to the sqlite file. Here's the initial version of my code that runs when I fill in a form and submit it:
Here's the message that shows up in my apache error log:
The line it's referring to is the $dbh->do(...). I've tried setting the file to be globally writeable. I've tried moving the file out of my home directory and into the cgi-bin directory. Neither of those things seemed to help. I'm guessing that this is something related to security that apache is doing. This is just running on my desktop machine, however, and I'm behind my router's built-in firewall, so I'm not worried about the security of the script. Any suggestions would be much appreciated!
Back to
Seekers of Perl Wisdom
|
|