Forum OpenACS Q&A: can not install Postgresql 7.2.3/4 on SUSE 8.2

Hi,

we are interested in dotLRN and OpenACS, so we downloaded the dotLRN tarball and OpenACS instructions for installation. However, we can not get Postgresql version 7.2.3 or 7.2.4 installed.
.configure does not mention any errors in the console, and ends with the lines as mentioned in the installation manual. However, make all does end with several errors (error 1 and 2), preventing installation of Postgres.

We are completely new to Linux and dotLRN/OpenACS, Postgresql, so follow the OpenACS manual to the letter.

configure does not show any errors in the console, but there are errors in the log file, like cannot find readline, ledit.

Any idea what might be wrong?

See this thread. PG 7.3 is supported (simply assuming you are on PG 7.3): https://openacs.org/forums/message-view?message_id=132144

The distribution is Suse 8.2 - and some pathnames etc are slightly different from Red Hat and Debian.

Hi,

I don't know whether I can upload attachments to this forum, so will post some of the output here.

After a lot of checking statements, the console shows the following lines when running configure. This seems to suggest that configure has been successfull.

creating ./config.status
creating GNUmakefile
creating src/GNUmakefile
creating src/Makefile.global
creating src/backend/port/Makefile
creating src/include/pg_config.h
src/include/pg_config.h is unchanged
linking ./src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c
linking ./src/backend/port/dynloader/linux.h to src/include/dynloader.h
linking ./src/include/port/linux.h to src/include/pg_config_os.h
linking ./src/makefiles/Makefile.linux to src/Makefile.port
linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s

However, the generated config.log reports the following error:

configure:7270: checking for rl_completion_append_character
configure:7285: gcc -o conftest -O2    conftest.c -lz -lcrypt -lresolv -lnsl -ldl -lm  1>&5
configure: In function `main':
configure:7281: error: `rl_completion_append_character' undeclared (first use in this function)
configure:7281: error: (Each undeclared identifier is reported only once
configure:7281: error: for each function it appears in.)
configure: failed program was:
#line 7272 "configure"
#include "confdefs.h"
#include <stdio.h>
#ifdef HAVE_READLINE_READLINE_H
# include <readline/readline.h>
#elif defined(HAVE_READLINE_H)
# include <readline.h>
#endif

int main() {
rl_completion_append_character = 'x';
; return 0; }
configure:7303: checking for rl_completion_matches
configure:7303: checking for rl_filename_completion_function
configure:7358: checking for finite
configure:7367: gcc -o conftest -O2    conftest.c -lz -lcrypt -lresolv -lnsl -ldl -lm  1>&5
configure:7382: checking for sigsetjmp
configure:7391: gcc -o conftest -O2    conftest.c -lz -lcrypt -lresolv -lnsl -ldl -lm  1>&5
configure:7478: checking for optreset
configure:7516: checking test program
configure:7525: gcc -o conftest -O2    conftest.c -lz -lcrypt -lresolv -lnsl -ldl -lm  1>&5
configure:7545: checking whether long int is 64 bits
configure:7610: checking whether long long int is 64 bits
configure:7688: gcc -c -O2  conftest.c 1>&5
configure:7706: checking whether snprintf handles 'long long int' as %lld
configure:7742: gcc -o conftest -O2    conftest.c -lz -lcrypt -lresolv -lnsl -ldl -lm  1>&5
configure:7829: checking for strtoll

The make ends with the following errors:
make[3]: Leaving directory `/usr/local/src/postgresql-7.2.4/src/backend/utils'
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations  -Wl,-rpath,/usr/local/pgsql/lib -export-dynamic access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o rewrite/SUBSYS.o storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o -lz -lcrypt -lresolv -lnsl -ldl -lm  -o postgres
commands/SUBSYS.o(.text+0x4adf): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x4ae6): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x4b52): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x4b58): In function `DoCopy':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [postgres] Error 1
make[2]: Leaving directory `/usr/local/src/postgresql-7.2.4/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/local/src/postgresql-7.2.4/src'
make: *** [all] Error 2

Any pointers where to look for the cause of these errors are appreciated.

Thank you,

Francis

Suse has a system management tool called yast2 that might help you out some.  You can add/remove rpm software, and should be able to reinstall postgresql.

Different linux distributions can install files in wierd places.  I don't remember suse's defaults, but one way to find out is issueing a command to look for postgresql's text-based management interface:

find /* -name psql

Someone with more linux knowledge than me might be able to tell you if you can install an rpm to a specific location?  As Dirk said, check the irc channel, they are helpful.

Hi,

thank you for your replies. We ended up installing the RPM for Postgres 7.3.2 that comes with Suse, using Yast.

I'm still not sure yet, whether I should have installed in the path mentioned in the instruction. Sofar it seems to be working. I could make the test database.

Thank you for your suggestion to use the IRC channel (if we can find it).

Francis