Re: Problems compiling Apache 2.0.49 with mod_auth_pgsql

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: [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@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