[Catalyst] Troubleshooting FastCGI error

Robert Krimen robertkrimen at gmail.com
Wed Aug 13 11:24:47 BST 2008


On Wed, Aug 13, 2008 at 3:08 AM, Dermot <paikkos at googlemail.com> wrote:

> Hi,
>
> I have an odd problem with my tiny app. Under server script
> (MyApp/script/myapp_server -d) it runs without error.  However under
> fascgi I am encountering a problem with one of my controllers that
> uses a FormFU. There an abridged version of the controller is pasted
> below.
>
> The error in the http error log is:
> :CascadeActions::update(): DBI Exception: DBD::SQLite::st execute
> failed: unable to open database file(14) at dbdimp.c line 403 [for
> Statement "UPDATE submissions SET validation_pass =3D ? WHERE ( id =3D ?
> )"] at ..lib/MyApp/Controller/RecordData.pm line 89, referer: ...
>
> DBIx::Class::Row::update_or_insert(): DBI Exception: DBD::SQLite::st
> execute failed: unable to open database file(14) at dbdimp.c line 403
> [for Statement "UPDATE clipData SET audio =3D ? WHERE ( id =3D ? )"] at
> /usr/lib/perl5/site_perl/5.8.8/HTML/FormFu/Model/DBIC.pm line 324,
>
> Server configuration.
>
> DocumentRoot /var/www/MyApp/root
> Alias /static  /var/www/MyApp/root/static
>
> FastCgiServer /var/www/MyApp/script/myapp_fastcgi.pl -processes 3
> Alias /motion /var/www/MyApp/script/myapp_fastcgi.pl/
>
> Does anyone have any ideas what the problem might be? I can't see why
> it might work in one environment and not the other.
>

This looks like a permissions issue to me. You're running the "server
script" as one
user and then running the application via Apache (which is a different user
like nobody or www).

Apache doesn't have write (or maybe even read) access to your SQLite
database file or directory.

Rob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20080813/63344=
dbd/attachment.htm


More information about the Catalyst mailing list