Apache 2.2.3 with mod_authn_dbd and pgsql

[Dustin Schuemann <dschuemann@xxxxxxxxx>]

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: users-unsubscribe@xxxxxxxxxxxxxxxx
  "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx