How to upgrade from a previous release

Refer to the offical documentation for your database on how to perform backups. Backup assistance will not be provided in this document.

Locate the directory where you installed Tomcat. Change change directory to the tomcat/webapps/CCCP/WEB-INF/classes directory. Open the file product.properties in any text editor, and look for the property product.version, and it’s value is the version of the CCCP Common Clan Portal you are running.

In the upgrades directory where you unzipped CCCP-<version>-production.zip, you must run every SQL script from the version of CCCP Common Clan Portal you are currently running to the version you have just downloaded. See the lists below to determine which SQL scripts you have to run:

Upgrade database repository from version 1.00
Run the script upgrades\1.00-1.10\upgrade.sql
Run the script upgrades\1.20-1.30\upgrade.sql
Run the script upgrades\1.30-1.40\upgrade.sql
Run the script upgrades\1.40-1.50\upgrade.sql
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.10
Run the script upgrades\1.20-1.30\upgrade.sql
Run the script upgrades\1.30-1.40\upgrade.sql
Run the script upgrades\1.40-1.50\upgrade.sql
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.20
Run the script upgrades\1.20-1.30\upgrade.sql
Run the script upgrades\1.30-1.40\upgrade.sql
Run the script upgrades\1.40-1.50\upgrade.sql
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.30
Run the script upgrades\1.30-1.40\upgrade.sql
Run the script upgrades\1.40-1.50\upgrade.sql
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.40
Run the script upgrades\1.40-1.50\upgrade.sql
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.50
Run the script upgrades\1.50-1.60\upgrade.sql
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.60
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.70
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Upgrade database repository from version 1.80
Run the script upgrades\1.80-1.90\upgrade_<database>.sql
Run the script upgrades\1.90-2.00\upgrade_database.sql

Access the Tomcat Web Application Manager. By default it’s URL is http://<hostname>:8080/manager/html. For example http://localhost:8080/manager/html Login with username=admin and the password is the password you selected during the Tomcat installation. If you are running Tomcat on Linux or Unix you did not specify a password during the installation, and you should find the username and password in tomcat/conf/tomcat-users.xml required to login to Tomcat Web Application Manager.

First you need to Undeploy the running version of CCCP.

Near the text item called Select WAR file to upload click on the Browse button and locate the CCCP.war file. It should be located in the directory where you unzipped CCCP-<version>-production.zip. Then click on Deploy. When deployment is finished, /CCCP should now be visible in the list of applications.

The file dbforms-config.xml contains information about your CCCP database repository. To make sure you are using the dbforms-config.xml that fit's your database, you will need to copy it from dbforms-config-<database>-template.xml where <database> is the type of database you are running.

If you are using PostgreSQL: cp dbforms-config-postgresql-template.xml dbforms-config.xml

If you are using MySQL: cp dbforms-config-mysql-template.xml dbforms-config.xml

If you are using Firebird: cp dbforms-config-firebird-template.xml dbforms-config.xml

On Windows use the copy command instead cp, or simply use the copy feature in Windows Explorer.

There is only one file in the webapp that needs to be configured. This is tomcat/webapps/CCCP/WEB-INF/dbforms-config.xml which you just copied in place in step 5. Replace the username and password values in the dbconnection tag so it can connect to your CCCP repository database.

Example:

<dbconnection
    id = "protomatter" 
    isJndi = "false" 
    default = "true"
    connectionProviderClass = "org.dbforms.conprovider.ProtomatterConnectionProvider" 
    connectionPoolURL = "jdbc:protomatter:pool:postgresPool" 
    conClass  = "org.postgresql.Driver" 
    name   = "jdbc:postgresql://localhost/cccp" 
    username = "cccp" 
    password  = "cccp">
    <pool-property name="pool.initialSize"             value="5"    />
    <pool-property name="pool.maxSize"                 value="10"   />
    <pool-property name="pool.growBlock"               value="2"    />
    <pool-property name="pool.createWaitTime"          value="2000" />
    <pool-property name="pool.maxConnectionIdleTime"   value=""     />
    <pool-property name="pool.maidThreadCheckInterval" value="120"  />
    <pool-property name="jdbc.validityCheckStatement"  value=""     />
</dbconnection>
	  

When you have saved your changes, you MUST restart Tomcat, and you should now be able to access the CCCP Common Clan Portal at http://<hostname>:8080/CCCP/
Example: http://localhost:8080/CCCP/