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.