You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Dustin Schuemann <ds...@gmail.com> on 2007/09/10 02:34:24 UTC
[users@httpd] Apache 2.2.3 with mod_authn_dbd and pgsql
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@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] Apache 2.2.3 with mod_authn_dbd and pgsql
Posted by Vincent Bray <no...@gmail.com>.
On 10/09/2007, Dustin Schuemann <ds...@gmail.com> wrote:
> 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
A lot of work has gone in to dbd in the latest 2.2.6 release and
several bugs were fixed. I recommend you try that instead.
--
noodl
---------------------------------------------------------------------
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@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
[users@httpd] RE : [users@httpd] Apache 2.2.3 with mod_authn_dbd and pgsql
Posted by Laurent FAILLIE <l_...@yahoo.com>.
Hi Dustin,
--- Dustin Schuemann <ds...@gmail.com> a écrit :
> 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
I wasn't able to make authentication against pgsql
database to work w/ 2.2.4 (see this mailling list
archive). I have also opened a bug report on the same
and a fix has been proposed.
As I'm in paternity leave (YEAHHHH :-)) I can't test
it before next week. I duno if this fix has been
promoted to 2.2.6
Bye
Laurent
The misspelling master is on the Web.
_________ 100 % Dictionnary Free !
/ /(
/ Dico / / Pleins d'autres fautes sur
/________/ /
(#######( / http://destroyedlolo.homeunix.org
Quoi, des fautes d'orthographe! Pas possible ;-D.
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
---------------------------------------------------------------------
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@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org