Database Configuration
MySQL
Step 1: Download and install MySQL 5.0/5.1
If you have an existing MySQL instance that you wish to use, skip ahead to step 2.
Download and install MySQL (5.0 or 5.1 only). To verify that MySQL is running, type mysql at a command line. You should see something like this:
If the command is not recognized, either navigate to the MySQL bin directory and try again or add the MySQL bin directory to your $PATH.
Step 2: Edit your MySQL configuration file
IMPORTANT: Make sure that your database is configured to use the InnoDB storage engine.
On Windows, edit your my.ini file located in the MySQL program folder (e.g. C:\Program Files\MySQL\MySQL Server 5.0) and change or add the following variables under the [mysqld] section:
On Linux, Unix, or OS X, edit your my.cnf file (usually located in the /etc directory) and change or add the following variables under the [mysqld] section:
Note: these are minimum memory settings. If they are already set to something higher, you can keep the original values.
For additional information regarding these configuration files, please reference MySQL's documentation.
Step 3: Restart MySQL
MySQL must be restarted in order for any changes to take effect.
Step 4: Download the Cascade Server database
Download the Cascade Server database.
After downloading, unzip the database.
Step 5: Import the Cascade Server database
From a command line, open a MySQL prompt and execute the following commands (replacing 'cascade' with the database name of your choice):
Exit the MySQL prompt
To import the database on Windows, execute the following at a command line:
To import the database on Linux, Unix, or OS X, execute the following at a command line:
where 'cascade' is the name of your new database and '/path/to/file/cascade.sql' is the full directory path to the Cascade Server database file.
Your MySQL database is now configured and ready to be used by Cascade Server.
SQL Server
Installing to SQL Server 2005/2008
Step 1: Download Cascade Server database
Download the Cascade Server database.
After downloading, unzip the database and place the cascade.mdf and cascade_log.ldf files in your SQL Server data folder (e.g. C:\Program Files\Microsoft SQL Server\MSSQL\DATA\)
Step 2: Attach the Cascade Server database to SQL Server
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, and select Attach. The Attach Databases dialog box appears.
To specify the database to be attached, click Add. In the Locate Database Files dialog box, navigate to the SQL Server data folder into which you just dropped the database files, select cascade.mdf, and click OK.
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)
To change the owner of the database, select a different entry in the Owner column. (Optional)
Click OK to complete the database attachment.
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
- Select the Security section
- Verify that authentication is set to "SQL Server and Windows Authentication Mode"
Step 4: Set the Database Isolation Level to snapshot
Setting the isolation level to 'snapshot' increases performance with Cascade Server.
Execute the following query while Cascade Server is not running, and no other connections to the database are open:
where databaseName is the name of your Cascade Server database.
Your SQL Server database is now configured and ready to be used by Cascade Server.
Upgrading from SQL Server 2005 to 2008
Cascade 6.7 is the first version that supports SQL Server 2008. Previous versions of the software will fail to startup when run against SQL Server 2008. To upgrade to SQL Server 2008:
- Ensure you are running Cascade 5.5 or later so that it can be upgraded directly to 6.7 or later. If you are not, first upgrade to 5.5 or later while still using SQL Server 2005.
- Backup your database in SQL Server 2005.
- Attach your backup in an instance of SQL Server 2008. For more information on upgrading a database to SQL Server 2008, follow Microsoft's upgrade guide. Please maintain your SQL Server 2005 instance.
- Upgrade Cascade to version 6.7 or later.
- Configure Cascade's database connection to point to your database now running on SQL Server 2008.
- Start Cascade and ensure it starts up successfully.
Oracle
Oracle 10g/11g
Step 1: Download the Cascade Server database
Download the Cascade Server database.
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-lingual support.
Also, we recommend creating a separate tablespace for the Cascade Server database. See below for more information on creating the tablespace.
Step 2: Create new Tablespace
Using Oracle Enterprise Manager:
- Go to Administration -> Tablespaces, then click Create.
- For the Name field, enter CASCADE_DEFAULT
- 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_DEFAULT.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:
Step 3: Import the Cascade Server database
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_DEFAULT.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_DEFAULT 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_DEFAULT.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.
Your Oracle database is now configured and ready to be used by Cascade Server.

