Was it due to permissions of the directory the database was stored into? On Wed, Oct 6, 2010 at 2:48 AM, P Kishor <punk.kish@gmail.com> wrote:
n'er mind.
On Tue, Oct 5, 2010 at 7:40 PM, P Kishor <punk.kish@gmail.com> wrote:
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 /usr/local/lib/perl5/site_perl/5.12.1/Dancer/Session
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 159.
1. in Plack::Middleware::StackTrace::__ANON__ at /usr/local/lib/perl5/site_perl/5.12.1/Dancer/Session/SQLite.pm line 159
156: VALUES (?, ?) 157: }); 158: } 159: $sth->execute(Storable::freeze($self), $self->id) or die $sth->errstr; 160: $dbh->commit; 161: 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 =======================================================================
_______________________________________________ Dancer-users mailing list Dancer-users@perldancer.org http://www.backup-manager.org/cgi-bin/listinfo/dancer-users