Upgrade Dorian
This guide explains the steps taken to upgrade the caGrid 1.3 Dorian service to version 1.4 on the same host but running as a new user. These are the steps used to upgrade the Training Grid.
Step 0: Shut down caGrid 1.3 Dorian Service
- Connect to your caGrid 1.3 Dorian server.
- Shut down your Tomcat container.

$ $CATALINA_HOME/bin/shutdown.sh
Step 1: Prepare caGrid 1.4 Dorian Host
The caGrid 1.4 Training grid host was installed and configured according to the specifications listed here: caGrid 1.4 Host Configuration.
Dorian specific requirements:
- MySQL 5.0.45 database
- Secure container
If you are installing a new version of Java during the upgrade process, ensure you install the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files.
|
Create a New Dorian Database
- You or your DB administrator must create a new Dorian database.
- Connect to MySQL as root.

$ mysql --user=<USER> --password=<PASSWORD>
- Create Dorian database.

$ Create database Dorian.
- Set default engine to INNODB

$ SET storage_engine=INNODB;
- Create user and grant permissions.

$ GRANT ALL PRIVILEGES on Dorian.* to '<DBUSER>'@'%' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;
- Log out of MySQL.

$ quit
- Connect to MySQL as root.
Step 2: Obtain caGrid 1.3 Dorian Files
- Connect to caGrid 1.3 Dorian host.
- You or your DB administrator must execute a MySQL dump to file.

$ mysqldump --user=<USER> --password=<PASSWORD> <DBAME> > <DBNAME>.sql
- Copy Dorian database dump to caGrid 1.4 Dorian host.

$ scp ~/tmp/<DBNAME>.sql <USER>@<cagrid1.4DorianHost>:/home/<USER>/tmp/.
- Copy host keys and certificates to caGrid 1.4 Dorian.

$ scp -r ~/.cagrid/certificates <griduser>@<cagrid1.4-Dorian>:/home/<USER>/tmp/.
Step 3: Prepare Database and Configuration Files
Copy Dorian configuration files to new host.
- Download and extract https://wiki.cagrid.org/download/attachments/10617829/caGrid-1.4-Configs-NCI.zip
.
- Copy <target_grid>/Dorian/dorian.properties to $HOME/tmp.
- Copy <target_grid>/Dorian/serviceMetadata.xml to $HOME/tmp.
- Copy <target_grid>/Dorian/dorian-configuration.xml to $HOME/tmp.
- Edit dorian.properties.
- Set your database password in gaards.dorian.db.password.
Load Dorian Database
- Verify INNODB Engine Type for Tables
- Run the following command and view the Engine type of Dorian tables

$ grep -i "Engine=" <DBNAME>.sql
- If any table specifies an "engine" that is not INNODB, update the file to specify the required type.
- Save file.
- Run the following command and view the Engine type of Dorian tables
- You or your DB administrator must load the Dorian dump to the new database.

$ mysql --user=<DBUSER> --password=<PASSWORD> <DBNAME> < $HOME/tmp/<DBNAME>.sql
Step 4: Install caGrid 1.4 Software
- Use the installer to install caGrid.

At Step 11 of the caGrid installation procedure, 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 - Your user should now have the following environment variables set. 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
Step 5: Configure the Container
- Use the installer to create a secure Tomcat container.

At Step 5 of the installer: 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. At Step 6: Select the option to browse to credentials on the host. Use the /home/griduser/tmp/certificates location.
- Your user should now have the following environment variables set. The last step of the installer provides the paths for these settings:
- CATALINA_HOME which points to the location of your apache-tomcat-5.5.27 directory
Step 6: Configure Dorian
Copy Configurations into the caGrid Dorian Project
- Copy dorian.properties to the Dorian project.

$ cp $HOME/tmp/dorian.properties $CAGRID_HOME/projects/dorian/etc/.
- Copy serviceMetadata.xml to the Dorian project.

$ cp $HOME/tmp/serviceMetadata.xml $CAGRID_HOME/projects/dorian/etc/.
- Copy dorian-configuration.xml to the Dorian project.

$ cp $HOME/tmp/dorian-configuration.xml $CAGRID_HOME/projects/dorian/etc/.
Step 7: Upgrade the Dorian Database
- Execute the ant task to upgrade the copied Dorian database to version 1.4.

$ cd $CAGRID_HOME/projects/dorian
$ ant upgrade
Step 8: Deploy Dorian
At this point we have completed configuring Dorian and the Tomcat container. We are now ready to deploy Dorian. This can be done as follows from a command prompt:

$ cd $CAGRID_HOME/projects/dorian
$ ant deployTomcat
Step 9: Start the Container
Start Tomcat as follows.

$CATALINA_HOME/bin/startup.sh
| Check the $CATALINA_HOME/logs/catalina.out file for any errors. |
Step 10: Verify the Updated Dorian
- Start GAARDS UI

$ cd $CAGRID_HOME
$ ant security- Open Preferences, set target grid
- Open the GAARDS Preferences Panel via the "Window" menu -> Preferences.
- Double click the grid that you wish to configure, then click the Set Target Grid button
- Click the "Login" button.
- Enter a user and password of a user with administration privileges.
- Click Login.
- A successful login indicates that Dorian is working.
- Open Preferences, set target grid
Step 11: Configure Dorian to Start Automatically
For the Dorian service to be available upon reboot of your serve,r 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![]()





