[Dancer-users] error storing session

[Flavio Poletti]

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 at gmail.com> wrote:

> n'er mind.
>
> On Tue, Oct 5, 2010 at 7:40 PM, P Kishor <punk.kish at 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 at perldancer.org
> http://www.backup-manager.org/cgi-bin/listinfo/dancer-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.backup-manager.org/pipermail/dancer-users/attachments/20101006/eb7db25f/attachment-0001.htm>