9.2

Edit

Upgrade from v9.2.12 to v9.2.13

This guide describes the steps for applying the 9.2.13 patch to SPA v9.2.12.

Prerequisites

To apply the patch, meet the following prerequisites:

  • You have WorkFusion SPA 9.2.12 installed.
  • Perform all actions for applying the 9.2.13 patch as <WF_USER>. The root user is not required.
  • You have set the values of all variables in the /patches/patch_9.2.13/vars file according to the relevant path.

Upgrade procedure

Prepare all nodes for patching

To prepare for patching, do the following:

  1. On each Linux server, create the <install_dir>/patches/patch_9.2.13 directory, download the patch, and extract it into the directory:

    $ mkdir -pv <install_dir>/patches/patch_9.2.13
$ cd <install_dir>/patches/patch_9.2.13
$ curl -o 'patch_9.2.13.tar.gz' '<patch download url>'
$ tar xzf patch_9.2.13.tar.gz

    You will see the following directory structure:

    -rwxrwxr-x.  1 wfuser wfuser      18453 Feb  9 07:16 patch_9.2.13.sh
-rw-rw-r--.  1 wfuser wfuser 3502219630 Feb  9 08:49 patch_9.2.13.tar.gz
drwxrwxr-x. 16 wfuser wfuser        226 Feb  7 10:12 sources
-rw-rw-r--.  1 wfuser wfuser        171 Feb  9 07:01 vars

  2. On the DB server, in the <install_dir>/patches/patch_9.2.13/vars file, specify the credentials for the MySQL:

    export INSTALL_DIR='put install_dir path'
export MYSQL_ADMIN='put mysql admin user'
export MYSQL_PASS='put mysql admin password'

  3. On the DB server, verify that the added credentials are correct:

    $ source <install_dir>/patches/patch_9.2.13/vars
$ <install_dir>/mysql/usr/bin/mysqlcheck -h 127.0.0.1 -P 3306 -u$MYSQL_ADMIN -p$MYSQL_PASS --check-upgrade --all-databases

    You will see a similar output:

    mysql.columns_priv                                 OK
mysql.db                                           OK

........ (lots of similar output) .....

wfdb.worker_interest                               OK
wfdb.workeractivitylog_test                        OK

  4. On each Linux server, stop all WorkFusion services:

    $ wfmanager stop all

Upgrade DB server

To upgrade the database on the DB server, execute the following commands:

$ cd <install_dir>/patches/patch_9.2.13
$ source vars
$ ./patch_9.2.13.sh upgrade_db

You will see the following output:

Thu Sep  8 17:21:25 UTC 2022 Updating components on DB server
Thu Sep  8 17:21:25 UTC 2022 Backing up mysql binaries and configuration...
mkdir: created directory ‘backup/mysql_5.7.38’
Thu Sep  8 17:21:25 UTC 2022 Extracting mysql components...
hu Sep  8 17:21:32 UTC 2022 Restoring mysql configuration...
Thu Sep  8 17:21:32 UTC 2022 Verifying mysql upgrade status

Inspect the output of the MySQL status for any errors or not-OK statuses. It must return OK for each test. If the check is successful, execute the following commands to update the database schema:

$ wfmanager start mysql 
# wait till mysql has started
$ cd <install_dir>
$ mysql/usr/bin/mysql_upgrade -h 127.0.0.1 -P 3306 -u$MYSQL_ADMIN -p$MYSQL_PASS

Upgrade VDS Master server

To upgrade VDS Master, on the vdsmaster server, execute the following commands:

$ cd <install_dir>/patches/patch_9.2.13
$ source vars
$ ./patch_9.2.13.sh upgrade_vdsmaster

You will see the following output:

Thu Sep  8 17:22:10 UTC 2022 Upgrading components on VDS master 
Thu Sep  8 17:22:10 UTC 2022 Updating zookeeper to version: 3.8.0
19:22:14  Thu Sep  8 17:22:13 UTC 2022 Backing up zookeeper directory
19:22:14  mkdir: created directory ‘../backup/zookeeper_3_4_10’
19:22:15  Thu Sep  8 17:22:14 UTC 2022 Cleaning up zookeeper old binaries
19:22:15  Thu Sep  8 17:22:14 UTC 2022 Adopt the zookeeper configuration file for the new version. Setting snapshot.trust.empty=true
19:22:15  Thu Sep  8 17:22:14 UTC 2022 Adopt zookeeper configuration file for the new version. Setting admin.enableServer=false
19:22:15  Thu Sep  8 17:22:14 UTC 2022 Extracting zookeeper binaries ...
19:22:18  Thu Sep  8 17:22:18 UTC 2022 Zookeeper update completed
19:22:18  Thu Sep  8 17:22:18 UTC 2022 VDS master upgrade completed

Post-upgrade steps

After the upgrade, on the APP server, check a Business Process as <WF_USER>:

$ cd /tmp/workfusion-full-package-9.2.2.0-35/
$ ./install.sh check_raw app -e @/tmp/config_overrides.yml -e test_rpa=true -e test_ocr=true -e test_ml=true
← PreviousNext →