...
The FASTCopy automation software (module ISOC.FASTCopyDB.FASTCopyDB) uses a set of database tables to perform and track incoming and outgoing FASTCopy transfers. On a fresh installation, a PostgreSQL user and database must be created, and the PostgreSQL server must be configured to allow local and network access to the database. Note that creating a PostgreSQL user does not create a system user account. The 'createuser' command will prompt for a password used to authenticate the user to the database. Choose a suitable password and record it for use in later configuration stepsExamine the file /usr/local/lib/python2.4/site-packages/ISOC/sitedep/sitedep-default.ini, and use the string specified in the 'password' entry in the 'dsn' parameter of the 'FASTCopyDB' stanza.
Code Block |
---|
$ su # su postgres $ createuser -A -D -P GLAST_ISOC $ createdb -O GLAST_ISOC GLAST_ISOC $ exit # exit $ |
...
Code Block |
---|
$ cd /usr/local/lib/python2.4/site-packages/ISOC/FASTCopyDB/dbase
$ psql -U GLAST_ISOC -f build_postgresql.sql GLAST_ISOC
|
Once the basic schema is loaded, the name of the installation host must be added to a table in the database. Determine the fully-qualified hostname of the machine, e.g. "lat-hobbit4.slac.stanford.edu" and execute the following command:
Code Block |
---|
$ psql -U GLAST_ISOC -c "insert into fcopy_submithost values( (select max(submithost_pk)+1 from fcopy_submithost), 'lat-hobbit4.slac.stanford.edu');" GLAST_ISOC |
Similarly, the Unix usernames of any accounts from which outgoing files will be submitted must also be added to a table in the database. Determine the desired list of accounts, e.g. "ric jim selim" and execute the following command:
Code Block |
---|
$ for u in ric jim selim ; do
> psql -U GLAST_ISOC -c "insert into fcopy_submitter values( (select max(submitter_pk)+1 from fcopy_submitter), '$u');" GLAST_ISOC
> done
|