GUS Schema - installation
Introduction

The GUS relational database schema is a central component of the GUS system, and it must be installed in order to use of most of the software provided with GUS. The schema is currently distributed as a set of files that contain Oracle DDL commands (such as CREATE TABLE and CREATE VIEW, for example); when run on a suitable Oracle database server, these commands will recreate the users, tables, views, constraints, sequences, and indexes that make up the GUS relational schema. (You can browse through these files on the public CVS server.) Note that the GUS system currently works only with Oracle (either 8i or 9i), but we hope to release a version that will add support for either MySQL or PostgreSQL. Installing the schema is typically a task that will be performed by a database administrator, and since many users can share a single GUS instance, the installation may only need to be done once or twice per site, depending on the local requirements.


Installing the GUS schema

1.

Set up the GUS build system as described here. During the initial installation the build system should halt and instruct you to create the properties file $GUS_HOME/config/schema.prop. This file should be edited in order to customize the GUS schema installation scripts to your site and database server. (For example, this file specifies the passwords for the Oracle user accounts that will be created to hold the tables and views in GUS.)

Note: One of the properties in this file is the Oracle SYS password. If you don't want to place the Oracle SYS password in this file, you can instead choose to run the schema creation scripts manually, since only one of the scripts (users.sql) must be run with SYS/DBA privileges.


2. Once the install is complete, change into the directory $GUS_HOME/schema/oracle:
% cd $GUS_HOME/schema/oracle

3. Make sure that the Oracle sqlplus utility is executable and in your default PATH:
% sqlplus -h

SQL*Plus: Release 9.0.1.0.0 - Production

Usage: SQLPLUS [ [
4. Make sure that the grantPermissions.pl script is executable and in your default PATH (the script should be in $GUS_HOME/bin after installing the GUS project)::
% grantPermissions.pl
Usage: grantPermissions.pl options
   --db-sid=SID                # SID of the Oracle server
   --db-host=hostname          # Hostname of the Oracle server
   --db-port=portnum           # Port on which the Oracle server will accept connections
   --login=login               # Oracle login with grant/revoke permissions on the objects owned by --owner
   --permissions=p1,p2,..      # list of permissions to grant/revoke
   --grantees=u1,u2,...        # List of users or roles to grant permissions to
   --revoke                    # Revoke listed permissions instead of granting them
   --owner=owner               # Grant/revoke --permissions to all objects owned by this schema
   --verbose
Invalid arguments at /home/crabtree/projects/GUS/gus_home/bin/grantPermissions.pl line 66.
    

5.

Review the script $GUS_HOME/schema/oracle/create-db.sh to make sure that you approve of the changes that it will make to your database server.


6. Run create-db.sh from the directory $GUS_HOME/schema/oracle:
% ./create-db.sh
    
7.

Check the .log files created by the script to make sure that all of the DDL statements were execute successfully. Correct any errors reported in these files.

Note: the process of checking the log files for errors will be automated in a future release of the system.






$Revision$ $Date$ $Author$Contact: webmaster@gusdb.org