Forum OpenACS Q&A: test script for mac X

Collapse
1: test script for mac X
Posted by mister ijoi on 05/31/05 04:54 AM
i already install postgres, aolserver and openacs, openacs can run properly. But after i reboot my server and try to run openacs i got this msg->

The following database pools generated errors:

* OpenACS could not allocate a handle from database pool "pool2".

Possible causes might include:

* The database is not running.
* The database driver has not been correctly installed.
* The datasource or database user/password are incorrect.
* You didn't define any database pools.

as i know in postgres installation there have step to make postgres up when the server reboot. It is my script have problem.

help me plz...

Collapse
2: Re: test script for mac X (response to 1)
Posted by Torben Brosten on 05/31/05 06:55 PM
Verify that the startup script is using accurate initial parameters for your installation:

My-Computer:~ user$ more /Library/StartupItems/PostgreSQL/PostgreSQL

Collapse
3: Re: test script for mac X (response to 1)
Posted by mister ijoi on 06/01/05 03:45 AM
thanks for reply.
i'm still confuse what initial parameter do you explain.Below is a file that should i check for initial parameter??

multimedia:~ root# more ~postgres/.bashrc

export PATH=/usr/local/bin/:$PATH:/usr/local/pgsql/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib

multimedia:~ root# more ~postgres/.bash_profile
source $HOME/.bashrc

################################################################################
## EDIT FROM HERE
################################################################################

# Installation prefix
prefix=/usr/local/pgsql

# Data directory
PGDATA="/usr/local/pgsql/data"

# Who to run pg_ctl as, should be "postgres".
PGUSER=postgres

# Where to keep a log file
PGLOG="$PGDATA/serverlog"

Collapse
4: Re: test script for mac X (response to 1)
Posted by Torben Brosten on 06/01/05 07:08 AM
Those are common values --I called them "parameters" above. Are the startup-script files in /Library/StartupItems ?

Section 9 of installing postgreSQL[1] has special instructions for Mac OS X to "Install the startup script:"

cd /Library/StartupItems/
tar xfz /var/lib/aolserver/$OPENACS_SERVICE_NAME/packages/acs-core-docs/www/files/osx-postgres-startup-item.tgz

The directory should contain these files:

My-Computer:~ user$ ls /Library/StartupItems/PostgreSQL
PostgreSQL Resources StartupParameters.plist

hope this helps,

1. https://openacs.org/doc/current/postgres.html#install-postgres-startonboot

Collapse
5: Re: test script for mac X (response to 1)
Posted by mister ijoi on 06/01/05 09:23 AM
I've the file you mentioned but why this script this script can't start postgres when server reboot.

multimedia:/tmp/dotlrn-2.1.1 service3$ ls /Library/StartupItems/PostgreSQL/
PostgreSQL Resources StartupParameters.plist
multimedia:/tmp/dotlrn-2.1.1 service3$
........................................

multimedia:/tmp/dotlrn-2.1.1 service3$ more /Library/StartupItems/PostgreSQL/StartupParameters.plist
{
Description = "PostgreSQL Database Server";
Provides = ("postgres database");
Requires = ("Disks", "Resolver");
Uses = ("NFS", "Network Time");
OrderPreference = "None";
Messages =
{
start = "Starting PostgreSQL database server";
stop = "Stopping PostgreSQL database server";
restart = "Restarting PostgreSQL database server";
};
}
multimedia:/tmp/dotlrn-2.1.1 service3$

=)