Hello Hugues, If I put you code in Starman.pl I get a warning in my Vim-editor: $all.sqlite requires explicit package name I have only put reference to the database in the config.yml like so: plugins: Database: driver: "SQLite" database: "all.sqlite" Looking at your test I get the idea that I should have mentioned the database also somewhere in Starman.pl? Thanks, Gert On 30 May 2014, at 10:40, Hugues <hugues@max4mail.com> wrote:
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 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
_______________________________________________ dancer-users mailing list dancer-users@dancer.pm http://lists.preshweb.co.uk/mailman/listinfo/dancer-users