ryan, did you do this? - edit config_vars.mk vi build/config_vars.mk add "-I/usr/local/pgsql/include" to the end of EXTRA_INCLUDES add "-lpq -L/usr/local/pgsql/lib" to the end of EXTRA_LIBS ? On Fri, Apr 02, 2004 at 12:49:43AM -0500, Ryan Riehle wrote: > 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 -- joe speigle www.sirfsup.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly