Forum OpenACS Q&A: Re: setting up a second OpenAcs instace

3: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 1)

Posted by Dave Bauer on 05/21/08 03:42 AM

Looks like your LD_LIBRARY_PATH is not set.

Try starting it up frm the command line to see if you get the same error.

Try "echo $LD_LIBRARY_PATH" to see if the directory that contains libpq.so.5 is in the LD_LIBRARY_PATH.

You might need a shell script to set LD_LIBRARY_PATH when starting nsd.

See section 5 http://openacs.org/doc/current/aolserver4.html here look for "nsd-postgres.txt" for instructions on setting it up.

4: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 3)

Posted by Pavel Boghita on 05/21/08 10:20 AM

thank you dave, but the problem is not the path I don't think.
When using the version of OpenAcs 5.4.1 downloaded yesterday I run into this problem.
When using a version downloaded a week prior all is well.

I have checked what you suggested and it is fine. It appears to be something in the new download OpenAcs 5.4.1 that is causing this.
The problem is that I don't know where to look (the config file is not the issue as I am using literally the same one in both cases)

5: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 4)

Posted by Gustaf Neumann on 05/21/08 12:31 PM

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?

6: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 5)

Posted by Pavel Boghita on 05/21/08 02:49 PM

/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

7: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 6)

Posted by Gustaf Neumann on 05/21/08 03:23 PM

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

8: Re: setting up a second OpenAcs instace - problem loading nspostgres.so (response to 7)

Posted by Pavel Boghita on 05/21/08 03:38 PM

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

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