Upgrade Site Admin

NOTE: OpenText recommends that you back up Site Admin before you upgrade. See Back Up and Restore Site Admin.

To upgrade to Site Admin 25.2 from a previous version, OpenText recommends that you keep your existing home directory, and use this location as the home directory for the upgraded installation when you run the installer.

You can also upgrade Site Admin by replacing the existing siteadmin.jar file with the updated version.

Upgrade the Embedded Database

When you upgrade Site Admin to version 25.2 from version 25.1 or earlier, if you are using the Embedded database option and you want to preserve state such as controllers and service groups, you must perform additional database upgrade steps.

NOTE: You must adjust these commands if you have customized the database location, username and password.

To upgrade Site Admin to version 25.2

  1. In config.json, change datasource.url from

    jdbc:h2:file:/opt/site-admin/home/data/site-admin-db;DB_CLOSE_ON_EXIT=FALSE

    to

    jdbc:h2:file:/opt/site-admin/home/data/site-admin-db-v2;DB_CLOSE_ON_EXIT=FALSE
  2. Obtain and extract the additional release artifact siteadmin-migrate-h2_25.2.0_COMMON.zip.

  3. Stop Site Admin and save a backup of the existing database (the data directory inside your Site Admin home directory).

  4. Using Java 17, run the following commands in the directory siteadmin-migrate-h2-25.2.0 which was extracted from the zip, replacing <HOME> in each case with your Site Admin home folder:

    java -cp "lib/*:h2-1.4.199.jar" org.flywaydb.commandline.Main -jarDirs=jars -url='jdbc:h2:<HOME>/data/site-admin-db' -locations=flyway/h2,db/migration -user=sa -password= migrate
    java -cp h2-1.4.199.jar org.h2.tools.Script -url 'jdbc:h2:<HOME>/data/site-admin-db' -script site-admin-db.gz -user sa -options compression zip
    java -cp h2-2.2.224.jar org.h2.tools.RunScript -url 'jdbc:h2:<HOME>/data/site-admin-db-v2' -script site-admin-db.gz -options compression zip variable_binary
  5. Start Site Admin 25.2 and verify that your data is present.