Metacat

Instructions on initially creating the workflow scheduler database.

Update postgres configuration

	Edit:

		/etc/postgresql/<postgres_version>/main/pg_hba.conf

	Add the following Line:

		host workflowscheduler workflowscheduler 127.0.0.1 255.255.255.255 password

Create database:

	type: createdb metacat

Create workflowscheduler user

	Log in to postgreSQL by typing: 

		psql metacat

	At the psql prompt, create the workflowscheduler user by typing:

		CREATE USER workflowscheduler WITH UNENCRYPTED PASSWORD 'your_password';

    where 'your_password' is whatever password you would like for the workflowscheduler user.

	Exit PostgreSQL by typing:

		\q

	Restart the PostgreSQL database to bring in changes:

     	/etc/init.d/postgresql-8.3 restart

Test setup

	Log out of the postgres user account by typing:

		logout

	Test the installation and workflowscheduler account by typing:

		psql -U workflowscheduler -W -h localhost workflowscheduler

Create tables:

	Open the table creation script at:

		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql

	Copy each sql command and run in psql prompt.

Populate tables

	Open the table creation script at:

		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql

	Copy each sql command and run in psql prompt.

These are the steps to install the workflow scheduler, workflow run engine and kepler.  

At the time of this writing, the workflow scheduler is associated with a single instance

of metacat.  The workflow run engine and kepler are installed on the same machine as the 

workflow scheduler.

These instructions assume that you already have a working copy of apache and tomcat.

Build the workflow scheduler:

	-- check out Metacat trunk code

	-- in the root directory, run "ant clean war -f workflowscheduler.build.xml"

	-- the workflowsheduler.war file will be in ./workflowscheduler.dist/

Deploy the workflow scheduler:

	-- copy the workflowscheduler.war file to the tomcat webapp directory on the target 

	   server

	-- unjar the war file so you can modify the configuration

		-- in the webapp dir, mkdir workflowscheduler

		-- cd workflowscheduler

		-- jar -xvf ../workflowscheduler.war

	-- vi WEB-INF/workflowscheduler.properties

		-- change the workflowScheduler.authServiceUrl and 

		   workflowScheduler.authorizationServiceUrl to point to the instance of metacat

		   associated with the scheduler.

Create the database:

	-- follow the instructions in the following file in this directory:

		createWorkflowSchedulerDB.txt

Configure Metacat:

	-- on the instance of Metacat associated with this workflowscheduler, edit 

	   WEB-INF/metacat.properties

	-- change the workflowScheduler.url to point to the workflow scheduler server

Restart:

	-- Restart the tomcat instance for the scheduler and for metacat.

Install R

	-- follow the instructions at: http://cran.r-project.org/doc/manuals/R-admin.html

	   to download and install r

	-- for rhel4, the following steps were applied

		-- download source tar.gz at:

				 http://cran.cnr.berkeley.edu/sources.html

		-- tar -xvzf R-2.10.0.tar.gz

		-- install gcc: up2date gcc-g77

		-- run configure with no x and no readline options

				./configure --with-x=no --with-readline=no

		-- run "make"

		-- run "make install"

Install kepler:

	-- mkdir /usr/kepler

	-- cd /usr/kepler

	-- svn co https://code.kepler-project.org/code/kepler/trunk/modules/build-area

	-- cd build-area

	-- ant change-to -Dsuite=wrp

	-- ant run 

Install workflow run engine:

	-- follow the steps listed in:

		http://code.kepler-project.org/code/kepler/trunk/modules/webservice/KeplerWebService/doc/kepler-execution-engine-installation.txt