UpgradeCTGridEngine

• Upgrading Catania Grid Engine from 1.4.21 to 1.5.1
  • Library Dependencies
• Upgrading Database
  • Create new tables for GridEngine ver. 1.5.1
• Configuration
  • Glassfish Configuration

Upgrading Catania Grid Engine from 1.4.21 to 1.5.1

If you already installed Grid Engine ver. 1.4.21, follow this guide to upgrade it to the ver. 1.5.1.
Before starting the upgrade make sure your liferay domain is stopped

Library Dependencies

Create the folder /opt/GridEngine in your file-system (as root)

mkdir /opt/GridEngine

Change the folder owner

chown liferayadmin:liferayadmin /opt/GridEngine

Execute the next steps as liferayadmin

Move to /opt/GridEngine

mv /opt/GridEngine

Download Grid Engine and JSAGA libraries from here

Unzip the GridEngine_v1.5.1.zip inside the folder /opt/GridEngine:

unzip GridEngine_v1.5.1.zip

To upgrade the Catania Grid Engine you have to remove the old Grid Engine libraries that you have into the glassfish lib directory, maintaining those required by Liferay. To do this:

Move to Glassfish lib/ directory, usually this directory should be located in a path like this:

/opt/glassfish3/glassfish/domains/liferay/lib/

Make a temporary directory where move Liferay required library

mkdir /opt/glassfish3/glassfish/domains/liferay/lib/tmp

Move all Liferay required jar into the tmp/ folder:

mv commons-fileupload-1.2.2.jar tmp/
mv jtds.jar tmp/
mv portal-service.jar tmp/
mv postgresql.jar tmp/
mv hsql.jar tmp/
mv mysql.jar tmp/
mv portlet.jar tmp/

Delete all remaining files

rm ./*

Move again all Liferay required jar into the Glassfish lib/ folder from tmp/ directory, then remove tmp/ folder:

mv tmp/* .
rm -rf tmp/

Upgrading Database

Create new tables for GridEngine ver. 1.5.1

Download this file in a folder on your file system, when the download is completed, move to the directory where you have stored the downloaded file and run following command in this folder

mysql -u tracking_user -p userstracking < DBUpgrade_from_1.4.21_to_1.5.1.sql

Configuration

Glassfish Configuration

Edit glassfish configuration file in order to add resources needed by the Catania Grid Engine:

vim /opt/glassfish3/glassfish/domains/liferay/config/domain.xml

Look for the section:

 <resources>
    ...
    ...
 </resources>

And add these parameters (change the value of sg-database!):

<jdbc-connection-pool driver-classname="" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" res-type="javax.sql.DataSource" description="" name="GEHibernateConnPool">
      <property name="Url" value="jdbc:mysql://sg-database:3306/userstracking"></property>
      <property name="Password" value="usertracking"></property>
      <property name="User" value="tracking_user"></property>
</jdbc-connection-pool>
<jdbc-resource pool-name="GEHibernateConnPool" description="" jndi-name="jdbc/gehibernatepool"></jdbc-resource>

While in the section server:

<server>

</server>

Add:

<resource-ref ref="jdbc/gehibernatepool"></resource-ref>