httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ned Wolpert" <ned.wolp...@gmail.com>
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
Folks-

  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.

httpd-2.2.3-7.el5.centos
apr-util-1.2.7-6
apr-1.2.7-11
postgresql-8.1.9-1.el5
postgresql-libs-8.1.9-1.el5

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/mod_dbd.so
LoadModule authn_dbd_module modules/mod_authn_dbd.so
DBDriver pgsql
DBDParams "dbname=httpd_auth user=httpd password=THEPASSWORD port=5432
host=DBHOST"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60
<VirtualHost _default_:443>
  ServerName www.theservername.com
  ...
  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 g.id=ug.httpd_groups_id and ug.httpd_users_id=u.id and u.username=%s"
    </Directory>
</VirtualHost>


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

-- 
Virtually, Ned Wolpert
http://www.codeheadsystems.com/blog/

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

---------------------------------------------------------------------
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


Mime
View raw message