halfcountplus has asked for the wisdom of the Perl Monks concerning the following question:
I am using DBI::SQLite in a mason context. Since I'm new to this stuff, I'm writing (non mason) test scripts and then transferring the syntax into the web app code. So, this is the "mason" code that worked in a script:
The prepare and execute work fine. However, initially the write (do insert) line produced this in httpd's error log:
unable to open database file at /var/www/html/mason/subjlist.comp line 4.
Even tho the file is owned by apache. So I changed the mode to 666 from 644 (probably not advisable) to see what would happen (ie, if maybe perl is running as a different user), but I get the same response. The print debugging line comes out correct, and there is no SQLite error.
What have I missed?
% my $db = DBI->connect("DBI:SQLite:$db_file"); % if (exists $ARGS{name}) { $db->do("insert into subjects (name) value +s ('$ARGS{name}');"); % print $ARGS{name}; } % my $sql = $db->prepare("select * from subjects"); % $sql->execute;
The prepare and execute work fine. However, initially the write (do insert) line produced this in httpd's error log:
unable to open database file at /var/www/html/mason/subjlist.comp line 4.
Even tho the file is owned by apache. So I changed the mode to 666 from 644 (probably not advisable) to see what would happen (ie, if maybe perl is running as a different user), but I get the same response. The print debugging line comes out correct, and there is no SQLite error.
What have I missed?
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: DBI::SQLite and apache
by perrin (Chancellor) on Jun 12, 2009 at 18:22 UTC | |
by halfcountplus (Hermit) on Jun 12, 2009 at 19:15 UTC | |
Re: DBI::SQLite and apache
by CountZero (Bishop) on Jun 12, 2009 at 18:56 UTC | |
by afoken (Chancellor) on Jun 12, 2009 at 20:18 UTC | |
by halfcountplus (Hermit) on Jun 12, 2009 at 20:32 UTC | |
by halfcountplus (Hermit) on Jun 12, 2009 at 19:09 UTC |
Back to
Seekers of Perl Wisdom