[Dancer-users] error storing session

[P Kishor]

On Wed, Oct 6, 2010 at 12:27 AM, Flavio Poletti <polettix at gmail.com> wrote:
> Was it due to permissions of the directory the database was stored into?
>


Yes. One of the folders in the tree didn't have write privs.


> 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
=======================================================================