Forum OpenACS Q&A: Installation of OpenACS 5 w/FreeBSD 5.2.1 AOL4.0, Postgre73

Collapse
1: Installation of OpenACS 5 w/FreeBSD 5.2.1 AOL4.0, Postgre73
Posted by Tyge Cawthon on 05/17/04 03:03 AM
Fist of all I would like to thank the OpenACS community for making this software available for use.

Spec:
FreeBSD 5.2.1
AOLServer 4.0
PostgreSQL 7.3.4_1

I am following the instructions from:http://www.orchardlabs.com/

FreeBSD and AOLServer seemed to be O.K.

For PostgreSQL, I cd /usr/ports/databases/postgresql73 andexecuted the MAKE, MAKE INSTALL and MAKE CLEAN commands.

I did NOT use gmake install-all-headers as suggested by orchardlabs.

FYI for FreeBSD users. The port collection for PostgreSQL creates a user pgsql.  The postgres user needs to be added as noted from the above link.

I added the id postgres to match pgsql in the passwd.

This is where I need help.
http://www.orchardlabs.com/library/freebsd/postgresql
steps 34-40

34. Download the PostgreSQL driver (nspostgres-4.0beta1) from http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577
35. wget http://unc.dl.sourceforge.net/sourceforge/aolserver/nspostgres-4.0beta1.tar.gz
Visit http://prdownloads.sourceforge.net/aolserver/nspostgres-4.0beta1.tar.gz?download for a full list of mirror sites.

FIRST Question - I noticed that nspostgres-4 had been released.  Should I use the released version or the beta version?

36. cd aolserver-4.0
37. tar xzvf ../nspostgres-4.0beta1.tar.gz
38. cd nspostgres-4.0beta1
39. Edit the Makefile

add:
ACS=1
POSTGRES=1 (it's just to keep make happy)
change:

ifeq ($(POSTGRES),LSB)
    PGLIB = /usr/lib
    PGINC = /usr/include
else
    PGLIB = $(POSTGRES)/lib
    PGINC = $(POSTGRES)/include
endif

to:

ifeq ($(POSTGRES),LSB)
    PGLIB = /usr/lib
    PGINC = /usr/include
else
    #PGLIB = $(POSTGRES)/lib
    #PGINC = $(POSTGRES)/include
    PGLIB = /usr/local/lib/postgresql
    PGINC = /usr/local/include/postgresl/
endif

SECOND Question:
Does this line have a mistake:
PGINC = /usr/local/include/postgresl/
should be
PGINC = /usr/local/include/postgresql
???

40. gmake

This is the error I get when I use the gmake command:
bash-2.05b# gmake
cc -pipe -DBIND_EMULATION -I/usr/local/include/postgresql -DFOR_ACS_USE -O -Wall -Wconversion -Wno-implicit-int -fPIC -pthread -I/usr/local/aolserver/include -I/usr/local/include/tcl8.4 -DNO_CONST  -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1-DTCL_WIDE_INT_TYPE=long\ long -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DNO_VALUES_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DNO_UNION_WAIT=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_PUTENV_THAT_COPIES=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1  -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE_CMMSG=1    -c -o nspostgres.o nspostgres.c
In file included from nspostgres.c:32:
nspostgres.h:48:22: libpq-fe.h: No such file or directory

After the above line, I get a lot of other errors. I believe these errors are from the above problem.

Any suggestions would be appriecated.
Tyge Cawthon