NAME

CGI::Session::Auth::Mouse::DBI - CGI::Session::Auth::Mouse のSessionの保存先をDBIでうんぬんします

VERSION

This document describes CGI::Session::Auth::Mouse::DBI version 0.0.1

SYNOPSIS

    use CGI;
    use CGI::Session;
    use CGI::Session::Auth::Mouse::DBI;

    my $cgi     = new CGI;
    my $session = new CGI::Session(undef, $cgi, {Directory=>'/tmp'});
    my $auth    = CGI::Session::Auth::Mouse::DBI->new(
        cgi     => $cgi,
        session => $session,
        dsn     => 'DBI:mysql:cgiauth:localhost:3306',
    );
    $auth->authenticate();
    if ( $auth->logged_in ) {
        ## show secret page
    }
    else {
        ## show login page
    }

SAMPLE HTML

    <form method="POST" action="sample.cgi">
        <input type="text" name="login_username" />
        <input type="password" name="login_password" />
        <input type="submit" value="submit" />
    </form>

DEFAULT TABLE

    CREATE TABLE auth_user (
        id int(11) NOT NULL,
        username varchar(255) NOT NULL,
        passward varchar(255) NOT NULL default '',
        -- md5_hex value
        PRIMARY KEY (id),
        UNIQUE username (username)
    );

Constructor parameters

Additional to the standard parameters used by the new constructor of all CGI::Session::Auth::Mouse::Role classes, CGI::Session::Auth::Mouse::DBI understands the following parameters:

db_handle: Active database handle.

dsn: Data source name for the database connection. (Default: none) For an explanation, see the DBI documentation.

db_user: Name of the user account used for the database connection. (Default: none)

db_password: Password of the user account used for the database connection. (Default: none)

db_port: Connection Port of the user account used for the database connection. (Default: 3306)

db_attr: Optional attributes used for the database connection. (Default: none)

user_table: Name of the table containing the user authentication data and profile. (Default: 'users')

user_name_field: Name of the column username field. (Default: 'username')

user_pass_field: Name of the column password field. (Default: 'password')

METHODS

login

CGI::Session::Auth::Mouse::Role requires this method.

load_profile

CGI::Session::Auth::Mouse::Role requires this method.

BUGS AND LIMITATIONS

Please report any bugs or feature requests to bug-cgi-session-auth-mouse-role@rt.cpan.org, or through the web interface at http://rt.cpan.org.

DEPENDENCIES

CGI::Session::Auth::Mouse::Role DBI Digest::MD5

SEE ALSO

CGI::Session::Auth::DBI CGI::Session::Auth::Mouse::Role DBI

AUTHOR

<noblejasper> <<nobjas@gmail.com>>

LICENCE AND COPYRIGHT

Copyright (c) 2009, <noblejasper> <<nobjas@gmail.com>>. All rights reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.