Forum OpenACS Q&A: setting up a second OpenAcs instace - problem loading nspostgres.so
[20/May/2008:18:35:24][30642.3084245216][-main-] Warning: modload: could not load /usr/local/aolserver/bin/nspostgres.so: libpq.so.5: cannot open shared object file: No such file or directory
[20/May/2008:18:35:24][30642.3084245216][-main-] Error: dbdrv: failed to load driver 'postgres'
I have done this before in older versions of OpenAcs and it was quite trivial.
I had a look through the forums and found this https://openacs.org/doc/openacs-5-1/tutorial-second-database.html
but I think this is about connecting to two database from the same openacs instance, rather than what I am trying to achieve
I'd be grateful for any further pointers.
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 https://openacs.org/doc/current/aolserver4.html here look for "nsd-postgres.txt" for instructions on setting it up.
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)
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?
[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
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.
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