NAME Dancer2::Plugin::Auth::Extensible::Provider::Usergroup - authenticate as a member of a group SYNOPSIS Define that a user must be logged in and have the proper permissions to access a route: get '/unsubscribe' => require_role forum => sub { ... }; DESCRIPTION This class is an authentication provider designed to authenticate users against a DBIC schema, using Dancer2::Plugin::DBIC to access a database. Dancer2::Plugin::Passphrase is used to handle hashed passwords securely; you wouldn't want to store plain text passwords now, would you? (If your answer to that is yes, please reconsider; you really don't want to do that, when it's so easy to do things right!) See Dancer2::Plugin::DBIC for how to configure a database connection appropriately; see the "CONFIGURATION" section below for how to configure this authentication provider with database details. See Dancer2::Plugin::Auth::Extensible for details on how to use the authentication framework, including how to use "require_login" and "require_role". CONFIGURATION This provider tries to use sensible defaults, so you may not need to provide much configuration if your database tables look similar to those in the "SUGGESTED SCHEMA" section below. The most basic configuration, assuming defaults for all options, and defining a single authentication realm named 'usergroup': plugins: Auth::Extensible: realms: usergroup: provider: 'Usergroup' You would still need to have provided suitable database connection details to Dancer2::Plugin::DBIC, of course; see the docs for that plugin for full details, but it could be as simple as, e.g.: plugins: Auth::Extensible: realms: usergroup: provider: 'Usergroup' schema_name: 'usergroup' DBIC: usergroup: chema_class: Usergroup::Schema dsn: "dbi:SQLite:dbname=/path/to/usergroup.db" A full example showing all options: plugins: Auth::Extensible: realms: usergroup: provider: 'Usergroup' # optional schema name for DBIC (default 'default') schema_name: 'usergroup' # optionally specify names of result sets if they're not the defaults # (defaults are 'User' and 'Role') user_rset: 'User' user_role_rset: 'Role' # optionally set the column names (see the SUGGESTED SCHEMA # section below for the default names; if you use them, they'll # Just Work) user_login_name_column: 'login_name' user_passphrase_column: 'passphrase' user_role_column: 'role' # optionally set a column name that makes a user useable # (not all login names can be used to login) user_activated_column: 'activated' See the main Dancer2::Plugin::Auth::Extensible documentation for how to configure multiple authentication realms. ATTRIBUTES schema_name Defaults to 'default', schema Defaults to a DBIC schema using "schema_name". user_rset The name of the DBIC result class for the user table. Defaults to 'User'. user_role_rset The name of the DBIC result class for the role view. Defaults to 'Role'. user_login_name_column The login_name column in "user_rset". Defaults to 'login_name'. user_passphrase_column The passphrase column in "user_rset". Defaults to 'passphrase'. user_role_column The role column in "user_role_rset". Defaults to 'role'. user_activated_column The user activated column in "user_rset". Defaults to 'activated'. SUGGESTED SCHEMA If you use a schema similar to the examples provided here, you should need minimal configuration to get this authentication provider to work for you. The examples given here should be SQLite-compatible; minimal changes should be required to use them with other database engines. user table You'll need a table to store user accounts in, of course. A suggestion is something like: CREATE TABLE users ( id INTEGER PRIMARY KEY, login_name TEXT UNIQUE NOT NULL, passphrase TEXT NOT NULL, activated INTEGER ); You will quite likely want other fields to store e.g. the user's name, email address, etc; all columns from the users table will be returned by the "logged_in_user" keyword for your convenience. group table You'll need a table to store a list of available groups in. CREATE TABLE groups ( id INTEGER PRIMARY KEY, group_name TEXT UNIQUE NOT NULL ); membership table To make users a member you'll need a table to store user <-> group mappings. CREATE TABLE memberships ( id INTEGER PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES users (id), group_id INTEGER NOT NULL REFERENCES groups (id) ); role view Map the user role by name. CREATE VIEW roles AS SELECT login_name, group_name AS role FROM users LEFT JOIN memberships ON users.id = memberships.user_id LEFT JOIN groups ON groups.id = memberships.group_id ; indexes You want your data quickly. CREATE UNIQUE INDEX login_name ON users (login_name); CREATE UNIQUE INDEX group_name ON groups (group_name); CREATE UNIQUE INDEX user_group ON memberships (user_id, group_id); CREATE INDEX member_user ON memberships (user_id); CREATE INDEX member_group ON memberships (group_id); INTERNALS get_user_details Used by Dancer2::Plugin::Auth::Extensible match_password Used by Dancer2::Plugin::Auth::Extensible authenticate_user Used by Dancer2::Plugin::Auth::Extensible get_user_roles Used by Dancer2::Plugin::Auth::Extensible COPYRIGHT Copyright (c) 2014 Henk van Oers LICENSE This library is free software and may be distributed under the same terms as perl itself.