Changes for version 0.82

  • bug-fix spotted by "Dale Manemann" <manemann@dubuque.net>: correct the password handling for the case, where the password has been changed in the database and the old password is still cached.
  • proposal from Honza Pazdziora <adelton@informatics.muni.cz>: add PerlCleanupHandler in Apache::DBI, which issues a rollback unless AutoCommit is on.
  • changed behavior of AuthzDBI: the first match of a requirement is sufficient for successful authorization. Prior to this release, all requirement lines had to be fulfilled.
  • proposal from Rauznitz Balazs <jomagam@yahoo.com>: new function all_handlers() in Apache::DBI.pm. Returns all cached database handles, so that other handlers can perform tasks on them.
  • proposal from Michael Smith <mjs@iii.co.uk>: new configuration option Auth_DBI_placeholder. Setting this option to true, will use placeholders for the given userid in the SELECT statements. This will speedup database access.
  • proposal from "Jordi 'Matematic' Salvat" <jordi@webarna.com>: replace AuthName with a summary of all attributes relevant for the select statements. This still keeps the userid entries in the cache unique, but solves the problem with different AuthNames which eventually forces the user to authenticate several times.
  • new configuration option Auth_DBI_expeditive from "Jordi 'Matematic' Salvat" <jordi@webarna.com>. When authorization fails, AuthzDBI returns AUTH_REQUIRED as default. With Auth_DBI_expeditive set to "on" it returns FORBIDDEN if access is denied. Hence this can be distinguished from the case, where the user just mistyped the password.
  • applied patch from Ask Bjoern Hansen <ask@valueclick.com>: get rid of some annoying "Use of uninitialized value ..."
  • applied patch from Joshua Chamas <joshua@chamas.com>: use eval{ping} to prevent using an invalid database handle.
  • added 'use Apache;' to Apache::DBI.pm as proposed by Michael Smith <mjs@iii.co.uk>.
  • implemented multiple passwords per userid as proposed by dan hammer <dhammer@verio.net>.
  • applied patch for case-insensitive user-ids from <grussell@wiley.com>.
  • implement proposal from Honza Pazdziora <adelton@informatics.muni.cz>: Auth_DBI_casesensitive replaced by Auth_DBI_uidcasesensitive and Auth_DBI_pwdcasesensitive.
  • applied patch from fdc@cliwe.ping.de (Frank D. Cringle): prevent "Use of uninitialized value warning" in error.log.
  • work-around for mod_perl problem spotted by Mike Hayward <hayward@loup.net>: when building mod_perl as dso, Apache::DBI was always skipping the connection cache.

Modules

Authentication via Perl's DBI
Authorization via Perl's DBI
Initiate a persistent database connection
Debug Apache::DBI modules

Provides

in DBI.pm

Examples