Upgrade to TeamForge 8.0 - Database and SCM on separate servers

In this procedure, we'll assume that you are upgrading on the same server where your existing TeamForge 7.2 site is running. It is possible to simultaneously upgrade and move your site to a new hardware. However, since we are working with a dedicated installation, the priority here is to keep things as simple and quick as possible.

Do the following on the application server - my.app.host

1. Stop TeamForge.
   • /etc/init.d/collabnet stop
2. Back up the file system data.
   Tip: /tmp/backup_dir is just an example. You can use any directory or partition you prefer to store your backup files.
   1. Make an archive file with the following data directories:

      Directory	Contents
      /opt/collabnet/teamforge/var	User-created data, such as artifact attachments
      /sf-svnroot	Subversion repository for branding data

      • mkdir -p /tmp/backup_dir
      • cp -Rpfv /sf-svnroot /opt/collabnet/teamforge/var /tmp/backup_dir
   2. Back up your SSH keys, if any.
   3. Back up your SSL certificates and keys, if any.
3. If you have Review Board integrated, make a dump file of your Review Board data.
   1. Create a /backups directory in /var/lib/pgsql/ and change ownership to postgres.
      • cd /var/lib/pgsql/
      • mkdir backups
      • chown -R postgres:postgres backups
   2. Make a dump file of your Review Board data.
      • su - postgres
      • /usr/bin/pg_dumpall > /var/lib/pgsql/backups/rb_data_backup.dmp -l ctfrbdb
      • exit

Do this on the database server - my.db.host

4. Back up your site database.
   Tip: /tmp/backup_dir is just an example. You can use any directory or partition you prefer to store your backup files.
   1. Create a /backups directory in /var/lib/pgsql/ and change ownership to postgres.
      • cd /var/lib/pgsql/
      • mkdir backups
      • chown -R postgres:postgres backups
   2. Make a dump file of your site database. You have to do a PostgreSQL dump because we are upgrading the PostgreSQL application as part of this upgrade.
      • su - postgres
      • /usr/bin/pg_dumpall > /var/lib/pgsql/backups/teamforge_data_backup.dmp
      • exit
      If your reporting database is running on a separate port, backup your reporting database as well.
      • /usr/bin/pg_dumpall -p <reports_database_port> > /var/lib/pgsql/backups/teamforge_reporting_data_backup.dmp
      • exit
      Copy the database backup to the backup directory.
      • mkdir -p /tmp/backup_dir
      • cp /var/lib/pgsql/backups/teamforge_data_backup.dmp /tmp/backup_dir/
      If your reporting database is running on a separate port, copy your reporting database dump as well.
      • cp /var/lib/pgsql/backups/teamforge_reporting_data_backup.dmp /tmp/backup_dir/

Do this on the application server - my.app.host

5. Move the collabnet repository of the older version of TeamForge.
   • mv /etc/zypp/repos.d/collabnet-7.2.0.x.repo /etc/zypp/repos.d/collabnet-7.2.0.x.repo.cn_backup
   Note: Replace "x" with the appropriate patch release number if applicable.
6. Configure your TeamForge 8.0 installation repository. See TeamForge installation repository configuration for SUSE.
7. Uninstall the TeamForge CLI add-on.
   • cd /opt/collabnet/teamforge/add-ons/teamforge_cli_server
   • ./install --uninstall
   • zypper remove teamforge_cli_server
8. Install the following application packages.
   1. TeamForge: To install the TeamForge application packages run the following command:
      • zypper install teamforge-app teamforge-etl
   2. Black Duck Code Sight: To install the Black Duck Code Sight packages run the following command:
      • zypper install teamforge-codesearch
