**WFU caTISSUE Core Beta Installation Log**

### Overview

This document details the installation of caTISSUE Core Beta at Wake
Forest University (WFU). WFU is using the Windows/MySQL configuration.
For this document, we have copied pertinent sections of the caTISSUE
Core v1.0 Deployment Guide document, and inserted corrections,
observations and screen shots of what we actually encountered during the
install process. WFU installed the caTISSUE Core Beta on a new, out of
the box 2.80 GHz Dell GX620 Pentium 4 with 2.00GB of RAM running on a
fully patched Windows XP SP2 operating system with WFU. The machine is
part of the WFU Baptist Medical Center Domain, and domain security
settings are enforced as a group policies. The PC also has Norton
antivirus enterprise edition and patch management software (SMS)
installed and running. WFU began the installation process on 01/24/06
and finished on 01/26/06.

Overall the install process documentation was adequate for the current
target audience (adopters, who are more familiar with the software and
are probably more technically informed than the broader population of
potential end users of caTISSUE). However, even for WFU, the
documentation of the installation and configuration of prerequisite
software (MySQL, J2SE, and most particularly JBOSS and ANT), needed
considerably more detail.

Ultimately all sections will need revision to enable more general users
install and configure the application.

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

1.  **Installation Prerequisites**

**2.1 Install JBoss Application Server**

Download JBoss Application Server (Version 4.0.3 SP1) from
<http://www.jboss.com/developers/index> and install it to a desired
location e.g. C:\\jboss4.0.3SP1

The following screen shots show the whole process:

2.1.1 Click the link 'JBoss Application Server' under 'JEMS Products' in
the left panel, then click the link 'Download' under 'JBoss Application
Server' in the left panel at next page.

![](media/image1.jpeg){width="4.847222222222222in" height="3.8375in"}

2.1.2 Click the link 'Download' for version 4.0.3 SP1.

![](media/image2.jpeg){width="4.76875in" height="3.7819444444444446in"}

2.1.3 Click the top link 'jboss-4.0.3SP1-installer.jar'.

![](media/image3.jpeg){width="4.759722222222222in"
height="3.7819444444444446in"}

2.1.4 Click the link 'Download' for mirror 'Phoenix, AZ'. This is a
faster mirror site. Click 'Save' button to save the jar file on your pc
on next popped window. Don't choose 'Open' because you may need to
install JBoss again.

![](media/image4.jpeg){width="4.847222222222222in" height="3.8375in"}

2.1.5 Find the saved executable jar file 'jboss-4.0.3SP1-installer',
double click that to start the installation process. Choose setting
based on following screen shots in order.

![](media/image5.jpeg){width="2.4583333333333335in" height="2.5625in"}

You can select other directory by clicking 'Browse' button.

![](media/image6.jpeg){width="5.352777777777778in"
height="4.019444444444445in"}

You must check 'all' at this step. If you check 'tomcat', you will have
problems in post installation configuration.

![](media/image7.jpeg){width="5.326388888888889in"
height="4.009722222222222in"}

![](media/image8.jpeg){width="5.326388888888889in" height="4.0in"}

![](media/image9.jpeg){width="5.326388888888889in" height="4.0in"}

Remember to check the box to enable deployment isolation/call by value.

![](media/image10.jpeg){width="5.326388888888889in" height="4.0in"}

Remember to check all check boxes in this page, then type admin user
name and password.

![](media/image11.jpeg){width="5.326388888888889in" height="4.0in"}

![](media/image12.jpeg){width="5.326388888888889in" height="4.0in"}

![](media/image13.jpeg){width="5.326388888888889in" height="4.0in"}

![](media/image14.jpeg){width="5.326388888888889in" height="4.0in"}

2.1.6 NOTE: In rest of the document, the installed location of JBOSS is
referred as "**JBOSS_HOME**".

**2.2 Install Database**

You only need to install one database, MySQL or Oracle. We installed
MySQL on our local server. The detailed process is as following.

