NAME

Dancer2::Plugin::Auth::Extensible::Provider::DBIC - authenticate via the Dancer2::Plugin::DBIC plugin

DESCRIPTION

This class is an authentication provider designed to authenticate users against a database, using Dancer2::Plugin::DBIC to access a database.

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.

CONFIGURATION

This provider tries to use sensible defaults, in the same manner as Dancer2::Plugin::Auth::Extensible::Provider::Database, so you may not need to provide much configuration if your database tables look similar to those.

The most basic configuration, assuming defaults for all options, and defining a single authentication realm named 'users':

plugins:
    Auth::Extensible:
        realms:
            users:
                provider: 'DBIC'

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:
            users:
                provider: 'DBIC'
    DBIC:
        default:
            dsn: dbi:mysql:database=mydb;host=localhost
            schema_class: MyApp::Schema
            user: user
            pass: secret

A full example showing all options:

plugins:
    Auth::Extensible:
        realms:
            users:
                provider: 'DBIC'

                # optionally specify names of tables if they're not the defaults
                # (defaults are 'users', 'roles' and 'user_roles')
                users_table: 'users'
                roles_table: 'roles'
                user_roles_table: 'user_roles'

                # optionally set the column names
                users_username_column: username
                users_password_column: password
                roles_role_column: role

                # This plugin supports the DPAE record_lastlogin functionality.
                # Optionally set the column name:
                users_lastlogin_column: lastlogin

                # Optionally set columns for user_password functionality in
                # Dancer2::Plugin::Auth::Extensible
                users_pwresetcode_column:   # Reset code column. No default.
                users_pwchanged_column:     # Time of reset column. No default.

                # Days after which passwords expire. See logged_in_user_password_expired
                # functionality in Dancer2::Plugin::Auth::Extensible
                password_expiry_days:       # No default

                # Optionally set the name of the DBIC schema
                schema_name: myschema

                # Optionally set additional conditions when searching for the
                # user in the database. These are the same format as required
                # by DBIC, and are passed directly to the DBIC resultset search
                user_valid_conditions:
                    deleted: 0
                    account_request:
                        "<": 1

                # Optionally specify a key for the user's roles to be returned in.
                # Roles will be returned as role_name => 1 hashref pairs
                roles_key: roles

                # Optionally specify the algorithm when encrypting new passwords
                encryption_algorithm: SHA-512

users_table

Specifies the database table that the users are stored in. This will be camelized.

roles_table

Specifies the database table that the roles are stored in. This will be camelized.

user_roles_table

Specifies the database table that holds the many-to-many relationship information between users and roles. It is assumed that the relationship is configured in the DBIC schema, such that a user has many entries in the user_roles table, and that each of those has one role. This table name will be pluralized.

users_username_column

Specifies the column name of the username column in the users table

users_password_column

Specifies the column name of the password column in the users table

roles_role_column

Specifies the column name of the role name column in the roles table

schema_name

Specfies the name of the Dancer2::Plugin::DBIC schema to use. If not specified, will default in the same manner as the DBIC plugin.

user_valid_conditions

Specifies additional search parameters when looking up a user in the users table. For example, you might want to exclude any account this is flagged as deleted or disabled.

The value of this parameter will be passed directly to DBIC as a search condition. It is therefore possible to nest parameters and use different operators for the condition. See the example config above for an example.

roles_key

Specifies a key for the returned user hash to also return the user's roles in. The value of this key will contain a hash ref, which will contain each permission with a value of 1. In your code you might then have:

my $user = logged_in_user;
return foo_bar($user);

sub foo_bar
{   my $user = shift;
    if ($user->{roles}->{beer_drinker}) {
       ...
    }
}

This isn't intended to replace the "user_has_role" in Dancer2::Plugin::Auth::Extensible keyword. Instead it is intended to make it easier to access a user's roles if the user hash is being passed around (without requiring access to the user_has_role keyword in other modules).

SUGGESTED SCHEMA

See the Dancer2::Plugin::Auth::Extensible::Provider::Database documentation for an example schema.