NAME

       Authen::Simple::DBI - Simple DBI authentication

SYNOPSIS

           use Authen::Simple::DBI;

           my $dbi = Authen::Simple::DBI->new(
               dsn       => 'dbi:SQLite:dbname=database.db',
               statement => 'SELECT password FROM users WHERE username = ?'
           );

           if ( $dbi->authenticate( $username, $password ) ) {
               # successfull authentication
           }

           # or as a mod_perl Authen handler

           PerlModule Apache::DBI
           PerlModule Authen::Simple::Apache
           PerlModule Authen::Simple::DBI

           PerlSetVar AuthenSimpleDBI_dsn       "dbi:SQLite:dbname=database.db"
           PerlSetVar AuthenSimpleDBI_statement "SELECT password FROM users WHERE username = ?"

           <Location /protected>
             PerlAuthenHandler Authen::Simple::DBI
             AuthType          Basic
             AuthName          "Protected Area"
             Require           valid-user
           </Location>

DESCRIPTION

       DBI authentication.

METHODS

       •   new

           This method takes a hash of parameters. The following options are valid:

           •       dsn

                   Database Source Name. Required.

                       dsn => 'dbi:SQLite:dbname=database.db'
                       dsn => 'dbi:mysql:database=database;host=localhost;'

           •       statement

                   SQL statement. The statement must take a single string argument (username) and
                   return a single value (password). Required.

                       statement => 'SELECT password FROM users WHERE username = ?'

           •       username

                   Database username.

                       username => 'username'

           •       password

                   Database password.

                       password => 'secret'

           •       log

                   Any object that supports "debug", "info", "error" and "warn".

                       log => Log::Log4perl->get_logger('Authen::Simple::DBI')

       •   authenticate( $username, $password )

           Returns true on success and false on failure.

SEE ALSO

       Authen::Simple.

       Authen::Simple::Password.

       DBI.

AUTHOR

       Christian Hansen "ch@ngmedia.com"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same
       terms as Perl itself.