Re: Problems compiling Apache 2.0.49 with mod_auth_pgsql

I'm using mod_auth_pgsq, version 2.0.1... it's for use with apache 2.0.x got
it from their site: http://www.giuseppetanzilli.it/mod%5Fauth%5Fpgsql2/

-Ryan

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of joseph speigle
Sent: Thursday, April 01, 2004 10:55 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

hi ryan,
I think something is wrong with your --with-module line in the configure.
Syntax should be

--with-module=module-type:module-file
Enable module-file in the modules/<module-type>
but it's not in modules/aaa {just downloaded this from their site}

[root(at)www httpd-2.0.49]# ls modules/aaa
config.m4 mod_access.dsp mod_auth_anon.dsp mod_auth_dbm.c
mod_auth_digest.c mod_auth.exp NWGNUdigest
Makefile.in mod_access.exp mod_auth_anon.exp mod_auth_dbm.dsp
mod_auth_digest.dsp NWGNUauthanon NWGNUmakefile
mod_access.c mod_auth_anon.c mod_auth.c mod_auth_dbm.exp
mod_auth.dsp NWGNUauthdbm

and it's not part of the distribution, maybe it doesn't work to just put it
in some directory and try to get the --with-module flag to compile it. In
fact, for 1.3.x you had to compile in its separate directory and then
compile apache with the --activate-module= flag, but that configure option
is lost in 2.0.x. so .... and mod_auth_pgsql doesn't say it's work for
2.0.x only for 1.3.x as per their web site. I would try the apxs build.
The problem with the build you are doing is that its' not linking against
-lpq anywhere.

On Thu, Apr 01, 2004 at 08:58:28PM -0500, Ryan Riehle wrote:
> Hi All!
>
> Trying to upgrade to Apache 2.0.49 and getting compile errors related
> to mod_auth_pgsql, any clue?:
>
> make[1]: Entering directory `/usr/src/httpd-2.0.49'
> /usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc
> -pthread -I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE
> -DAP_HAVE_DESIGNATED_INITIALIZER I. -I/usr/src/httpd-2.0.49/os/unix
> -I/usr/src/httpd-2.0.49/server/mpm/prefork -I .49/modules/proxy
> -I/usr/src/httpd-2.0.49/include -I/usr/src/httpd-2.0.49/module -o
> httpd modules.lo modules/aaa/mod_access.la modules/aaa/mod_auth.la
> modules s/metadata/mod_env.la modules/metadata/mod_mime_magic.la
> modules/metadata/mod_ex _setenvif.la modules/ssl/mod_ssl.la
> modules/http/mod_http.la modules/http/mod_mi a
> modules/generators/mod_autoindex.la modules/generators/mod_asis.la
> modules/gen ers/mod_dir.la modules/mappers/mod_imap.la
> modules/mappers/mod_actions.la module ork/libprefork.la
> server/libmain.la os/unix/libos.la -lssl -lcrypto /usr/src/htt ldb-4.0
> -lexpat -liconv /usr/src/httpd-2.0.49/srclib/apr/libapr-0.la -lrt -lm
> -l
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x470): In
> function
> : undefined reference to `PQsetdbLogin'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x482): In
> function
> : undefined reference to `PQstatus'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x49a): In
> function
> : undefined reference to `PQreset'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x4aa): In
> function
> : undefined reference to `PQerrorMessage'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x4d2): In
> function
> : undefined reference to `PQstatus'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x4e6): In
> function
> : undefined reference to `PQerrorMessage'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x51d): In
> function
> : undefined reference to `PQexec'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x53c): In
> function
> : undefined reference to `PQerrorMessage'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x56e): In
> function
> : undefined reference to `PQresultStatus'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x580): In
> function
> : undefined reference to `PQclear'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x59a): In
> function
> : undefined reference to `PQresultStatus'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x5b5): In
> function
> : undefined reference to `PQerrorMessage'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x5db): In
> function
> : undefined reference to `PQclear'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x5f5): In
> function
> : undefined reference to `PQntuples'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x610): In
> function
> : undefined reference to `PQgetvalue'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x629): In
> function
> : undefined reference to `PQerrorMessage'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x64f): In
> function
> : undefined reference to `PQclear'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x6ad): In
> function
> : undefined reference to `PQclear'
> modules/aaa/.libs/mod_auth_pgsql.al(mod_auth_pgsql.lo)(.text+0x6d5): In
> function
> : undefined reference to `PQclear'
> collect2: ld returned 1 exit status
> make[1]: *** [httpd] Error 1
> make[1]: Leaving directory `/usr/src/httpd-2.0.49'
> make: *** [all-recursive] Error 1
>
> System is Redhat 9 running kernel 2.4.25... It still compiles fine
> with apache 2.0.48... I must be missing something, because I don't see
> others having similar problems... My configure command is as follows:
>
> CFLAGS="-I/usr/kerberos/include -DSECURITY_HOLE_PASS_AUTHORIZATION"
> ./configure --prefix=/usr/apache2 --datadir=/www --enable-auth-digest
> --enable-mime-magic --enable-expires --enable-headers
> --enable-usertrack --enable-static-rotatelogs --enable-http
> --enable-dav --enable-dav-fs -enable-cgi --enable-so --enable-ssl
> --with-module=aaa:../mod_auth_pgsql-2.0.1/mod_auth_pgsql.c
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match