error storing session
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 =======================================================================
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 =======================================================================
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
On Wed, Oct 6, 2010 at 12:27 AM, Flavio Poletti <polettix@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@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 =======================================================================
participants (2)
-
Flavio Poletti -
P Kishor