Upgrade Guide from 14.4 to 14.5

Stop and remove all the VRS containers and images running in the docker.
Update your record.lua. Download this file record.lua .
Navigate to the script directory "/usr/local/freeswitch/scripts/" or "/usr/share/freeswitch/scripts/" and paste this file.
Navigate to the recording-solution/docker directory
Open docker-compose-cisco.yml file.
In this file, comment out the Container details of Consul if you don’t want to setup HA.
Also remove the environment variables from all containers in the same file if there is any.
Update all the tags. Add 14.5 in the image of all containers such as jtapi-connector, front-end, mixer, backend-apis for example:
image: gitlab.expertflow.com:9242/voice-recording-solution/jtapi-connector:14.5
Open config.env and tally all the following env variables. Remove the following variables.

	Name	Description
1	NO_OF_DAYS	No of days before which all the files will be archived. If set 2, then except for the last 2 days from the date and time of service started or triggered, all the files will be archived.
2	SFTP_HOST	SFTP host IP for archival
3	SFTP_PORT	22
4	SFTP_USERNAME	Username of the SFTP server
5	SFTP_PASSWORD	SFTP password
6	ARCHIVAL_JOB_INTERVAL	It is a duration that tells the service to trigger again. This value is in hours. For example, if set 24 the service would be triggered after 24 hrs to get the desired job done.
7	STEAM_DELETION_JOB_INTERVAL_HRS	Time in hours before which all the streams are to be deleted. e.g 24
8	RETRY_LIMIT	limit to retry in case the connection fails. e.g 2
9	NO_OF_DEL_DAYS	No of days before which all the streams will be deleted. If set 2, then except for the last 2 days from the date and time of service started or triggered, all the files will be deleted.

Run the following script to create the newly added tables for Archival Setting and Selective Recording. Also to update the existing table

CODE

     CREATE TABLE archival_setting (
        id int IDENTITY(1,1) NOT NULL,
        is_enabled bit NOT NULL,
        external_server_ip varchar(45) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        folder_path nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        password nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        username nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        archive_mode varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        retention_days int NOT NULL,
        copy_time time NULL,
        created_at datetime DEFAULT getdate() NULL,
        updated_at datetime DEFAULT getdate() NULL,
        CONSTRAINT PK__archival__3213E83F4DCA9097 PRIMARY KEY (id)
     );

--Query to insert the default archival setting
INSERT INTO archival_setting (is_enabled, external_server_ip, folder_path, password, username, archive_mode, retention_days, copy_time, created_at, updated_at) VALUES(1, '', '', '', '', '', 0, '', getdate(), getdate());


-- Create recording_rules table
CREATE TABLE recording_rules (
    id int IDENTITY(1,1) NOT NULL,
    rule_action varchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    rule_type varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    mask varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    sun bit DEFAULT 0 NOT NULL,
    mon bit DEFAULT 0 NOT NULL,
    tue bit DEFAULT 0 NOT NULL,
    wed bit DEFAULT 0 NOT NULL,
    thu bit DEFAULT 0 NOT NULL,
    fri bit DEFAULT 0 NOT NULL,
    sat bit DEFAULT 0 NOT NULL,
    from_time time DEFAULT '00:00' NOT NULL,
    to_time time DEFAULT '23:59' NOT NULL,
    priority int NULL,
    screen_capture bit DEFAULT 0 NOT NULL,
    screen_capture_usage int NULL,
    created_at datetime DEFAULT getdate() NOT NULL,
    updated_at datetime NULL,
    CONSTRAINT PK__recordin__3213E83FA16E2E60 PRIMARY KEY (id)
);
ALTER TABLE recording_rules WITH NOCHECK ADD CONSTRAINT CK__recording__scree__17F790F9 CHECK (([screen_capture_usage]>=(0) AND [screen_capture_usage]<=(100)));

ALTER TABLE Mixed_Sessions ADD is_recorded BIT;

Navigate application directory and run ./install-cisco and check you container using docker ps command