9. In the site-options.conf file, make sure you do the following.
   Note: Back up your site-options.conf file before making any changes.
   • vi /opt/collabnet/teamforge-installer/8.0.0.1/conf/site-options.conf
   1. Update the host name and domain name, if required.

      HOST_localhost=app etl indexer

      HOST_my.db.domain.com=database datamart 

      HOST_my.scmandgit.domain.com=subversion cvs gerrit

      DOMAIN_localhost=my.app.domain.com

      Add 'codesearch' to the HOST_localhost token if you are installing Black Duck Code Sight.

      HOST_my.localhost=app etl indexer codesearch

   2. Turn on the SSL for your site by editing the relevant variables in the site-options.conf file. To generate the SSL certificates, see Generate SSL certificates.

      • SSL=on

      • SSL_CERT_FILE

      • SSL_KEY_FILE

      • SSL_CA_CERT_FILE

      • SSL_CHAIN_FILE

      Note: The SSL_CA_CERT_FILE and SSL_CHAIN_FILE are optional.
   3. If your site is running in SSL mode (SSL=on), add the following java runtime property to the JBOSS_JAVA_OPTS token.

      JBOSS_JAVA_OPTS=-Xms1536m -Xmx1536m -XX:MaxPermSize=512m -server -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/tmp -verbose:gc -XX:+
      PrintGCTimeStamps -XX:+PrintGCDetails -Djsse.enableSNIExtension=false -Dsun.rmi.dgc.client.gcInterval=600000 -Dsun.rmi.dgc.server.gcInterval=600000
      

   4. If the token REQUIRE_PASSWORD_SECURITY is enabled, then set a value for the token, PASSWORD_CONTROL_EFFECTIVE_DATE.
      CAUTION:
      The Password Control Kit (PCK) disables, deletes or expires user accounts that don't meet the password security requirements starting from the date set for the PASSWORD_CONTROL_EFFECTIVE_DATE token. If a date is not set, the PCK disables, deletes or expires user accounts immediately. See PASSWORD_CONTROL_EFFECTIVE_DATE for more information.
   5. TeamForge 7.1 and later support automatic password creation. See AUTO_DATA for more information.
   6. Password Obfuscation
      

      The password obfuscation is enabled by default. As a result, all password-related tokens are encrypted in all the TeamForge configuration files.

      Restriction: The password-related tokens cannot contain the following characters in the site-options.conf file: $<>/\'"`
      • To disable password obfuscation, set OBFUSCATION_ENABLED=false.
      • To configure the obfuscation key, set OBFUSCATION_KEY=<Any AlphaNumeric value with length >= 8 bytes>. The default value of OBFUSCATION_KEY token is XSJt43wN.
   7. Ensure to set the token DEDICATED_INSTALL=true.
   8. Include the list of non-expiring TeamForge user accounts (password never expires).

      USERS_WITH_NO_EXPIRY_PASSWORD=admin,nobody,system,scmviewer,scmadmin

   9. Make sure that the following tokens have a value if ETL is enabled.

      SOAP_ANONYMOUS_SHARED_SECRET

      ETL_SOAP_SHARED_SECRET

   10. Configure Black Duck Code Sight tokens. See Black Duck Code Sight site-option tokens.
   11. To enable the history protection feature of TeamForge Git integration, set the GERRIT_FORCE_HISTORY_PROTECTION=true. For more information, see GERRIT_FORCE_HISTORY_PROTECTION.
   12. If you have LDAP set up for external authentication, you must set the “REQUIRE_USER_PASSWORD_CHANGE” site options token to false.
   13. If you are installing TeamForge through disconnected media, set the token HELP_AVAILABILITY=local.
   14. Save the site-options.conf file.
10. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V
11. Restore the Review Board data.
    • su - postgres
    • /usr/bin/pg_dumpall < /var/lib/pgsql/backups/rb_data_backup.dmp
    • exit
12. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V
13. Update the file permissions on your site's data.
    • /opt/collabnet/teamforge/runtime/scripts/fix_data_permissions.sh
    Note: This process can take a long time for sites with a lot of data.

Do the following on the database server - my.db.host

14. Configure your TeamForge 8.0 installation repository. See TeamForge installation repository configuration for SUSE.
15. If the PostgreSQL database is running locally, stop the PostgreSQL service.
    • /etc/init.d/postgresql stop
16. Uninstall the PostgreSQL RPMs.
    Note: When prompted, you must select the option to remove all the dependent packages.
    • zypper remove postgresql-libs postgresql-docs postgresql-server postgresql
17. Install the TeamForge database packages.
    • zypper install teamforge-database
18. Copy the site-options.conf file from my.app.host and modify the token settings.
    Note: If you choose to use the old site-options.conf file, don’t forget to copy the AUTO_DATA token from the application server.
    1. Set the following tokens.

       HOST_my.db.host=database datamart

       DOMAIN_my.db.host=my.db.domain.com

       HOST_my.app.domain.com=app etl indexer

       HOST_my.scmandgit.domain.com=subversion cvs gerrit

    2. Save the site-options.conf file.
19. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V
20. Restore your site data.
    1. Reload the PostgreSQL data.
       • su - postgres
       • /usr/bin/psql < /tmp/dbbackup_dir/teamforge_data_backup.dmp
       • exit
       Note: If your reporting database is running on a separate port, restore that data too.
       • su - postgres
       • /usr/bin/psql -p <reports_database_port> < /tmp/dbbackup_dir/teamforge_reporting_data_backup.dmp
       • exit
21. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V

Do this on application server - my.app.host

22. Convert your site data to work with TeamForge 8.0.
    Tip: Before you kick off the data migration, do the following:

    • Use the /etc/init.d/collabnet status command to make sure the JBoss, Tomcat and Tomcatcs services are stopped.
    • If any of the trackers in your project already contains a field with the name team, conflict may arise while running the migrate.py script. This is because of the inclusion of the Team feature in TeamForge 8.0. To prevent this conflict, follow the steps given in FAQ on troubleshooting.
    • /opt/collabnet/teamforge/runtime/scripts/migrate.py
    The migrate.py script locates the existing site data and modifies it as needed.

    This includes configuration data for LDAP and the James mail server. Any modifications that you have applied to these components on your old site are reproduced on your upgraded TeamForge 8.0 site.

23. Start TeamForge.
    • /etc/init.d/collabnet start
24. If you have CVS integrations, synchronize permissions post upgrade. See, Synchronize TeamForge source control integrations.
25. Run the TeamForge post installation script. For more information, see post-install.py.
    • /opt/collabnet/teamforge/runtime/scripts/post-install.py
