Forum OpenACS Q&A: Re: RDBMS type could not be determined for any pool

Collapse
13: Re: RDBMS type could not be determined for any pool (response to 1)
Posted by Torben Brosten on 02/03/06 11:58 AM

Anjali N,

Which documentation are you following?

The error logs suggest you have 2 aolservers running at times, and attempt to run 2 pg postmasters sometimes, too. Is it possible that you createlang plpgsql for one database, while aolserver is accessing another (installation of postgres)?

I don't have RHEL4.0 here, but I believe you can use:

  ps -auxwww | grep postmaster

to see if postgres is running, and:

  ps -auxwww | grep nsd

or

  ps -auxwww | grep aol

to see if aolserver is running.

How are you starting/stopping aolserver and postgres? Did you install any automatic startup scripts?

Collapse
14: hi (response to 13)
Posted by anjali n on 02/03/06 12:40 PM
Hi Torben,
Thanks for your response

I'm using the documents at the following link
for postgres
https://openacs.org/doc/openacs-4/postgres.html
for aolserver
https://openacs.org/doc/openacs-5-0-0/aolserver4.html
for dotlrn
https://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn_1_0_installation
for openacs
https://openacs.org/doc/openacs-5-2/openacs.html
for starting and stopping aolserver
https://openacs.org/doc/openacs-5-0-0/maintenance-web.html

I gave the following as root

ps -auxwww | grep postmaster

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
postgres 18327 0.0 0.0 18060 1668 pts/1 S 15:06 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
root 14577 0.0 0.0 4048 682 pts/1 S+ 16:41 0:00 grep postmaster

ps -auxwww | grep nsd

root 1610 0.0 0.0 2776 236 ? S Jan24 0:00 readproctitle service errors: ...Notice: encoding: loaded: utf-8?[03/Feb/2006:14:19:06][18059.3086915264][-main-] Notice: nsd.tcl: starting to read config file...?[03/Feb/2006:14:19:06][18859.3186915764][-main-] Notice: nsd.tcl: using threadsafe tcl: 1?[03/Feb/2006:14:19:06][18559.308515242][-main-] Notice: nsd.tcl: finished reading config file.?[03/Feb/2006:14:19:06][18059.3086915264][-main-] Notice: encoding: loaded: utf-8?
root 12344 0.0 0.0 4608 578 ? Ss Jan30 0:00 rhnsd --interval 240
502 16429 0.0 1.2 72802 26572 ? Ssl 15:15 0:00 /usr/local/aolserver/bin/nsd -t /var/lib/aolserver/my_server_name/etc/config.tcl
root 18539 0.0 0.0 4068 632 pts/1 S+ 16:44 0:00 grep nsd

ps -auxwww | grep aol

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
502 18419 0.0 1.2 72192 25272 ? Ssl 15:15 0:00 /usr/local/aolserver/bin/nsd -t /var/lib/aolserver/my_server_name/etc/config.tcl
root 18532 0.0 0.0 5236 692 pts/1 S+ 16:48 0:00 grep aol

i haven't installed any automatic start up scripts yet.
i'm using
$OPENACS_SERVICE_NAME etc]$ killall nsd
nsd: no process killed
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ /usr/local/aolserver/bin/nsd-postgres -t /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/config.tcl

to start up aolserver and also

svc -d /service/service0 - Bring the server down
svc -u /service/service0 - Start the server up and leave it in keepalive mode.
svc -o /service/service0 - Start the server up once. Do not restart it if it stops.
svc -t /service/service0 - Stop and immediately restart the server.
svc -k /service/service0
I think i've installed two instances of aolserver at different locations.Will it work if i remove one of them?

Thanx.