Upgrade CDS

Step 0: Shutdown caGrid 1.3 CDS Service

Connect to your caGrid 1.3 CDS server
Shutdown your Tomcat Container
```
 $ $CATALINA_HOME/bin/shutdown.sh
```

Step 1: Prepare Host

The caGrid 1.4 Training grid host was installed and configured according to the specifications listed on caGrid 1.4 Host Configuration page.

GlobalModelExchange specific requirements:

MySQL 5.0.45 database
Secure Container

Create CDS Database.

You or your DB administrator must create a new CDS database

Connect to MySQL as root

 $ mysql --user=root --password=<PASSWORD>

Create GTS Database
```
 $ create database CDS;
```

Create user and grant permissions

 $ GRANT ALL PRIVILEGES on CDS.* to '<DBUSER>'@'%' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;

Logout of MySQL
```
  $ quit
```

Step 2: Obtain caGrid 1.3 CDS files

Backup the caGrid 1.3 CDS database.

Connect to caGrid 1.3 Master CDS host.

You or your DB administrator must execute a MySQL dump to file.

 $ mysqldump --user=<DBUSER> --password=<PASSWORD> <DBAME> > <DBNAME>.sql

Copy Database and Certificates to caGrid 1.4 Host.

Secure Copy CDS database from caGrid 1.3 CDS

 $ scp <DBNAME>.sql <griduser>@<cagrid1.4-CDS>:/home/griduser/tmp/<DBNAME>.sql

Copy host keys and certificates from caGrid CDS

 $ scp -r ~/.cagrid/certificates <griduser>@<cagrid1.4-CDS>:/home/griduser/tmp/.

Step 3: Prepare Database and Configuration Files.

Copy CDS configuration files to new host.

Download and extract https://wiki.cagrid.org/download/attachments/10617829/caGrid-1.4-Configs-NCI.zip.
1. Copy <target_grid>/CDS/cds.properties to $HOME/tmp
2. Copy <target_grid>/CDS/serviceMetadata.xml to $HOME/tmp
Edit cds.properties
1. Set database password gaards.cds.db.password
2. Set encryption password gaards.cds.dbkeymanager.key.encyption.password
  The encryption password must be identical to the setting for caGrid 1.3 CDS

Load CDS Database.

You or your DB administrator must load the CDS dump to the new database.

 $ mysql --user=<DBUSER> --password=<PASSWORD> <DBNAME> < $HOME/tmp/<DBNAME>.sql

Step 4: Install caGrid Software and Configure a secure container

In this step you will use the installer to install and configure caGrid. Be sure to read the following blue info box for special instructions for step 11, 15 and 16 of the installer before proceeding.

Install caGrid and Configure a Secure Container Using the caGrid 1.4 Installer

At Step 11: Make sure you select the correct target grid for your installation
QA: NCI QA Grid for caGrid 1.4
Stage: NCI QA Grid for caGrid 1.4
Production: NCI QA Grid for caGrid 1.4
Training: Training Grid for caGrid 1.4

Step 15: The hostname must be the externally routable name. For example, the Training Grid Master GTS external hostname is mastergts.training.cagrid.org and internal is cagrid-1_3-training-master-gts.cagrid.org. We specified mastergts.training.cagrid.org when creating credentials.

Step 16: Select the option to create credentials with the GAARDS UI

Start GAARDS UI
```
  $ cd $CAGRID_HOME 

$ ant security
```
Click the "Login" button.
1. Enter user and password of a user with administration privileges.
Open the "Host Certificate Management" panel via the "Account Management" menu -> Grid Account Management -> Host Certificate Management.
1. Type "cds" in the Host field and click the "Search" button.
2. Double-click the currently active CDS credential. This will open the 'Host Certificate' panel
3. Select "compromised" from the Status drop down menu, then click "Update Certificate".
Open the "Request Host Certificate" Panel via the "My Account" menu -> "Request Host Certificate".
1. Type the externally routable hostname of the new CDS service in the "Host" field.
2. The "Specify directory to Write Credentials" should be your griduser's /home/griduser/.cagrid/certificates directory. This will overwrite the previous credentials.
3. Click "Request Certificate"
4. Close the GAARDS UI

At this point, your should set the following environment variables. The last step of the installer provides the paths for these settings:

CAGRID_HOME which points to the location of your 'caGrid' source directory
ANT_HOME which points to the location of your apache-ant-1.7.0 directory
JAVA_HOME which points to the location of your jdk1.6.0_* directory
GLOBUS_LOCATION which points to the location of your ws-core-4.0.3 directory
CATALINA_HOME which points to the location of your apache-tomcat-5.5.27 directory

Step 5: Configure CDS with prepared configuration files

Copy cds.properties

 $ cp $HOME/tmp/cds.properties $CAGRID_HOME/projects/cds/etc/.

Copy serviceMetadata.xml

 $ cp $HOME/tmp/serviceMetadata.xml $CAGRID_HOME/projects/cds/etc/.

Step 6: Install CDS Service

Deploy Service

 $ cd $CAGRID_HOME/projects/cds 

$ ant deployTomcat

Step 7: Start Tomcat

Start Tomcat as follows:

  $CATALINA_HOME/bin/startup.sh

Check the $CATALINA_HOME/logs/catalina.out file for any errors.

Step 8: Validate

Start GAARDS UI
```
  $ cd $CAGRID_HOME $ ant security
```
1. Open Preferences, set target grid
  1. Open the GAARDS Preferences Panel via the "Window" menu -> Preferences.
  2. Double click the grid that you wish to configure, then click the Set Target Grid button
2. Click the "Login" button.
3. Delegate your credentials to another user: Credential Delegation

Step 9: Configure CDS to Start Automatically

For the CDS service to be available upon reboot of your server both MySQL and Tomcat must be configured to start automatically.

MySQL

You or your DB administrator should configure MySQL to start automatically: http://dev.mysql.com/doc/refman/5.0/en/automatic-start.html

Tomcat

Configure Tomcat to start automatically: http://tomcat.apache.org/tomcat-5.5-doc/setup.html