[Dancer-users] error storing session

P Kishor punk.kish at gmail.com
Wed Oct 6 02:40:05 CEST 2010

this error is most likely my own doing, so I don't expect solutions,
but I am hoping for solutions. I am stumped. If you all recall, not
too long ago I created a Dancer::Session>>SQLite plugin. I decided to
revisit it, and found it working actually quite well for me (on my
laptop). Encouraged, I installed it on my server (also a Mac OS X
machine). Installing means I copied the file to

Now, I am stumped as I am getting the following error

DBD::SQLite::st execute failed: unable to open database file at
/usr/local/lib/perl5/site_perl/5.12.1/Dancer/Session/SQLite.pm line

   1. in Plack::Middleware::StackTrace::__ANON__ at
/usr/local/lib/perl5/site_perl/5.12.1/Dancer/Session/SQLite.pm line

        156:                     VALUES (?, ?)
        157:             });
        158:     }
        159:     $sth->execute(Storable::freeze($self), $self->id) or
die $sth->errstr;
        160:     $dbh->commit;
        162:     return $self;

This is bizarre. The db exists, is write-able by the web server, and
yet, the above execute fails.

Can anyone shed any insight into this anomaly? As I said, it works
fine on my laptop, but fails on another machine. Yes, the DBI and
DBD::SQLite packages are identical and latest on both machines.

Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
Assertions are politics; backing up assertions with evidence is science

More information about the Dancer-users mailing list