Forum OpenACS Q&A: Problems Loading Postgres Drivers

Posted by Rod Cap on 10/31/03 06:02 PM

When I test in the browser the server it throws:
command "ns_db" is not enabled
while executing
"ns_db pools"
(procedure "db_bootstrap_set_db_type" line 72)
invoked from within
"db_bootstrap_set_db_type database_problem"

I've read some posted Forums, and I check out in the error.log where I notice that:
Error: dbdrv: failed to load driver 'postgres'
Error: dbinit: no such default pool 'pool1'

Then I notice that the nspostgres.so file is not in
/usr/local/aolserver/bin/nspostgres.so

I tried to locate the nspostgres.so but I only find a nsposgres.txt. Do I have to comile the drivers again? How do I do that? Where do I get it?
In other server whith openACS there is the nspostgres.so file, but I dont know if I can only copy that binary in the path or there is some other process.
TIA
Rod

3: Re: Problems Loading Postgres Drivers (response to 1)

Posted by bill kellerman on 10/31/03 06:27 PM

if you don't have the nspostgres.so driver, download nspostgres4.0beta1 from aolserver.com's download section and compile. there are instructions included in the tarball, but basically use the command:

% make ACS=1 POSTGRES=/usr/local/pgsql NSHOME=/usr/local/aolserver
% sudo make install

if you are using aolserver 4...

aolserver 4 has broken the database stuff into an external module.
add to your nsd.tcl file:
ns_param nsdb ${bindir}/nsdb.so

for reference:
https://openacs.org/forums/message-view?message_id=137219

4: Re: Problems Loading Postgres Drivers (response to 3)

Posted by bill kellerman on 10/31/03 06:34 PM

this really is kind of confusing. unless it has changed in the 5.0 docs, it's not clear what version of the postgres driver to use and where to get it.

also, a note in the oacs config about the ns_db thing for aolserver 4 would probably help. or maybe some tcl in the config that can determine if 4 is being used and load nsdb automatically...?

2: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Rod Cap on 10/31/03 06:36 PM

I've copied from another server only the nspostgres.so binary, and then I kill all the nsd and:
./nsd-postgres -t /web/service0/etc/config.tcl
But it throws the same error in the browser, now in the error log I found :

Warning: modload: failed to load '/usr/local/aolserver/bin/nspostgres.so': 'libpq.so.2: cannot open shared object file: No such file or directory'

Error: dbdrv: failed to load driver 'postgres'

Error: dbinit: no such default pool 'pool1'

What should I do??

5: Re: Problems Loading Postgres Drivers (response to 2)

Posted by bill kellerman on 10/31/03 06:47 PM

This can be solved a couple of different ways...

Add the path '/usr/local/pgsql/lib' to your LD_LIBRARY_PATH shell variable before starting aolserver process (using "set" or "setenv" command depending on your shell).

Or add the path to the file /etc/ld.so.config and then run the command
ldconfig.

Neither of these worked for me (I was using freebsd though). I made a
soft link from /usr/lib/libpq.so.2 to the pgsql directory:

% ln -s /usr/local/pgsql/lib/libpq.so.2 /usr/lib/libpq.so.2

Make sure the user starting aolserver can read from this directory.

6: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Rod Cap on 10/31/03 07:15 PM

OK... I download nspostgres-4.0beta1, untar it an do make but I get:
**
** POSTGRES variable not set.
** nspostgres.so will not be built.
**
** Usage: make POSTGRES=/path/to/postgresql
** make POSTGRES=LSB
**
** Usage: make install POSTGRES=/path/to/postgresql INST=/path/to/aolserver
** make install POSTGRES=LSB INST=/path/to/aolserver
**
** OpenACS users should also set ACS=1
**
Although, I check in the /usr/local/pgsql/lib/ and there is no libpq.so.2 only the libpq.so.3...... by the way the postgres version is 7.3.3.

7: Re: Problems Loading Postgres Drivers (response to 6)

