httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Pfannkuchen" <>
Subject [users@httpd] Apache 2.2 and mod_dbm + pgsql
Date Wed, 11 Jan 2006 19:41:50 GMT
I'm just trying to replace mod_auth_pgsql with the APR-DBM Module of httpd
2.2 - but - obviously - can't get the pgsql driver working.
When starting apache webserver (self-compiled on SuSe Linux 9.1) I get the
following error message:
Syntax error on line 13 of
DBD: No driver for pgsql

The dbm-pgsql config ...
>> ...
#Database Management

#Use the PostgreSQL driver
DBDriver pgsql

#Connection string: database name and login credentials
DBDParams "dbhost=localhost dbname=gforge user=gforge pass=xxxxx"

#Parameters for Connection Pool Management
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

<Location /netzlaufwerk/>
Options Indexes
AuthBasicProvider dbd
# think of permissions ...!!!
# but this is only the first step
# -> real repositories have to get their special permissions for every
   AuthType Basic
   AuthName "GForge WebDAV Network Drive directory at"

# Provider dbd setup ...
#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"
#AuthDBDUserRealmQuery "SELECT password FROM authn WHERE username = %s AND
realm = %s"
AuthDBDUserRealmQuery "SELECT select user_pw as password from users u join
iklk_user_group i on u.user_name=i.user_name where
 u.user_name = '%s' and i.unix_group_name='%s'"

SSLVerifyClient none
... <<


Apache compilation was done as follows ...

Step 1: manually build apr and apr-util specific for this installation
(thats the trick!!!) -> and think of pgsql!!!
# Build and install apr 1.2
cd srclib/apr
./configure --prefix=/usr/local/apr-httpd/
make install

# Build and install apr-util 1.2
cd ../apr-util
./configure --prefix=/usr/local/apr-util-httpd/
--with-apr=/usr/local/apr-httpd/ --with-pgsql=/usr/local/pgsql
make install

Step 2:
"./configure" \
"--prefix=/usr/local/apache22/" \
"--with-apr=/usr/local/apr-httpd/" \
"--with-apr-util=/usr/local/apr-util-httpd/" \
"--enable-rewrite=shared" \
"--enable-ssl" \
"--enable-proxy" \
"--enable-dav" \
"--enable-info" \
"--enable-vhost-alias" \
"--enable-dbd" \
"--enable-authn-dbd" \
make install


Anyone knows how to make the dbm-pgsql driver known to Apache 2.2 ?

Thx for all help : Michael

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