Hmmm not sure really but that driver name sounds like is for PostgreSQL database :)
On Sep 16, 2011 7:01 AM, "J.Lance Wilkinson" <
jlw12@xxxxxxx> wrote:
> Apologies in advance if this isn't formatted or researched as you'd like. I've
> been using Apache HTTPD for many, many years, but have never needed to set this
> aspect of configuration up.
>
> In the wake of last week's "Single Value Authentication Module" query, and the
> decision to follow the sage advice from that thread, my colleagues and I have
> decided to use a database lookup to authenticate the user. This way we can
> hopefully use mostly off-the-shelf components, and have the specialized
> business logic involved in denying access to the resource when the user's
> authorization has expired simply be part of the database query (query would
> only return passwords for users whose access is not expired).
>
> So, I've read the documentation for mod_dbd and mod_authn_dbd for Apache 2.2.x
> and those modules are compiled and ready for loading.
>
> The database involved will be an ORACLE database.
>
> I set up a configuration to test this, pretty much following the example in the
> mod_authn_dbd documentation:
>
> DBDriver pgsql
> DBDMin 4
> DBDKeep 8
> DBDMax 20
> DBDExptime 300
>
> <Location ~ "^/(.*)/restrictedArea(.html|/(.*)?)$">
>
> DBDParams "dbname=george user=yogi password=fred"
> AuthType Basic
> AuthName "Restricted Access: Supply appropriate credentials"
> AuthBasicProvider dbd
> Require valid-user
> AuthDBDUserPWQuery \
> "SELECT password FROM authn WHERE user = %s AND expired = no"
> </Location>
>
> Syntax scan is fine EXCEPT for DBDriver line. It reports:
>
> DBD: No driver for pgsql
>
> Now, I am NOT a Database person. I used what was in the mod_authn_dbd
> documentation just to get started. The mod_dbd docs says this selects an
> apr_dbd driver name. It's not clear to me if I even HAVE any apr_dbd drivers
> installed on this machine (yet). Presuming somebody locally will be taking
> care of setting up the Oracle connection(s) needed, what apr_dbd stuff do I
> need, where do I find it, what do I do with it?
>
> I've looked for cookbooks on this (including my dog-eared copy of Ken and
> Rich's _Cookbook_ ;-P) and haven't found anything yet.
>
> Somebody take pity?
>
> --
> J.Lance Wilkinson ("Lance") InterNet:
Lance.Wilkinson@xxxxxxx
> Systems Design Specialist - Lead Phone: (814) 865-4870
> Digital Library Technologies FAX: (814) 863-3560
> E3 Paterno Library
> Penn State University
> University Park, PA 16802
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:
http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail:
users-unsubscribe@xxxxxxxxxxxxxxxx> " from the digest:
users-digest-unsubscribe@xxxxxxxxxxxxxxxx
> For additional commands, e-mail:
users-help@xxxxxxxxxxxxxxxx>