Posted by Benjamin Bytheway on 10/31/03 07:21 PM

did you do a

`make POSTGRES=/usr/local/pgsql ACS=1 INST=/usr/local/aolserver` ?

(with variance allowed in the paths)

8: Re: Problems Loading Postgres Drivers (response to 6)

Posted by bill kellerman on 10/31/03 07:38 PM

rod,

i gave you the two commands that you need to compile the pg driver above. just change POSTGRES and NSHOME to wherever your postgresql and aolserver are located.

the instructions that you just cut and paste also tell you:

"Usage: make install POSTGRES=/path/to/postgresql INST=/path/to/aolserver"

just add ACS=1 to the end of that.

9: Re: Problems Loading Postgres Drivers (response to 8)

Posted by bill kellerman on 10/31/03 07:40 PM

to correct myself...

% make ACS=1 POSTGRES=/path/to/postgresql INST=/path/to/aolserver
% sudo make install POSTGRES=/path/to/postgresql INST=/path/to/aolserver

10: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Rod Cap on 10/31/03 08:24 PM

Thanks for your patience Derek.
Now it load the postgres drivers but..
In the browser it says OpenACS Installation: Error
....
OpenACS could not allocate a handle from database pool "pool2".

I have no idea...
Thx, for your time

11: Re: Problems Loading Postgres Drivers (response to 10)

Posted by bill kellerman on 10/31/03 09:05 PM

hmm... i'm not sure what causes that.

check this thread:

https://openacs.org/forums/message-view?message_id=137219

make sure you have your database server and username specified correctly.

12: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Cathy Sarisky on 11/02/03 08:50 PM

Rod, please post the last bit of your AOLserver log and anything that looks like an error message - what displays in the browser isn't always the whole problem.

What you're describing now _might_ be a permissions problem or an environment problem.

13: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Rod Cap on 11/03/03 06:37 PM

This are the lates error in the log....

Error: Ns_PgOpenDb(postgres): Could not connect to localhost::beethoven: could not connect to server: No such file or directory

Error: dbdrv: failed to open database 'postgres:localhost::beethoven'

Error: RDBMS type could not be determined for any pool.

Error: <p>The following database pools generated errors:

<ul><li>OpenACS could not allocate a handle from database pool "pool2".</ul><p>
Possible causes might include:<p>
<ul>
<li>The database is not running.
<li>The database driver has not been correctly installed.
<li>The datasource or database user/password are incorrect.
<li>You didn't define any database pools.

That is the error it displays.
Maybe the drivers has not been correcly install???
I follow the steps above. I did it al root make ... and then make install.

14: Re: Problems Loading Postgres Drivers (response to 1)

Posted by Jeff Lu on 11/06/03 04:11 AM

Ive got this error before "command "ns_db" is not enabled" and ive solved it thru the db drivers. It seems after you run "make" you didnt run "make install". Or another thing that happened might be that your port for postgres isnt the default one. How many instances of postgres are you running?

15: Re: Problems Loading Postgres Drivers (response to 10)

Posted by Selim Erol on 09/10/09 03:54 PM

I recently installed OpenACS on Linux Ubuntu 9.04 and got the same error when loading localhost:8000 for the first time. (I used the installation instruction on http://openacs.com/storage/download/OpenACS_Tutorial.pdf?file_id=2855307)

What actually solved the problem was killing the aolserver4-nsd process and restarting openacs.

Only restarting openacs didn't work..

Seems to be too simple to be a good solution but it might help someone out there.

16: Re: Problems Loading Postgres Drivers (response to 15)

Posted by Andrew Piskorski on 09/11/09 07:06 PM

How do you "restart OpenACS" without restarting AOLserver? AFAIK there is no such thing, it can't be done. Therefore, I think what you actually found is that your "restart OpenACS" script didn't work right. It probably tried but failed to shutdown and restart AOLserver. You might want to look into just what your script is doing and what went wrong.