Step 1: Download and install

Download and install MySQL 4.1 or 5.0 (recommended) from http://dev.mysql.com/downloads/mysql.  To verify that MySQL is running, type mysql in a Command Prompt or Terminal.  You should see something like this:

If the command is not recognized, MySQL's bin directory is not in the path. To add MySQL to the path, edit the System Variables and include $MYSQL_HOME/bin to the existing path. In addition, MySQL can also be run from $MYSQL_HOME/bin (where $MYSQL_HOME is the folder where MySQL is installed).

Step 2: Edit MySQL configuration file

IMPORTANT: Please make sure that the database is configured to use the InnoDB engine.

For more information regarding the InnoDB storage engine, please see: http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

If  using Windows, open the MySQL my.ini file located in the MySQL program folder (eg C:\Program Files\MySQL\MySQL Server 5.0) and add the following code under the [mysqld] section:

If using Linux/*nix/OS X, you will need to create this file from one of the default configuration files bundled with MySQL.  These files are described at http://dev.mysql.com/doc/refman/5.0/en/option-files.html .   Open the my.cnf file located in the /etc directory and add the following code under the [mysqld] section:

MySQL must now be restarted in order for the changes to take effect.

Step 3: Importing the database

In Windows, open a Windows Command Prompt; in Linux/*nix/OS X, open a Terminal.

At the prompt, type the following:

Then, from the MySQL prompt, enter the following:

This will create a new database called "cascade".

Step 4: Download the default MySQL database 

The Cascade Server database image is available for download here: http://www.hannonhill.com/downloads/cascade/mysql5x.zip

Step 5: Import the database

To import the database in Windows, enter the following from the command prompt:

For Linux/*nix/OS X, enter the following from the terminal:

where {PATH_TO_FILE} is the location to which you saved the cascade.sql file.

The database is now configured.

SQL Server 2005

Step 1: Download the SQL Server database image

The SQL Server database image is available here: http://www.hannonhill.com/downloads/cascade/mssql.zip

Extract the zip file and place the cascade.mdf file in the SQL Server data folder.  For example:

C:\Program Files\Microsoft SQL Server\MSSQL\DATA\cascade.mdf

Step 2: Attach the database

Open SQL Server Management Studio.  In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine and then expand that instance.

Right-click Databases, point to Tasks, and then click Attach.  The Attach Databases dialog box appears.

To specify the database to be attached, click Add, and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the cascade.mdf file.

To specify a different name for the database to attach as, enter the name in the Attach as column of the Attach database dialog box. (Optional)

Change the owner of the database by selecting a different entry in the Owner column. (Optional)

In the Database Details field, select cascade_Log.LDF and click Remove.

When ready to attach the database, click OK.

Step 3: Enable SQL Server authentication

SQL Server authentication must be enabled.  To enable this:

• Right-click on the Server in the Object Explorer and select Properties
• Click on the Security tab
• Verify that authentication is set to "SQL Server and Windows Authentication Mode"

The database is now configured.

Setting the Database Isolation Level

In setting the isolation level of the database to "snapshot," the following query needs to be run while Cascade Server is NOT running (and no other connections to the database are open):

Setting the isolation level to this setting allows for better performance including fewer deadlock situations.

Oracle 10g

Step 1: Download the Oracle 10g database image

The Oracle 10g database image is available here: http://www.hannonhill.com/downloads/cascade/oracle.zip

We strongly recommend using an existing database with a UTF-8 enabled character set.  This is necessary to take advantage of Cascade Server's multi-language support.

Also, we recommend creating a separate tablespace for the Cascade Server database.  See below for more information on creating the tablespace.

Step 2: Import the database image 

Using Oracle Enterprise Manager:

• Click Maintenance -> Import from Export Files
• For the Directory Object field, select the directory where the Cascade Server import script resides. For the File Name field, type CASCADE.DMP
• Under Import Type select Entire Files
  
• Under Host Credentials fill in the OS Username and Password for the Oracle account, then click Continue.
• On the next screen (Import: Re-Mapping) - unless a tablespace and/or user other than CASCADE has been created, simply click Next.
• Under Import: Options it is recommended to create a log file of the import. Select a Directory Object and under Log File type the name of the file (e.g. CASCADE.LOG) and click Next.
• For the Job Name field, type the desired name (e.g. cascade_import - note that the name has to be unique).  Type an optional description in the Description field and Click Next.
• Under Import: Review, review the import information and verify that everything is correct. Click Submit Job.

The database is now configured.

Tablespace Creation

NOTE: All examples are done with Oracle 10g Enterprise Manager.  Necessary Oracle administrative privileges are required.

• Go to Administration -> Tablespaces, then click Create.
• For the Name field, enter CASCADE
• Under Datafiles,click Add (As an alternative, one can avoid adding a datafile by checking the Use bigfile tablespace check box. However, creating a separate file is highly recommended)
• At the Add Datafile screen, type CASCADE.DBF in the File Name field.
• Point the File Directory field to the desired location.
• For the File Size field, type 30 MB.
• Under Storage, check the option to "Automatically extend datafile when full (AUTOEXTEND)".
• For the Increment field,  type 2 MB. Click Continue.
• Click OK to create the tablespace. The generated SQL should look like this: