Hello Gert Are you sur than Starman are able to read your file all.sqlite ? if all is ok when you launch ./bin/app.pl, check this point and add simple test in Starman.pl |if (-e $all.sqlite) { print "database Exists!\n";| } else { print "Error unable to find database\n"; exit; } Hugues Le 30/05/2014 10:26, Gert van Oss a écrit :
hello Dancers,
I'm trying to use Dancer::Plugin::Database. The database is a sqlite-file that only serves as datafile so I'm not writing to the database in my app. If I run my app on the server with the command 'perl bin/app.pl' everything works just fine. All data is shown on the pages as expected.
If, however I startup the app while making use of Starman (I took guidance of the article on the perlmaven <http://perlmaven.com/getting-started-with-perl-dancer-on-digital-ocean> site) I get the message that the app is unable to open the database. Up until now I worked around the problem to store all my data in json-files and create multiple 'selection/sorts' by using hashes and arrays but that is becoming a bit difficult to maintain.
The error log gives two lines
DBI connect('dbname=all.sqlite','',...) failed: unable to open database file at /home/gertmt/perl5/perlbrew/perls/perl-5.20.0/lib/site_perl/5.20.0/Dancer/Plugin/Database/Core.pm line 259.
Database connection failed - unable to open database file in /home/gertmt/perl5/perlbrew/perls/perl-5.20.0/lib/site_perl/5.20.0/Dancer/Plugin/Database.pm l. 28
these might explain the problem however I have no idea where to start. Is there someone who had to deal with this issue?
Thanks, Gert
_______________________________________________ dancer-users mailing list dancer-users@dancer.pm http://lists.preshweb.co.uk/mailman/listinfo/dancer-users