Questions on production rollout

Started by Bill Chandlerabout 22 years ago6 messagesgeneral

billybobc1210@yahoo.com

about 22 years ago

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

Andrew Sullivan

ajs@crankycanuck.ca

about 22 years ago

In reply to: Bill Chandler (#1)

Re: Questions on production rollout

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.

--
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

Ryan Riehle

rkr@buildways.com

about 22 years ago

In reply to: Bill Chandler (#1)

Problems compiling Apache 2.0.49 with mod_auth_pgsql

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

joseph speigle

joe.speigle@jklh.us

about 22 years ago

In reply to: Ryan Riehle (#3)

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

Ryan Riehle

rkr@buildways.com

about 22 years ago

In reply to: joseph speigle (#4)

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

joseph speigle

joe.speigle@jklh.us

about 22 years ago

In reply to: Ryan Riehle (#5)

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