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

1: aolserver failing to load postgres driver

Posted by Sergio Fortuna on 07/25/04 09:03 PM

Hello everyone,

Trying to install OpenACS w/ aolserver and postgreSQL but keep getting the same error. The error log shows the following:

Error: dbdrv: failed to load driver 'postgres'
Error: dbinit: no such default pool 'pool1'

Suspect its because of this warning given before the error messages:

Warning: modload: could not load /usr/local/aolserver/bin/nspostgres.so: /usr/local/aolserver/bin/nspostgres.so: undefined symbol: BIO_new_mem_buf

Does anybody know what I can do to fix the problem?
Thanks in advance for your help

2: Re: aolserver failing to load postgres driver (response to 1)

Posted by Carl Robert Blesius on 07/25/04 09:27 PM

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).

3: Re: aolserver failing to load postgres driver (response to 2)

Posted by Sergio Fortuna on 07/26/04 02:11 PM

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.

4: Re: aolserver failing to load postgres driver (response to 3)

Posted by Orzenil Silva Junior on 07/26/04 03:29 PM

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

5: Re: aolserver failing to load postgres driver (response to 1)

Posted by Jade Rubick on 07/26/04 07:22 PM

Also try using ldd /path/to/nspostgres.so to make sure it's linked correctly. I think the problem is with that driver. It may need to be recompiled.

6: Re: aolserver failing to load postgres driver (response to 1)

Posted by xx xx on 07/26/04 10:33 PM

It seems the problem may be related to OpenSSL (nsopenssl).

A pointer: http://www.mail-archive.com/muscle@lists.musclecard.com/msg00375.html

7: Re: aolserver failing to load postgres driver (response to 1)

Posted by Sergio Fortuna on 07/27/04 06:40 PM

Many thanks to your replies.
Got it working now - after reinstalling aolserver and the dbdriver.
Can't wait to get "stuck in" its been almost 2 years since last I saw OpenACS in action.