26. Install the Black Duck Code Sight license on the server where Black Duck Code Sight is installed. For more information see these instructions.
27. Run the svn_cache.sh script.
    • cd /opt/collabnet/teamforge/runtime/scripts/codesearch/
    • ./svn_cache.sh <Repository Base URL Path of the SCM Integration Server>

    Provide a repository base URL path of the SCM integration server, for example, "http://myint.box.net/svn/repos", where myint.box is the server with the SCM integration server.

    In addition, if you add a new integration server at some point later, you must run this svn_cache.sh script, (after creating the new integration server), on the TeamForge application server.

Do the following on the SCM server - my.scmandgit.host

If your TeamForge setup includes source control running on its own server, you'll have to upgrade that server as well as the main TeamForge application server.

28. Stop TeamForge.
    • /etc/init.d/apache2 stop
    • /etc/init.d/collabnet stop tomcat
29. Back up your SCM data.
    Tip: /tmp in the following step is just an example. You can use any directory or partition that you prefer.
    1. Make an archive with the following data directories.

       Directory	Contents
       /svnroot	Subversion source code repositories
       /cvsroot	CVS source code repositories (not present in all sites)
       /gitroot	Git source code repositories

       • mkdir -p /tmp/scmbackup_dir/gerrit
       • cp -Rpfv /svnroot /cvsroot /tmp/scmbackup_dir
    2. Back up your Git database and make a dump of your Git database. You have to do a PostgreSQL dump because we are upgrading the PostgreSQL application as part of this upgrade.
       • su - postgres
       • /usr/bin/pg_dumpall > /var/lib/pgsql/backups/git_data_backup.dmp
       • exit
       Copy the database backup to the backup directory.
       • cp /var/lib/pgsql/backups/git_data_backup.dmp /tmp/scmbackup_dir/gerrit
       • cp -Rpfv /gitroot /tmp/scmbackup_dir/gerrit
       • cp -Rpfv /opt/collabnet/gerrit/etc /opt/collabnet/gerrit/.ssh /tmp/scmbackup_dir/gerrit
    3. Back up your SSH keys, if any.
    4. Back up your SSL certificates and keys, if any.
30. Move the collabnet repository of the older version of TeamForge.
    • mv /etc/zypp/repos.d/collabnet-7.2.0.x.repo /etc/zypp/repos.d/collabnet-7.2.0.x.repo.cn_backup
    Note: Replace "x" with the appropriate patch release number if applicable.
31. Configure your TeamForge 8.0 installation repository. See TeamForge installation repository configuration for SUSE.
32. If Git is enabled and the PostgreSQL database is running locally:
    1. Stop the PostgreSQL service.
       • /etc/init.d/postgresql stop
    2. Uninstall the PostgreSQL RPMs.
       Note: When prompted, you must select the option to remove all the dependent packages.
       • zypper remove postgresql-libs postgresql-docs postgresql-server postgresql
33. Install the following application packages.
    1. Install the source code component.
       • zypper install teamforge-scm
    2. To install the Git packages, run the following command.
       • zypper install teamforge-git
34. Copy the master site-options.conf file from my.app.host and modify the host token settings in the site-options.conf file.
    Note: If you choose to use the old site-options.conf file, don’t forget to copy the AUTO_DATA token from the application server.

    HOST_my.scmandgit.host=subversion cvs gerrit

    DOMAIN_my.scmandgit.host=my.scmandgit.domain.com

    HOST_my.app.domain.com=app etl indexer codesearch

    HOST_my.db.domain.com=database datamart

35. Save the site-options.conf file.
36. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V
37. Restore your Git data (if Git is enabled).
    1. Reload the PostgreSQL data.
       • su - postgres
       • /usr/bin/psql < /tmp/scmbackup_dir/git_data_backup.dmp
       • exit
38. Recreate the runtime environment.
    • cd /opt/collabnet/teamforge-installer/8.0.0.1
    • ./install.sh -r -I -V
39. Update the file permissions on your site's data.
    • /opt/collabnet/teamforge/runtime/scripts/fix_data_permissions.sh
    Note: This process can take a long time for sites with a lot of data.
40. Start the Tomcat service.
    • /etc/init.d/collabnet start tomcat
41. Run the TeamForge post installation script. For more information, see post-install.py.
    • /opt/collabnet/teamforge/runtime/scripts/post-install.py
42. Apply the finishing touches and make sure everything is running smoothly after upgrading to TeamForge 8.0.
    Important: Do not delete the teamforge-installer/8.0.0.1 directory. You will need it for future maintenance and upgrades.
    1. Log into your site as the administrator.
    2. If your site has custom branding, verify that your branding changes still work as intended. See Customize anything on your site.
    3. Let your site's users know they've been upgraded. See Communicate with all site users at once.
43. Remove the backup files after the TeamForge site is up and running as expected.
    1. Remove the repository and the file system backup from the /tmp/backup_dir directory.
    2. Remove the PostgreSQL 9.2 database dump and the file system from the /var/lib/pgsql/9.2/backups and /var/lib/pgsql/9.2/data directories respectively.