Im trying to use mod_authn_dbd with pgsql my table structure is 3
columns username,password,group. When I try to login into the
protected directory I get a 500 error. My apache conf is below. My
logs are [Sun Sep 09 20:04:05 2007] [error] [client 127.0.0.1] Error
looking up blah in database
#Database Management
#Use the PostgreSQL driver
DBDriver pgsql
#Connection string: database name and login credentials
DBDParams "dbname=bigsteps user=admin password=xxxx"
#Parameters for Connection Pool Management
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
#Authentication Section
<Directory /var/www/bigstepslittlefeet.org/test>
#mod_auth configuration for authn_dbd
AuthType Basic
AuthName "My Server"
AuthBasicProvider dbd
#authz configuration
Require valid-user
#SQL query to verify a user
#(note: DBD drivers recognise both stdio-like %s and
native syntax)
AuthDBDUserPWQuery "select password from authn where
username = %s"
</Directory>
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
