compiling mod_auth_pgsql

Hello,

I posted this message to pgsql-interfaces but I figured I'd post to the general
list as well.

I'm trying to install mod_auth_pgsql 0.9.12 with apache 1.3.27 on Red Hat Linux
8.  I've followed the directions for installation to the letter, but the apache
'make' command dies on me, complaining that it can't find libpq.so.3 even though
it exists in my /usr/local/pgsql/lib directory.  What's strange is that it dies
during part of the apache 'make' that seems to have nothing to do with the
mod_auth_pgsql module.

Does anyone have any tips or pointers on this?  I previously installed this
statically into apache with success, but apparently the documentation I wrote
then missed something since it won't work now :-(  Below is the output from the
configure and make commands I used to build the module and apache.  Any help
would be greatly appreciated - thanks.



[root@vanadium apache_1.3.27]# ./configure --prefix=/usr/local/apache
Configuring for Apache, Version 1.3.27
 + using installation path layout: Apache (config.layout)
Creating Makefile
Creating Configuration.apaci in src
Creating Makefile in src
 + configured for Linux platform
 + setting C compiler to gcc
 + setting C pre-processor to gcc -E
 + checking for system header files
 + adding selected modules
 + using system Expat
 + checking sizeof various data types
 + doing sanity check on compiler and options
Creating Makefile in src/support
Creating Makefile in src/regex
Creating Makefile in src/os/unix
Creating Makefile in src/ap
Creating Makefile in src/main
Creating Makefile in src/modules/standard
[root@vanadium apache_1.3.27]# cd ../mod_auth_pgsql-0.9.12
[root@vanadium mod_auth_pgsql-0.9.12]# ./configure
--with-apache=/usr/local/src/apache_1.3.27 --with-pgsql=/usr/local/pgsql
creating cache ./config.cache
checking for gcc... gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for ranlib... ranlib
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for static Apache module support... yes - Apache 1.3.x
checking for Apache module support via DSO through APXS... no
checking for pgsql... checking for pgsql lib... checking for pgsql include...
found in /usr/local/pgsql
updating cache ./config.cache
creating ./config.status
creating Makefile
creating Makefile.tmpl
creating mod_auth_pgsql.module
creating config.h
[root@vanadium mod_auth_pgsql-0.9.12]# make
cc -c   -I/usr/local/src/apache_1.3.27/src/include
-I/usr/local/src/apache_1.3.27/src/os/unix -I/usr/local/pgsql/include -g -O2
-DEAPI -fPIC mod_auth_pgsql.c -o mod_auth_pgsql.o
rm -f mod_auth_pgsql.a
ar rc mod_auth_pgsql.a mod_auth_pgsql.o
ranlib mod_auth_pgsql.a
[root@vanadium mod_auth_pgsql-0.9.12]# make install
mkdir -p /usr/local/src/apache_1.3.27/src/modules/auth_pgsql; cp mod_auth_pgsql.a
 mod_auth_pgsql.c mod_auth_pgsql.exp Makefile.tmpl Makefile.libdir
mod_auth_pgsql.module auth_pgsql_shared_stub.c
/usr/local/src/apache_1.3.27/src/modules/auth_pgsql
[root@vanadium mod_auth_pgsql-0.9.12]# cd ../apache_1.3.27
[root@vanadium apache_1.3.27]# ./configure --prefix=/usr/local/apache
--activate-module=src/modules/auth_pgsql/mod_auth_pgsql.c
Configuring for Apache, Version 1.3.27
 + using installation path layout: Apache (config.layout)
 + activated auth_pgsql module (modules/auth_pgsql/mod_auth_pgsql.c)
Creating Makefile
Creating Configuration.apaci in src
Creating Makefile in src
 + configured for Linux platform
 + setting C compiler to gcc
 + setting C pre-processor to gcc -E
 + checking for system header files
 + adding selected modules
    o auth_pgsql_module uses ConfigStart/End
 + using system Expat
 + checking sizeof various data types
 + doing sanity check on compiler and options
Creating Makefile in src/support
Creating Makefile in src/regex
Creating Makefile in src/os/unix
Creating Makefile in src/ap
Creating Makefile in src/main
Creating Makefile in src/modules/standard
Creating Makefile in src/modules/auth_pgsql
[root@vanadium apache_1.3.27]# make
===> src
make[1]: Entering directory `/usr/local/src/apache_1.3.27'
make[2]: Entering directory `/usr/local/src/apache_1.3.27/src'
===> src/regex
sh ./mkh  -p regcomp.c >regcomp.ih
gcc -I.  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` -DPOSIX_MISTAKE   -c -o regcomp.o regcomp.c
sh ./mkh  -p engine.c >engine.ih
gcc -I.  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` -DPOSIX_MISTAKE   -c -o regexec.o regexec.c
gcc -I.  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` -DPOSIX_MISTAKE   -c -o regerror.o regerror.c
gcc -I.  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` -DPOSIX_MISTAKE   -c -o regfree.o regfree.c
rm -f libregex.a
ar cr libregex.a regcomp.o regexec.o regerror.o regfree.o
ranlib libregex.a
<=== src/regex
===> src/os/unix
gcc -c  -I../../os/unix -I../../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../../apaci` os.c
gcc -c  -I../../os/unix -I../../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../../apaci` os-inline.c
rm -f libos.a
ar cr libos.a os.o os-inline.o
ranlib libos.a
<=== src/os/unix
===> src/ap
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_cpystrn.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_execve.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_fnmatch.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_getpass.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_md5c.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_signal.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_slack.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_snprintf.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_sha1.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_checkpass.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_base64.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_ebcdic.c
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` ap_strtol.c
rm -f libap.a
ar cr libap.a ap_cpystrn.o ap_execve.o ap_fnmatch.o ap_getpass.o ap_md5c.o
ap_signal.o ap_slack.o ap_snprintf.o ap_sha1.o ap_checkpass.o ap_base64.o
ap_ebcdic.o ap_strtol.o
ranlib libap.a
<=== src/ap
===> src/main
gcc -c  -I../os/unix -I../include   -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED
`../apaci` gen_test_char.c
gcc  -DLINUX=22 -DUSE_HSREGEX -DNO_DL_NEEDED `../apaci`   -o gen_test_char
gen_test_char.o  -L/usr/local/pgsql/lib -lpq  -lm -lcrypt -lexpat
./gen_test_char >test_char.h
./gen_test_char: error while loading shared libraries: libpq.so.3: cannot open
shared object file: No such file or directory
make[3]: *** [test_char.h] Error 127
make[2]: *** [subdirs] Error 1
make[2]: Leaving directory `/usr/local/src/apache_1.3.27/src'
make[1]: *** [build-std] Error 2
make[1]: Leaving directory `/usr/local/src/apache_1.3.27'
make: *** [build] Error 2
[root@vanadium apache_1.3.27]#