httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Pfannkuchen" <mpfannkuc...@iprobe.de>
Subject AW: [users@httpd] Apache 2.2 and mod_dbm + pgsql
Date Thu, 26 Jan 2006 17:50:50 GMT
Hm,

Maybe I should note, my problem is not related to mod_dbm, but to module
mod_dbd (Apache SQL/Database Framework). After doing some more
investigations I'm very sure to have pgsql driver compiled into apr-utils
(apr_dbd): but how to make this known to the Apache httpd? 

At the end it's running into the question: What modules should I configure
for compilation, what modules should the server load during runtime
(configuration in httpd.conf) to get Apache SQL/Database Framework with
DBDriver pgsql working?

Thx4all : Michael

-----Urspr√ľngliche Nachricht-----
Von: Michael Pfannkuchen [mailto:mpfannkuchen@iprobe.de] 
Gesendet: Mittwoch, 11. Januar 2006 20:42
An: users@httpd.apache.org
Betreff: [users@httpd] Apache 2.2 and mod_dbm + pgsql

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



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