2.2.1 Download MySQL 5.0 from
<http://dev.mysql.com/downloads/mysql/5.0.html>. Move your cursor down
to 'Windows Downloads', click the link 'Download' for 'Windows (x86)'.
Click 'Save' button to save the zip file on your pc on next popped
window. Don't choose 'Open' because you may need to install MySQL again.

2.2.2 Find the saved zip file 'mysql-5.0.18-win32.zip', double click it,
you will see a setup file 'Setup.exe', then double click it and click
'Run' button to start the installation process. Choose setting based on
following screen shots in order.

![](media/image15.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image16.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image17.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image18.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image19.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image20.jpeg){width="5.25in" height="4.020833333333333in"}

![](media/image21.jpeg){width="5.25in" height="4.020833333333333in"}

2.2.3 NOTE: In rest of the document, the installed location of MySQL is
referred as "**MYSQL_HOME**".

**2.3 Install ANT**

2.3.1 Download Ant 1.6.5 from <http://ant.apache.org/> Click the link
'download' to go to download page, then click the link
'apache-ant-1.6.5-bin.zip' to download the zip file. Click 'Save' button
to save the zip file on your pc on next popped window. Don't choose
'Open' because you may need to install ANT again.

2.3.2 Find the saved zip file 'apache-ant-1.6.5-bin.zip', double click
it go to the sub-folder 'apache-ant-1.6.5', then double-click this
folder to see all files. Extract all files to a desired location e.g.
C:\\ant.

2.3.3 Refer to Apache Ant 1.6.5 Manual from
<http://ant.apache.org/manual/index.html> for installation and setup.
Before you can run ANT, there is some additional set up you will need to
do: 1) Add the bin directory to your path. 2) Set the ANT_HOME
environment variable to the directory where you installed Ant.

Assume Ant is installed in c:\\ant\\. The following sets up the
environment:

set ANT_HOME=c:\\ant

set PATH=%PATH%;%ANT_HOME%\\bin

See the following screen shots for setup process.

Right click shortcut 'My Computer' on desktop, choose 'Properties', then
click 'Advanced' tab.

![](media/image22.jpeg){width="3.709722222222222in"
height="4.307638888888889in"}

Click 'Environment Variables' button.

![](media/image23.jpeg){width="3.4in" height="3.8069444444444445in"}

Click button 'New' for 'System variables'. Set the values as following
screen shot.

![](media/image24.jpeg){width="3.6145833333333335in" height="1.53125in"}

Click 'OK'.

![](media/image25.jpeg){width="4.0in" height="4.479166666666667in"}

Click system variables 'Path', then click 'Edit' button.

![](media/image23.jpeg){width="3.4in" height="3.8069444444444445in"}

Add '%ANT_HOME%\\bin' at the end. Remember to use semicolon ';' to
separate it from other variables.

![](media/image26.jpeg){width="3.6145833333333335in" height="1.53125in"}

2.3.4 NOTE: In rest of the document the installed location of ANT is
referred as "**ANT_HOME**".

**2.4 Install Java 2 Platform, Standard Edition, v 1.4.2 (J2SE 1.4.2)**

2.4.1 If your pc does not have J2SE installed, you do need to install
it. Otherwise, just skip this step. By default, the J2SE Java Runtime
Environment (JRE) is automatically installed with Windows environment.
JRE just allows end-users to run Java applications. If you need to
compile Java source code, you must have J2SE installed.

2.4.2 Download J2SE SDK from
[https://sdlcweb2d.sun.com/ECom/EComActionServlet;jsessionid=54CA399105B3576C7501B3D51E83CEA3](https://sdlcweb2d.sun.com/ECom/EComActionServlet;jsessionid=54CA399105B3576C7501B3D51E83CEA3 )
Click the link 'Windows Offline Installation, Multi-language', then
click 'Save' button to save the execute file on your pc on next popped
window. Don't choose 'Run' because you may need to install J2SE again.

2.4.3 Find the saved execute file 'j2sdk-1_4_2_10-windows-i586-p.exe',
double click it, then click 'Run' button on next popped window to start
the installation process. Install it to a desired location e.g. C:\\
j2sdk-1_4_2_10.

2.4.4 Set up system environment variables: 1) Add the bin directory to
your path. 2) Set the JAVA_HOME environment variable to the directory
where you installed J2SE.

