Forum OpenACS Q&A: Postgres driver question

Posted by Steven Baker on 01/10/01 01:46 AM

HI, I'm using Don Baccus's devshed artical to try and install
openACS/AOL/Postgres. When starting AOL Server I get errors in the
server log which seem to be problems with the postgres driver (code
snip below). I have tryed a gmake of the driver in nspostgres and get
the following response from the make.log, make: nothing to be done
for 'all'. I have looked in the documentation area of this site but
can't see an answer to this problem (although Don's article does state
that this is a common problem). I'm running on an intel box, Red Hat
6.2. Thanks for any help in advance.

08/Jan/2001:09:27:44][20015.1024][-main-] Notice: loading:
/home/aolserver/aolserver3_0/bin/nspostgres.so
[08/Jan/2001:09:27:44][20015.1024][-main-] Warning: could not load
/home/aolserver/aolserver3_0/bin/nspostgres.so:
/home/a$[08/Jan/2001:09:27:44][20015.1024][-main-] Error: nsd.db:
could not load driver: postgres
[08/Jan/2001:09:27:44][20015.1024][-main-] Error: nsd.db: no such
default pool: main
[08/Jan/2001:09:27:44][20015.1024][-main-] Notice: nsd.adp: mapped
/*.adp
[08/Jan/2001:09:27:44][20015.1024][-main-] Notice: loading:
/home/aolserver/aolserver3_0/bin/nssock.so
[08/Jan/2001:09:27:44][20015.1024][-main-] Notice: loading:
/home/aolserver/aolserver3_0/bin/nslog.so
[08/Jan/2001:09:27:44][20015.1024][-main-] Error: nslog:
mkdir(/home/aolserver/aolserver3_0/servers/acspg/modules/nslog/)
f$[08/Jan/2001:09:27:44][20015.1024][-main-] Error: could not load
"/home/aolserver/aolserver3_0/bin/nslog.so":
Ns_ModuleInit$[08/Jan/2001:09:27:44][20015.1024][-main-] Fatal: could
not load: /home/aolserver/aolserver3_0/bin/nslog.so
[08/Jan/2001:10:57:36][20188.1024][-main-] Warning: pid 20015 does not
exist
[08/Jan/2001:10:57:36][20188.1024][-main-] Notice: AOLserver/3.0
starting.

2: Response to Postgres driver question (response to 1)

Posted by Brett Schwarz on 01/10/01 08:17 PM

Looks like you are having trouble with more than the postgres driver. Are you sure that the drivers are in /home/aolserver/aoslerver3_0/bin directory, because that is where it is looking for them. If not, then you will have to change your config file to point the the directory where the drivers are (on mine they are /home/aolserver/bin). Make sure that the drivers are in there. In the make install, it should install the driver in the directory that is specified in the Makefile.

Also, if you are just starting out, then I would recommend going to AOLServer 3.2 instead of 3.0.

--brett

3: Response to Postgres driver question (response to 1)

Posted by Steven Baker on 01/11/01 05:03 AM

Hi, I'm afraid that the formatting was a bit strange on my last post. This is the salient line I am wondering about from my server log.

The postgres driver appeared to build correctly as per Don's instructions, and was then copied to the bin directory as suggested in the article. I presume that the other errors further down the log are a consiquence of this original error.

Thanks in advance.

[11/Jan/2001:13:48:30][394.1024][-main-] Warning: could not load /home/aolserver/aolserver3_0/bin/nspostgres.so: /home/aolserver/aolserver3_0/bin/nspostgres.so: undefined symbol: crypt

4: Response to Postgres driver question (response to 1)

Posted by Don Baccus on 01/11/01 09:19 PM

The article was written quite a long time ago, though it just recently showed up at devshed.

PG 7.*, somewhere along the line, began to require linking against crypt. You need to add "-lcrypt" to the line defining "MODLIBS" in the Makefile use to build nspostgres.so.

5: Response to Postgres driver question (response to 1)

Posted by Martin Scherbaum on 01/17/01 12:11 AM

Hi, the answer seems even more simple to me (since I experienced the same thing): just have a link in /home/aolserver/aolserver3_0/bin:

   ln -s postgres.so nspostgres.so

Then the file is there and may be loaded.