<div dir="ltr">On Wed, Aug 13, 2008 at 3:08 AM, Dermot <span dir="ltr"><<a href="mailto:paikkos@googlemail.com">paikkos@googlemail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
I have an odd problem with my tiny app. Under server script<br>
(MyApp/script/myapp_server -d) it runs without error. However under<br>
fascgi I am encountering a problem with one of my controllers that<br>
uses a FormFU. There an abridged version of the controller is pasted<br>
below.<br>
<br>
The error in the http error log is:<br>
:CascadeActions::update(): DBI Exception: DBD::SQLite::st execute<br>
failed: unable to open database file(14) at dbdimp.c line 403 [for<br>
Statement "UPDATE submissions SET validation_pass = ? WHERE ( id = ?<br>
)"] at ..lib/MyApp/Controller/RecordData.pm line 89, referer: ...<br>
<br>
DBIx::Class::Row::update_or_insert(): DBI Exception: DBD::SQLite::st<br>
execute failed: unable to open database file(14) at dbdimp.c line 403<br>
[for Statement "UPDATE clipData SET audio = ? WHERE ( id = ? )"] at<br>
/usr/lib/perl5/site_perl/5.8.8/HTML/FormFu/Model/DBIC.pm line 324,<br>
<br>
Server configuration.<br>
<br>
DocumentRoot /var/www/MyApp/root<br>
Alias /static /var/www/MyApp/root/static<br>
<br>
FastCgiServer /var/www/MyApp/script/myapp_fastcgi.pl -processes 3<br>
Alias /motion /var/www/MyApp/script/myapp_fastcgi.pl/<br>
<br>
Does anyone have any ideas what the problem might be? I can't see why<br>
it might work in one environment and not the other.<br></blockquote><div><br>This looks like a permissions issue to me. You're running the "server script" as one<br>user and then running the application via Apache (which is a different user like nobody or www).<br>
<br>Apache doesn't have write (or maybe even read) access to your SQLite database file or directory. <br><br>Rob <br></div></div><br></div>