Обсуждение: Questions on production rollout
Hello, Have heard great things about PostgreSQL as far as performance and stability and am considering using PostgreSQL in a production environment. However, I'm a little worried because our product will be installed on client machines with various configurations: shared memory params in /etc/system, patch levels, memory, disk space, etc., etc. I am wondering if somebody who has had some experience rolling out PostgreSQL into a production environment might give me some tips on where the major pitfalls are that I need to be aware of. Links and/or FAQs would be great. Just to give an idea about the source of my concerns: 1) A guy here had a compiled version of PostgreSQL for Solaris 8 that he gave me to install on my Solaris 8 system. He said just untar it and you're good to go. I did, then I tried using the psql command to connect his server that he already had up and running on his system. Got an error because I don't have a gcc library installed. So here's an example of an install that worked on one machine but not the other. Is it possible to build a version that one can be reasonably sure is going to run on all systems with a given OS? I mean, if I know the client machine is Solaris 8, can I build a self-contained set of binaries that I can confidently say will run on other Solaris 8 machines? 2) I realize there are other configuration parameters involved. E.g. already encountered "SHMMAX value to small" message when trying to start server on my system. I changed it to something big, rebooted and it still didn't work. I'm not too worried that I can't eventually figure it out but it still has me a little spooked. Wouldn't want to put a client thru hell trying to get the server up and running. Are there other system configuration gotchas I should be aware of? Thanks in advance, Bill
On Sat, Mar 20, 2004 at 07:04:42PM -0800, Bill C. wrote: > 1) A guy here had a compiled version of PostgreSQL for Solaris 8 > that he gave me to install on my Solaris 8 system. He said just > untar it and you're good to go. I did, then I tried using the > psql command to connect his server that he already had up and > running on his system. Got an error because I don't have a gcc > library installed. So here's an example of an install that worked > on one machine but not the other. Is it possible to build a > version that one can be reasonably sure is going to run on all > systems with a given OS? I mean, if I know the client machine is > Solaris 8, can I build a self-contained set of binaries that I > can confidently say will run on other Solaris 8 machines? Yes, but if you're using gcc you'll need either to make sure they have the relevant gcc libraries installed (see the sun freeware site for more on this), or you'll have to put together a little package of relevant libraries, install that with the postgres tree, and alter the user's LD_LIBRARY_PATH. I've used both these strategies, and they both work. > 2) I realize there are other configuration parameters involved. > E.g. already encountered "SHMMAX value to small" message when > trying to start server on my system. I changed it to something > big, rebooted and it still didn't work. I'm not too worried that > I can't eventually figure it out but it still has me a little > spooked. Wouldn't want to put a client thru hell trying to get > the server up and running. Are there other system configuration > gotchas I should be aware of? That's the biggest one. You should have a look at Chapter 16 of the docs (see e.g. <http://www.postgresql.org/docs/7.4/interactive/runtime.html>) for more detail. Solaris has just unbelievably low defaults for this, so you'll for sure need to do some work there on every client's machine. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland
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
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-moduleflag to compile it. In fact, for 1.3.x you had to compile in its separate directory and then compile
apachewith the --activate-module= flag, but that configure option is lost in 2.0.x. so .... and mod_auth_pgsql doesn't
sayit'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
youare 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
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
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