(OTBNFO) Apache Basic Realm Authentication via SQL Database?

princepawn has asked for the wisdom of the Perl Monks concerning the following question:

I have been looking through the Apache documentation for some info on validating usernames and passwords by the use of a SQL database, but the docs for Apache imply that only flat text files and Berkeley DB files can be used.

Is this really the case?

'OTBNFO' eq 'Off topic, but not far off';

Comment on (OTBNFO) Apache Basic Realm Authentication via SQL Database? Download Code

Replies are listed 'Best First'.
Re: (OTBNFO) Apache Basic Realm Authentication via SQL Database? by Kanji (Parson) on Apr 14, 2001 at 01:46 UTC
Depends if you turn to third-party mods or not. mod_auth_mysql mod_auth_pgsql mod_auth_tds (for Sybase/MS SQL) mod_auth_oracle etc. Of course, (and to keep things on topic for PerlMonks `:)`) you can always try something like Apache::AuthzDBI with mod_perl, or some custom perl script with mod_auth_external. --k.	[reply]
Re: (OTBNFO) Apache Basic Realm Authentication via SQL Database? by princepawn (Parson) on Apr 14, 2001 at 01:39 UTC
Come to think of it, this is not off-topic at all. There are a couple of CPAN modules that will work. Someone tipped me off in the chatterbox, but I guess they didn't want their name affiliated with such an off-topic node. Apache::AuthCookieDBI and Apache::DBILogin are my tickets to paradise on this one.	[reply]
Modules and Apache's Not-So-C-MAN by TGI (Parson) on Apr 14, 2001 at 00:44 UTC
Offtopic - naughty naughty. I haven't done SQL authentication in apache, but just did a bunch of work looking at diff't auth schemes. The answer is simple, you will need to find a module that will do it. Just becuase the standard set doesn't include one, doesn't mean it doesn't exist. Also check source forge or anywhere else you would look for good software. Or you could write your own module in perl (we're back on topic). OReilly has a book you might want to look at. I haven't needed to go that far, so I can't comment on the book's quality, but it is an OReilly book. TGI says moo	[reply]