This procedure describes the process required to update the jtel system, assuming a MySQL server 8.0.x and portal release 3.23 or above.

Running Commands

Backup

Snapshots

Cold Snapshots

The simplest way to backup a system is using cold snapshots - i.e. shutdown the relevant VMs and take a snapshot when they are powered off.

This will ensure a consistent backup.

Live Snapshots

Live snapshots may not work.

In particular, if you are using replication, a running "live" snapshot of two databases may be inconsistent, and you may need to rebuild the slave after restoring the snapshot.

Also, when using DRBD to replicate the file system, this may also not work.

If you do take live snapshots, then it is probably best to:

• Snapshot the slave database before the master. That way, you have a chance that the slave can catch up to the master. If you do it the other way round, the slave will always be inconsistent as the master will not have the next position in the binary logs when it starts.
• Snapshot the passive storage before the active storage. The same principle applies. 

Note, this will only give you a chance of data consistency, not a guarantee.

Manual Backup

If you do a manual backup, then as a minimum, backup the following:

Data Directory

Tar up the data directory on the active STORE machine as follows:

tar cfvz /srv/jtel/shared/Data_Before_Update.tar.gz /srv/jtel/shared/Data

MySQL 

Backup the MySQL Master Database from the active STORE machine as follows:

mysqldump -uUSER -pPWD --single-transaction --master-data=2 --databases JTELWeb JTELStats JTELStats2 JTELLog --add-drop-database --add-drop-table --events --routines --triggers > /srv/jtel/shared/MySQL_Master_Before_Backup.sql

Check GIT Status

Check the GIT status of the repository on the active STORE as follows, for the JTEL and JTELCarrierPortal repositories:

cd /srv/jtel/shared/JTEL
git status
cd /srv/jtel/shared/JTELCarrierPortal
git status

You should see output like this for both directories:

On branch release/stable-3.27
Your branch is up to date with 'origin/release/stable-3.27'.

nothing to commit, working tree clean

Files which have been changed or are not tracked

Example

The following shows an example of this:

On branch release/stable-3.27
Your branch is up to date with 'origin/release/stable-3.27'.

Changes not staged for commit:
  (use "git add <file>..." to update what will be committed)
  (use "git restore <file>..." to discard changes in working directory)
        modified:   AppServer/jtel.Portal.Daemon.FTP.CheckUploads.j5

Untracked files:
  (use "git add <file>..." to include in what will be committed)
        DB/NetworkIVR/MyNewScript.sql

no changes added to commit (use "git add" and/or "git commit -a")

Backup Changes and Untracked Files

Now, backup any files which have been changed, and any files which are not included in the repository.

Also, make a note of the exact commit, in which the repository was in.

The following script will do this for you:

# Directory Name in /srv/jtel/shared/backup
JT_DATE_TIME=$(date +%F-%H%M%S)

# JTEL Directory
cd /srv/jtel/shared/JTEL
mkdir -p ../backup/${JT_DATE_TIME}/JTEL
git rev-parse HEAD > ../backup/${JT_DATE_TIME}/JTEL/README_git_commit_hash.txt
git status > ../backup/${JT_DATE_TIME}/JTEL/README_git_status.txt
rsync -R $(git ls-files --modified --others --exclude-standard) ../backup/${JT_DATE_TIME}/JTEL

# JTELCarrierPortal Directory
cd /srv/jtel/shared/JTELCarrierPortal
mkdir -p ../backup/${JT_DATE_TIME}/JTELCarrierPortal
git rev-parse HEAD > ../backup/${JT_DATE_TIME}/JTELCarrierPortal/README_git_commit_hash.txt
git status > ../backup/${JT_DATE_TIME}/JTELCarrierPortal/README_git_status.txt
rsync -R $(git ls-files --modified --others --exclude-standard) ../backup/${JT_DATE_TIME}/JTELCarrierPortal

Revert or Delete Files

Now, the files must be deleted or reverted.

The following script will do this for you:

# JTEL Directory
cd /srv/jtel/shared/JTEL
git checkout -- .
git clean -fd

# JTELCarrierPortal Directory
cd /srv/jtel/shared/JTELCarrierPortal
git checkout -- .
git clean -fd

cd /srv/jtel/shared/

Update

Stop Services

Stop the following services:

Pull the Updates

Pull the updates as follows:

JTEL

cd /srv/jtel/shared/JTEL
git pull

JTELCarrierPortal

cd /srv/jtel/shared/JTELCarrierPortal
git pull

Checkout the Release

Checkout the required release as follows:

cd /srv/jtel/shared/JTEL
git checkout release/stable-3.28
cd /srv/jtel/shared/JTELCarrierPortal
git checkout release/stable-3.28

Check for a Customer Directory

Check if there is a customer directory with customised software.

This will be in /srv/jtel/shared and will resemble the customer name. For example, for jtel it might be cjtel-software.

Remember the directory name - you will need it in the next step.

Note: recommend you do not mess with this directory, unless you are the author of the directory contents.

Get the new Binaries and Run the Update Script

Run as follows:

cd /srv/jtel/shared/JTELCarrierPortal/Update
bash ./get_binaries.sh
sudo bash ./update_release.sh

You will be asked for the following: