Yes I can connect to pgsql as nsadmin, but that is because as postgres, I created a db user named nsadmin. i.e. postgres works fine.
Where in the docs does it say to link libpq ? sometimes ? like when ? EXACTLY what file name should I link in ? It seems that EVERYONE has had major trouble with this postgres.so driver. It seems so mysterious, never certain.
Oh, well thanks for the input, here is my make file, what should I add to it in your estimation ? THANKS AGAIN for responding...
makefile from openacs for pgdriver 1.1 [with my mods]
# Location of the PostgreSQL libraries
PGLIB=/usr/local/pgsql/lib
# Location of the PostgreSQL includes
PGINC=/usr/local/pgsql/include
# Location of the AOLserver files (normally the ~nsadmin directory):
NSHOME=/home/aolserver
NSINC=/var/local/src/aolserver3_0/include
CC=gcc
COPTS=-Wall -fpic -shared -I$(PGINC) -I$(NSINC) -I-/usr/include
# You should not need to edit anything below this line.
EXTRA_OBJS=$(PGLIB)/libpq.so.2.1
OBJS=postgres.o
MODULE=postgres.so
CFLAGS=-DFOR_ACS_USE -I$(NSINC) $(COPTS)
LDFLAGS=-shared -I$(PGINC) -I$(NSINC) -I-/usr/include
all: $(MODULE)
$(MODULE): $(OBJS)
gcc $(LDFLAGS) -o $(MODULE) $(OBJS) $(EXTRA_OBJS)
install: $(MODULE)
cp $(MODULE) $(NSHOME)/bin/
chmod +x $(NSHOME)/bin/$(MODULE)
clean:
rm -f *.o *.so
