Mailing List Archive: Howto Apache2::AuthCookieDBI and followup question

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/

On Sat, 1 Oct 2016 00:16:59 +0200
Tosh Cooey <tosh@1200group.com> wrote:

>
> 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?
>

I don't know about the <Perl> block, but I would use the HeaderParser phase for this :

PerlModule your::module

<Location /private>

PerlHeaderParserHandler your::module

</Location>

and have your::module do the select host, etc... and set the cookie

--
Bien à vous, Vincent Veyron

https://compta.libremen.com
Logiciel libre de comptabilité générale