Apache::DBI is for caching dbh's, not authentication. It requires modperl.

If you want to do cookie authentication, look at Apache::ApacheCookie -- it offers a framework for setting up custom cookie authentication.