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