[users@httpd] Apache 2.2 and mod_dbm + pgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hallo,
 
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.
 
Description:
When starting apache webserver (self-compiled on SuSe Linux 9.1) I get the
following error message:
>>
Syntax error on line 13 of
/usr/local/apache22/conf/vhost.gforge-iklk.de-mod_auth_dbd-pgsql.conf:
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
DAV On
AuthBasicProvider dbd
# think of permissions ...!!!
# but this is only the first step
# -> real repositories have to get their special permissions for every
repository!
   AuthType Basic
   AuthName "GForge WebDAV Network Drive directory at iklk.de"

# 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'"

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



[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux