Forum OpenACS Q&A: Re: setting up a second OpenAcs instace - problem loading nspostgres.so

A couple of questions:

Where is libpq.so.5 located in your system?
What are the permission on the shared lib and its path?
Under which user runs your nsd?

/usr/local/pgsql/lib/libpq.so.5

~~~~~~~~~~~~~~~~~~~~~~
[root@vps ~]# ls -al /usr/local/pgsql
.
.

drwxr-xr-x 3 postgres web 2048 May 17 01:11 lib
.
.
.
.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

lrwxrwxrwx 1 postgres web 12 May 17 01:11 libpq.so -> libpq.so.5.1
lrwxrwxrwx 1 postgres web 12 May 17 01:11 libpq.so.5 -> libpq.so.5.1
-rwxr-xr-x 1 postgres web 111295 May 17 01:11 libpq.so.5.1

~~~~~~~~~~~~~~~~~~~~~~~~~~~

nsd is run in both situations by the same user who is member of the web group

You are sure, this is the libpq, which was used for linking with nspostgres.so? When you are on linux, try "ldd /usr/local/aolserver/bin/nspostgres.so" to check the path.

We had a few years ago the problem, that psql worked perfectly, but aolserver was not able to load nspostgres. The problem were default permissions on the system that were used during the make install.... since aolserver switches to the specified user+group before loading the .so files, things went wrong withing aolserver. Sounds suspiciously like what you are seeing.

-gustaf

problem solved, silly syntax...

there was a mistake in the run script in daemontools. Indeed the issue was $LD_LIBRARY_PATH not being set.

thank you both for your help