httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ned Wolpert" <>
Subject [users@httpd] Bug or configure error with mod_dbd and pgsql using Apache 2.2.3
Date Mon, 16 Jul 2007 18:55:21 GMT

  I'm seeing a problem where authentication for a user on my site
using the mod_dbd structure works just fine for about 10 mins, then
fails if 'pooling' (DBDPersist) is on, and works all the time if
DBDPersist is off.  When it starts failing, the postgresql logs
complain authn_dbd_1 isn't found

ERROR:  prepared statement "authn_dbd_1" does not exist

and apache just says no such user...

user chemicalx not found: /protected_folder/

It 'seems' to me that the connections are timing out and when rebuilt
do not have the prepared statement anymore and when it gets the error
from postgresql, it simply thinks there is no user.

  This is on a CentOS5 box using the CentOS packages for Apache,
postgresql client, etc.


The database server is CentOS5 as well, but runs PostgreSQL 8.2.4.
The configuration I added for the authentication this stuff...
(changed the hostname, password, etc, of course)

LoadModule dbd_module modules/
LoadModule authn_dbd_module modules/
DBDriver pgsql
DBDParams "dbname=httpd_auth user=httpd password=THEPASSWORD port=5432
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60
<VirtualHost _default_:443>
  Alias /protected_folder/ /d2/protected_folder
  <Directory /d2/protected_folder>
  Dav on
    AuthType Basic
    AuthName "Private Location"
    AuthBasicProvider dbd
    Require valid-user
    AuthDBDUserPWQuery "select u.password from httpd_users u,
httpd_groups g, httpd_user_groups ug where g.groupname='welcome_p
riv' and and and u.username=%s"

Any helps is appreciated... and if more information is needed, just ask.

Virtually, Ned Wolpert

"Settle thy studies, Faustus, and begin..."   --Marlowe

The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:> for more info.
To unsubscribe, e-mail:
   "   from the digest:
For additional commands, e-mail:

View raw message