basic_db_auth(1) [centos man page]

BASIC_DB_AUTH(1)					User Contributed Perl Documentation					  BASIC_DB_AUTH(1)

NAME

       basic_db_auth - Database auth helper for Squid

SYNOPSIS

       basic_db_auth [options]

DESCRIPTOIN

       This program verifies username & password to a database

       --dsn   Database DSN. Default "DBI:mysql:database=squid"

       --user  Database User

       --password
	       Database password

       --table Database table. Default "passwd".

       --usercol
	       Username column. Default "user".

       --passwdcol
	       Password column. Default "password".

       --cond  Condition, defaults to enabled=1. Specify 1 or "" for no condition If you use --joomla flag, this condition will be changed to
	       block=0

       --plaintext
	       Database contains plain-text passwords

       --md5   Database contains unsalted md5 passwords

       --salt  Selects the correct salt to evaluate passwords

       --persist
	       Keep a persistent database connection open between queries.

       --joomla
	       Tells helper that user database is Joomla DB.  So their unusual salt hashing is understood.

COPYRIGHT

       Copyright (C) 2007 Henrik Nordstrom <henrik@henriknordstrom.net> Copyright (C) 2010 Luis Daniel Lucio Quiroz <dlucio@okay.com.mx> (Joomla
       support) This program is free software. You may redistribute copies of it under the terms of the GNU General Public License version 2, or
       (at youropinion) any later version.

perl v5.16.3							    2014-06-09							  BASIC_DB_AUTH(1)

Authen::Simple::DBI(3pm)				User Contributed Perl Documentation				  Authen::Simple::DBI(3pm)

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.

perl v5.8.8							    2008-02-29						  Authen::Simple::DBI(3pm)