Forum OpenACS Q&A: Re: aolserver failing to load postgres driver

Collapse
Posted by Carl Robert Blesius on
Have you looked to see if the driver is actually named "nspostgres.so"? Just took a quick look on an OpenACS site I set up last year and the config.tcl file points to "postgres.so" (I remotely remember having a similar problem and having to change that).
Collapse
Posted by Sergio Fortuna on
Hi Carl,
Thanks for your reply.
The driver is named correctly and the config.tcl points to nsposgres.so. I will try to reinstall the driver or AOLserver that doesn't work.
Collapse
Posted by Orzenil Silva Junior on
Hi Sergio,

Are you sure this problem is not postgresql installation related?

I saw an error like you are reporting once a time in a postgresql list about installed postgresql from source and linkage from libecpg.so with ssl. Sorry I dont remember where...

If youre running postgresql from source try a solution to  add LD_LIBRARY_PATH to your env (if you didn't done it yet) before loading nspostgresql.  You can either use a shell script similar to this.

export LD_LIBRARY_PATH=/usr/local/pgsql/lib:PUT_YOUR_OTHER_PATHS_HERE