Hi Apologies for the length of this but I wanted to include everything I have tried.
I have been using Dancer2::Plugin::Auth::Extensible <http://search.cpan.org/perldoc?Dancer2%3A%3APlugin%3A%3AAuth%3A%3AExtensible> for a while - all good. I am now trying to use Dancer2::Plugin::Auth::Extensible::Provider::Database <http://search.cpan.org/perldoc?Dancer2%3A%3APlugin%3A%3AAuth%3A%3AExtensible%3A%3AProvider%3A%3ADatabase> thus session: Cookie template: template_toolkit engines: template: template_toolkit: start_tag: '<%' stop_tag: '%>' session: Cookie: secret_key: thisisverysecret! default_duration: 604800 plugins: Auth::Extensible: disable_roles: 1 realms: users: provider: 'Database' users_table: ot_users # roles_table: ot_roles # user_roles_table: ot_user_roles Database: dsn: "dbi:Informix:ehive_support2012" #driver: 'Informix' #database: 'ehive_support2012' username: ******* password: ******* log_queries: 1 on_connect_do: ['set explain on'] dbi_params: PrintError: 0 RaiseError: 1 AutoCommit: 1 Once I got past the db connection errors I added and entry in the ot_users table for me using create_user username => "clive", email => 'cl...@hildebrand.co.uk', email_welcome => 0; and user_password username => 'clive', new_password => 'secret'; And indeed I can manually run SELECT * FROM "ot_users" WHERE "username”=‘clive’ and it works In addition the following test program also works #!/usr/bin/env perl use DBI; use Data::Dumper; my $dbh_support = DBI-> connect("dbi:Informix:ehive_support2012", ‘*******' , ‘*******', { RaiseError=> 0, AutoCommit => 1, PrintError => 1, PrintWarn => 1}) or die("Connect failed $DBI::errstr"); $sel = $dbh_support->prepare(qq(SELECT * FROM "ot_users" WHERE "username"=?)); $sel->execute('clive'); my $a = $sel->fetchrow_hashref; print Dumper($a); producing $VAR1 = { 'password' => '{SSHA512}Jr34UXRpsaCQSWsJJE/Qq84fpq6RBVi', 'email' => 'cl...@hildebrand.co.uk', 'pw_reset_code' => 'Ct1FIiUkwdiLSRVYUQCOyQYEquSV5RRe', 'username' => 'clive', 'id' => '3', 'hid' => undef }; However the login is failing and I am just returned to the login screen with the banner set to LOGIN FAILED There is no indication WHAT is failing - can anyone suggest either what is wrong or where I can add debug - I have tried with and without roles. [otweb:22772] core @2017-11-23 10:10:22> looking for post /login in /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Core/App.pm l. 35 [otweb:22772] core @2017-11-23 10:10:22> Entering hook core.app.before_request in (eval 718) l. 1 [otweb:22772] core @2017-11-23 10:10:22> Entering hook plugin.auth_extensible.before_authenticate_user in (eval 718) l. 1 [otweb:22772] debug @2017-11-23 10:10:22> Attempting to authenticate clive against realm users in /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Core/Route.pm l. 140 [otweb:22772] core @2017-11-23 10:10:22> Entering hook plugin.database.database_connected in (eval 718) l. 1 [otweb:22772] debug @2017-11-23 10:10:22> Executing SELECT query SELECT * FROM "ot_users" WHERE "username"=? with params clive in /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Plugin.pm l. 532 [otweb:22772] core @2017-11-23 10:10:22> Entering hook plugin.auth_extensible.after_authenticate_user in (eval 718) l. 1 [otweb:22772] core @2017-11-23 10:10:22> looking for get /login in /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Core/App.pm l. 35 [otweb:22772] core @2017-11-23 10:10:22> Entering hook core.app.before_request in (eval 718) l. 1 [otweb:22772] debug @2017-11-23 10:10:22> app has no login template defined in /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Plugin/Auth/Extensible.pm l. 283 [otweb:22772] core @2017-11-23 10:10:22> Entering hook core.app.after_request in (eval 718) l. 1 -- Clive Eisen GPG: 3818B5F1
_______________________________________________ dancer-users mailing list dancer-users@dancer.pm http://lists.preshweb.co.uk/mailman/listinfo/dancer-users