Assume J2SE is installed in C:\\ j2sdk-1_4_2_10\\. The following sets up
the environment:

set JAVA_HOME= C:\\ j2sdk-1_4_2_10

set PATH=%PATH%;%JAVA_HOME%\\bin

The setup process is similar to step 2.3.3, please refer to screen shots
in that step.

### 3. Install caTISSUE Core

3.1 To deploy caTISSUE Core download the latest catissuecore.zip from
the caBIG CVS. Following is the web link where you can get the latest
catissuecore.zip file:

[http://cabigcvs.nci.nih.gov/viewcvs/viewcvs.cgi/catissuecore/CODE%20AND%20TESTING/Release/Beta_23Jan/catissuecore.zip](http://cabigcvs.nci.nih.gov/viewcvs/viewcvs.cgi/catissuecore/CODE AND TESTING/Release/Beta_23Jan/catissuecore.zip)
. Remember to click the link 'download' for 'Revision 1.2'. If the
download is not automatically started, put your cursor on the link
'download', right click and choose 'Save Target As...' to start the
download process.

3.2 Find the saved zip file 'catissuecore.zip', double click it go to
the sub-folder 'catissuecore', then double-click this folder to see all
files. Extract all files to a desired location e.g. C:\\catissuecore.

3.3 Following is the list of files available in the root folder of the
ZIP file required for configuring application and deploying it on
application server:

+----------------------------+-----------------------------------------+
| **File Name**              | **Description**                         |
+----------------------------+-----------------------------------------+
| caTISSUEInstall.properties | It is a property file in which all the  |
|                            | application configuration parameters    |
|                            | are listed.                             |
+----------------------------+-----------------------------------------+
| deploy.xml                 | This is the ANT script to deploy the    |
|                            | application server on a JBOSS server.   |
|                            | This also creates the database schema   |
|                            | for Oracle or MySQL.                    |
+----------------------------+-----------------------------------------+
| Sam                        | This file contains XML tags to be added |
| ple-properties-service.xml | in JBoss properties-service.xml to      |
|                            | provide a startup parameter to the      |
|                            | JBoss server.                           |
|                            |                                         |
|                            | **NOTE:** This is just a sample file    |
|                            | and user may have to make the changes   |
|                            | in the JBOSS configuration files based  |
|                            | on the contents of this file.           |
+----------------------------+-----------------------------------------+
| Sample-log4j.xml           | This file contains XML tags to be added |
|                            | in JBoss log4j.xml to configure         |
|                            | application message logger.             |
|                            |                                         |
|                            | **NOTE:** This is just a sample file    |
|                            | and user may have to make the changes   |
|                            | in the JBOSS configuration files based  |
|                            | on the contents of this file.           |
+----------------------------+-----------------------------------------+
| Sample-login-config.xml    | This file contains XML tags to be added |
|                            | in JBoss login-config.xml for           |
|                            | performing login module configuration.  |
|                            |                                         |
|                            | **NOTE:** This is just a sample file    |
|                            | and user may have to make the changes   |
|                            | in the JBOSS configuration files based  |
|                            | on the contents of this file.           |
+----------------------------+-----------------------------------------+
| MySql_DB_Creation.sql      | This file contains SQL statements that  |
|                            | can be used to create Database and User |
|                            | for MySQL.                              |
+----------------------------+-----------------------------------------+
| Oracle_DB_Creation.sql     | This file contains SQL statements that  |
|                            | can be used to create Database and User |
|                            | for Oracle.                             |
+----------------------------+-----------------------------------------+

Table 1

### 4. Pre-installation Configuration

4.1 The first step of deploying caTISSUE Core application is to create
database and create user. Refer 9. Appendix for database creation
script.

Go to Start \> All Programs \> MySQL \> MySQL Server 5.0 \> MySQL
Command Line Client, type the root password you created when install
MySQL in above step 2.2.2 In the client window, type the following
command to create 'catissuecore' database:

mysql\> create database catissuecore;

Check the result by typing following command: (See the following screen
shot)

mysql\> show databases

![](media/image27.jpeg){width="5.993055555555555in" height="3.35in"}

Create user 'catissue_core' with password 'catissue_core', type 2
commands as following. See above screen shot.

msql\> grant all privileges on \*.\* To 'catissue_core'@'localhost'
identified by 'catissue_core' with grant option;

msql\> grant all privileges on \*.\* To 'catissue_core'@'% identified by
'catissue_core' with grant option;

4.2 Configure the following parameters in the caTISSUEInstall.properties
file and update the following parameters**:**

+-----------------------+----------------------------------------------+
| jboss.home.dir        | Description: Should be set to JBOSS_HOME.    |
|                       | **Import Note:** The Path should be          |
|                       | separated by '/'.                            |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| database.type         | Description: Type of database to be used in  |
|                       | the application.                             |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | Permissible Values: : mysql, oracle          |
+-----------------------+----------------------------------------------+
| database.host         | Description: Hostname or IP address of the   |
|                       | machine on which the database server is      |
|                       | running.                                     |
|                       |                                              |
|                       | Default Value: localhost                     |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| database.port         | Description: This is the port number to      |
|                       | connect with database server.                |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | > Default port for MySql: 3306               |
|                       | >                                            |
|                       | > Default Port for Oracle: 1521              |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| database.name         | Description: The name of database. Specify   |
|                       | the same name that you specified in creating |
|                       | the database.                                |
|                       |                                              |
|                       | Default Value: catissuecore                  |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| database.username     | Description: The username used to connect to |
|                       | the database.                                |
|                       |                                              |
|                       | Default Value: catissue_core                 |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| database.password     | Description: The password used to            |
|                       | authenticate the database user.              |
|                       |                                              |
|                       | Default Value: catissue_core                 |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| email.admini          | Description: Email address of administrator; |
| strative.emailAddress | this could be an email alias if there is     |
|                       | more than one administrator.                 |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | Permissible Values: N/A                      |
|                       |                                              |
|                       | **NOTE:** Please refer to bug                |
|                       | [#1194](http://nagar                         |
|                       | ajanlab.wustl.edu/bugs/show_bug.cgi?id=1194) |
|                       | before configuring this parameter.           |
+-----------------------+----------------------------------------------+
| email.sendE           | Description: Email address used to send      |
| mailFrom.emailAddress | emails from application.                     |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| email.mailServer      | Description: The mail server used to send    |
|                       | emails.                                      |
|                       |                                              |
|                       | Default Value: None                          |
|                       |                                              |
|                       | Permissible Values: N/A                      |
+-----------------------+----------------------------------------------+
| session.timeout       | Description: The timeout interval of session |
|                       | in minutes.                                  |
|                       |                                              |
|                       | Default Value: 10                            |
|                       |                                              |
|                       | Permissible Values: Numeric Value            |
+-----------------------+----------------------------------------------+

Table 2

See the following screen shot for the setting in
caTISSUEInstall.properties file

![](media/image28.jpeg){width="5.99375in" height="3.672222222222222in"}

### 5. Run ANT to Deploy caTISSUE Core 

5.1 Open a command prompt and change your current directory to one where
you UNZIP the catissuecore.zip file. In this directory you must see a
file name "deploy.xml".

5.2 Run ANT task to deploy the application and initialize the database
on command prompt. The syntax to run the ANT task is as follows: (Note:
we ran target 'Deploy-all' on our server)

ant --f deploy.xml \<target_name\>

The following table describes the different target of the ANT script:

  --------------------- -------------------------------------------------
  Deploy-all            Install application and database

  DBInitialize          Install only database

  Deploy                Install only application
  --------------------- -------------------------------------------------

Table 3

### 6. Post Installation Configuration

Once the application is deployed, you need to change some of the JBOSS
configuration parameters.

**6.1 properties-service.xml (CSM related file)**

Add the following entries to the properties in the
properties-service.xml file available at
JBOSS_HOME/server/default/deploy:

\<attribute name=\"Properties\"\> \<!\-- could already exist \--\>

gov.nih.nci.sdk.remote.catissuecore.securityLevel=0

gov.nih.nci.sdk.applications.session.timeout=3000

gov.nih.nci.security.configFile **= \<APP_SEQURITY_CONFIG_PATH\>**

\</attribute\> \<!\-- could already exist \--\>

**NOTE:** The gov.nih.nci.security.configFile is the name of the
property which points to the fully qualified path where the
ApplicationSecurityConfig.xml has been placed in above steps. The name
of the property has to be the gov.nih.nci.security.configFile and cannot
be modified as it is a system-wide property. Please have a look to
sample file. Sample-properties-service.xml defined in Table 1

Update the following parameters in above setting:

+-----------------------+----------------------------------------------+
| APP                   | Description: Name of the property which      |
| _SEQURITY_CONFIG_PATH | specifies the security of the application.   |
|                       |                                              |
|                       | Default Value:                               |
|                       | JBOSS_HOME/server/default/catissuec          |
|                       | ore-properties/ApplicationSecurityConfig.xml |
|                       |                                              |
|                       | Permissible Values: None                     |
+-----------------------+----------------------------------------------+

Table 4

**6.2 login-config.xml (CSM related file)**

Add the following entries to login-config.xml file available at
JBOSS_HOME/server/default/conf:

\<application-policy name = \"APPLICATION_POLICY\"\>

\<authentication\>

\<login-module code =
\"gov.nih.nci.security.authentication.loginmodules.RDBMSLoginModule\"
flag = \"required\" \>

\<module-option name=\"driver\"\>DRIVER_CLASS_NAME\</module-option\>

\<module-option name=\"url\"\>URL\</module-option\>

\<module-option name=\"user\"\>USER_NAME\</module-option\>

\<module-option name=\"passwd\"\>PASSWORD\</module-option\>

\<module-option name=\"query\"\>select \* from csm_user where
login_name=? and password=? \</module-option\>

\</login-module\>

\</authentication\>

\</application-policy\>

The login-module is the Login Module class which is to be used to
perform the authentication task. In this case it is
gov.nih.nci.security.authentication.loginmodules.RDBMSLoginModule

The flag provided is "required". The module-options list down the
parameters which are passed to the Login Module to perform the
authentication task. Please have a look to sample file
Sample-login-config.xml defined in Table 1

Update the following parameters in above setting:

+-----------------+----------------------------------------------------+
| APP             | Description: This specifies the application for    |
| LICATION_POLICY | which we are defining the authentication policy.   |
|                 |                                                    |
|                 | Default Value: catissuecore                        |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| URL             | Description: The URL used to locate and connect to |
|                 | the database. . Specify the database URL that you  |
|                 | used in creating database please refer to Table 2. |
|                 | Refer to following URL pattern for:                |
|                 |                                                    |
|                 | **MySQL:**                                         |
|                 | jdbc                                               |
|                 | :mysql://database.host:database.port/database.name |
|                 |                                                    |
|                 | **Oracle:**                                        |
|                 | jdbc:orac                                          |
|                 | le:thin:@database.host:database.port:database.name |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| DR              | Description: The database driver loaded in memory  |
| IVER_CLASS_NAME | to perform database operations                     |
|                 |                                                    |
|                 | Default Value: NONE                                |
|                 |                                                    |
|                 | Permissible Values:                                |
|                 |                                                    |
|                 | MySQL - org.gjt.mm.mysql.Driver                    |
|                 |                                                    |
|                 | Oracle - oracle.jdbc.driver.OracleDriver           |
+-----------------+----------------------------------------------------+
| USER_NAME       | Description: The username used to connect to the   |
|                 | database. . Specify the same user name that you    |
|                 | specified in Table 2                               |
|                 |                                                    |
|                 | Default Value: catissue_core                       |
|                 |                                                    |
|                 | Permissible Values: None                           |
+-----------------+----------------------------------------------------+
| PASSWORD        | Description: The password used to authenticate the |
|                 | username. . Specify the same password that you     |
|                 | specified in Table 2                               |
|                 |                                                    |
|                 | Default Value: catissue_core                       |
|                 |                                                    |
|                 | Permissible Values: None                           |
+-----------------+----------------------------------------------------+

Table 5

**6.3 log4j.xml**

Add the following entries to log4j.xml file available at
JBOSS_HOME/server/default/conf:

\<appender name=\"CATISSUECORE_LOGGER\"
class=\"org.apache.log4j.FileAppender\"\>

\<param name = \"File\" value =
\"\${jboss.server.home.dir}/log/catissuecore.log\" /\>

\<param name=\"Append\" value=\"true\" /\>

\<layout class = \"org.apache.log4j.PatternLayout\"\>

\<param name = \"ConversionPattern\" value=\"%d{dd MMM yyy HH:mm:ss},
%-6p %C:%M:%L %m %n\" /\>

\</layout\>

\</appender\>

\<category name=\"catissuecore.logger\"\>

\<priority value=\"DEBUG\" /\>

\<appender-ref ref=\"CATISSUECORE_LOGGER\" /\>

\</category\>

Please have a look to sample file Sample-log4j.xml defined in Table 1

**NOTE:** Log4j is an open source application. Please refer to
<http://logging.apache.org/log4j/docs/> for more details.

### 7. Application Server Startup/Shutdown

  -------------- ------------------------ ---------------------------------
                 **Windows**              **Linux**

  **Start**      JBOSS_HOME/bin/run.bat   nohup \$BOSS_HOME/bin /run.sh &

  **Stop**       JBOSS_HOME/bin/          \$JBOSS_HOME/bin /shutdown.sh -S
                 shutdown.bat             
  -------------- ------------------------ ---------------------------------

Table 6

### 8. Accessing Application 

Once the JBOSS server is started, access the application using web
browser. Following is the URL pattern to the web application.

[http://machine_name:port_number/catissuecore]()

+-----------------+----------------------------------------------------+
| machine_name    | Description: This specifies the machine name or IP |
|                 | address of machine where your JBOSS Server is      |
|                 | running                                            |
|                 |                                                    |
|                 | Default Value: localhost                           |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| port_number     | Description: This specifies port number on which   |
|                 | JBOSS Server is listening the HTTP request         |
|                 |                                                    |
|                 | Default Value: 8080                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+

Table 7

Example of the above URL: <http://localhost:8080/catissuecore>

When the browser displays the home page of caTISSUE Core login into
application by giving following credentials:

User Name: <admin@admin.com>

Password: login123

**NOTE:**

1.  Please change the password after first login.

2.  The default admin user creation process will be changed for the
    final. Please refer to bug#

### 9. Appendix

Following are the sample SQL scripts to create database and user for
Oracle and MySQL. You can use your own script to create database and
user as per your requirements.

**NOTE:** The default script will create a user with all permissions.

Please note that without creating/specifying user, database and
tablespace (applicable only on Oracle) the ANT script will not be able
to create the caTISSUE schema for the application.

**SQL Script for MySQL:** MySql_DB_Creation.sql (Please refer to Table
1)

Before executing the SQL scripts update the following parameters in
MySql_DB_Creation.sql script.

+-----------------+----------------------------------------------------+
| DATABASE_NAME   | Description: MySQL database name where application |
|                 | data will store.                                   |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| USERNAME        | Description: The user name used to connect to      |
|                 | database.                                          |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| PASSWORD        | Description: The password used to authenticate the |
|                 | username.                                          |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+

Table 8

**SQL Script for Oracle**: Oracle_DB_creation.sql (please refer to Table
1)

Before executing the SQL scripts update the following parameters in
above Oracle_DB_creation.sql script:

+-----------------+----------------------------------------------------+
| TABLESPACE_NAME | Description: Oracle tablespace name where          |
|                 | application data will store.                       |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| TABLESPACE_PATH | Description: Location/Path of data file where      |
|                 | Oracle Table Space will be created.                |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| USERNAME        | Description: The User name used to connect to      |
|                 | database.                                          |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+
| PASSWORD        | Description: The password used to authenticate the |
|                 | username.                                          |
|                 |                                                    |
|                 | Default Value: None                                |
|                 |                                                    |
|                 | Permissible Values: N/A                            |
+-----------------+----------------------------------------------------+

Table 9