Get the PDF

Database server upgrade

Run the setup kit on the database server to upgrade it.

Download the

BlackBerry AtHoc

setup kit .zip file to the server.

Right-click the setup kit .zip file and select

Properties

General

Unblock

to unblock the file.

Extract the contents of the setup kit .zip file into a temporary directory.

Due to Windows OS file path length limitations, some of the included utilities may not extract correctly. To avoid this issue, use a short path for the extraction directory. For example, C:\setup. Keep the total number of characters to 20 or less, including the drive letter, colon, and slashes.

Use the

<setupkit_root>/user.yml

configuration file to provide product-specific setup parameters.

This file is included in the setup kit as a template with blocks of related parameters that are commented out and a brief description for each block. To use the parameters in a block, remove the # from the parameter, update it, and save the file.

YAML is indent-sensitive. When you remove the # from a parameter in the block, make sure that you keep the original indentation. You must also remove the # from the block header, even if you update only one parameter in the block. You can validate the YAML at before you save the file.

Uncomment the following lines in the user.yml file:

selected_roles:
- db

args:
  user_input: user.yml

  sql_server_instance: .
  db_name: ngaddata

  admin_db_auth: sql
  admin_db_user: 'sa'
  admin_db_pw: '<password>'

  app_db_auth: sql
  app_db_user: ngad
  app_db_pw: <password>

  db_dir: C:\Program Files (x86)\AtHocENS\Database
  db_log_dir: C:\Program Files (x86)\AtHocENS\Database\Log
  db_archive_dir: C:\Program Files (x86)\AtHocENS\Database\Archive
  app_dir: C:\Program Files (x86)\AtHocENS

  system_url: https://<hostname>.athocdevo.com

Do one of the following:

Right-click the

SetupKit.exe

file from the root folder and run as an administrator.

Run Windows PowerShell as an administrator and then run the

.\SetupKit.exe

script to upgrade the

AtHoc

database server.

The

SetupKit.exe

file starts the installation process and completes the following tasks:

Parses setup parameters from the

user.yml

file.

Creates log directory and writes to log files.

Installs each product in the following order: database, application, support modules.

Reports result and elapsed time.

When the upgrade is complete, the

BlackBerry AtHoc

is database installed and running.

Section:

Upgrade BlackBerry AtHoc