Re: [Catalyst] DBIC Authentication Errors

Greg Coates Wed, 24 Sep 2008 15:52:04 -0700

Yep, that fixed it.  I knew it had to be something simple!


Thanks,
Greg

J. Shirley wrote:

On Wed, Sep 24, 2008 at 2:52 PM, Greg Coates <[EMAIL PROTECTED]> wrote:

I'm getting errors when I try to login to my web app, which is set up to use
the DBIC authentication plugin.



Here's the relevant portion of my config file:

authentication:
 default_realm: dbic
 realms:
   dbic:
     credential:
       class: Password
       password_field: usr_password
       password_type: clear
     store:
       class: DBIx::Class
       user_class: BlogDB::Users
       id_field: usr_login_name



When I start the dev server, I see this:
[debug] Loaded Config "/path/to/my/config/dev.yml"
[debug] Setting up auth realm dbic



Here's the login controller:

sub login : Local {
 my ($self, $c) = @_;

 if ($c->request->params->{submitted} eq 'yes') {
   my $username = $c->request->params->{usr_login_name} || "";
   my $password = $c->request->params->{usr_password} || "";
   if ($c->authenticate({ username => $username,
                          password => $password })) {
     $c->response->redirect( $c->uri_for('/posts') );
     return;
   } else {
     $c->stash->{message} = "Invalid user ID or password.";
   }
 }

 $c->stash->{template} = 'users/login.tt';
 $c->stash->{stylesheet} = 'form.css';
}


The login form displays fine, but when I try to log in using a uid/password
combo that IS in the database, I get this error:

[debug] "POST" request for "users/login"
[debug] Path is "users/login"
[error] Caught exception in MyApp::Controller::Users->login "User retrieval
failed: no columns from BlogDB::Users were provided at
/usr/lib/perl5/site_perl/5.8.5/Catalyst/Authentication/Store/DBIx/Class.pm
line 63"


I've googled for solutions until my fingertips are numb with no luck.  I
suspect there's some stupid little problem that I'm missing.  Can anyone
shed some light on this issue for me?

Thanks,
Greg


You probably want $c->authenticate({ usr_login_name => $username,
usr_password => $password });

The parameters passed into authenticate match what your DBIC schema
class declares.

-J

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Re: [Catalyst] DBIC Authentication Errors

Reply via email to