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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of joseph speigle Sent: Thursday, April 01, 2004 10:55 PM To: pgsql-general@postgresql.org Subject: Re: 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@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@postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
