Howto Apache2::AuthCookieDBI and followup question
Tosh Cooey <[email protected]>
| Newsgroups | gmane.comp.apache.mod-perl |
|---|---|
| Organization | Twelve Hundred Group LLC |
| Message-ID | <[email protected]> |
Ok, so it seems with Apache > 2.4 the functionality of Apache2::AuthCookieDBI can be duplicated using modules, specifically: mod_auth_form AND mod_authn_dbd This article gives a good writeup about it: https://kodingnotes.wordpress.com/2013/02/26/authentication-in-apache2-4-part-1-installation/ In the config file you just need: DBDriver mysql DBDParams "dbname=myDB,user=root,pass=XXX" <Location /private> AuthFormProvider dbd AuthType form AuthName private Session On SessionCookieName session path=/ SessionCryptoPassphrase secret ErrorDocument 401 /login.html # mod_authz_core configuration Require valid-user # mod_authn_dbd SQL query to authenticate a user AuthDBDUserPWQuery "SELECT password FROM apache_user WHERE username = %s" </Location> Now the followup. I personally need extra dynamism, specifically I need DBDParams and SessionCookieName to be dynamic for each request. Intense googling has lead me to believe I can do so within a <Perl> block, something like: When the user requests www.site.com/client_identifier/*anything* then the <Perl> block needs to get $client_identifier from the URI and then get $host, $database, $username, $password via: select host, database, username, password from clients where client = $client_identifier But I'm kind of at a bit of a loss how to accomplish this. Anyone here have any hints? Thanks, and I hope this helps rescue people from Apache2::AuthCookieDBI Tosh -- McIntosh Cooey - Twelve Hundred Group LLC - http://www.1200group.com/