Upgrade

Overview

 This section describes how to proceed to manual upgrade of TSS/Console application. Previous version of TSS/Console is not used anymore.

Procedure contains following steps :

Uninstall previous version

Uninstall previous TSS/Console application. For more information about this step please refer to chapter Manual Uninstall.

Execute update script

You have to execute all scripts from source version to target version. Let consider you upgrade from 7.3 to 8.0, you have to execute  update scripts of 7.3, 7.4, 7.5, 7.6, 8.0. Thus for each version:

•Open SQL Server Management Studio.

•Select database you want to upgrade.

•Execute ‘Update Scripts/[VERSION]/UpdateNext_Check.sql’. If the script detect an error, set variable @take_action to 1 in the UpdateNext_Check script and execute script again.

•Execute ‘Update Scripts/[VERSION]/UpdateNext.sql’.

Install Console application

•Copy folder 'Console' of package to folder where points site IPTWebSite (to get this information, open IIS, select site and click on Basic Settings... button. Information is given by Physical Path textbox. ie: D:\iptwebsite\) and rename it to 'Console.10.1.Y.Z' (version number depends of your installed version number)

•Open IIS

•Right click on folder application and click on Convert to Application

•Click on button Select... and choose proper Application pool

•Press OK to validate

•Edit web.config and replace following elements :

o@HOST@ : IP address of server where is installed application

o@DBMS@ : Database managaement system (SQL Server | mySQL)

o@DATABASE@ : Name of database where point the application (dbipt_10.1.Y.Z)

o@USER@ : User used by database (iptuser)

o@PASSWORD@ : Password used by database (azerqsdf)

o@REDUNDANCY@ : Redundancy identity (1 to 6)

Install TSS application

•Copy folder 'Console' of package to folder where points site IPTWebSite (to get this information, open IIS, select site and click on Basic Settings... button. Information is given by Physical Path textbox. ie: D:\iptwebsite\) and rename it to 'Console.10.1.Y.Z' (version number depends of your installed version number)

•Open IIS

•Right click on folder application and click on Convert to Application

•Click on button Select... and choose proper Application pool

•Press OK to validate

•Edit web.config and replace following elements :

o@HOST@ : IP address of server where is installed application

o@DBMS@ : Database managaement system (SQL Server | mySQL)

o@DATABASE@ : Name of database where point the application (dbipt_10.1.Y.Z)

o@USER@ : User used by database (iptuser)

o@PASSWORD@ : Password used by database (azerqsdf)

o@REDUNDANCY@ : Redundancy identity (1 to 6)

Install IptradeNet application

•Copy IptradeNet to a folder in IIS folder and create a virtual directory to.

•Upgrade IptradeNet:

oGo to folder where IptradeNet has been installed.

oEdit file data.xml

oEdit file to reference new installed version. Let consider you have installed 6.0 version:

 BEFORE:

 <installs active="4.1.16363">

 <install version="4.1.16363" console_url="/iptradenet.console.rc41" tss_url="/iptradenet.tss.rc41" />

 </installs>

  AFTER:

 <installs active="8.0.0.28175">

 <install version="4.1.16363" console_url="/iptradenet.console.rc41" tss_url="/iptradenet.tss.rc41" />

 <install version="8.0.0.28175" console_url="/iptradenet.console.8.0.0.28175" tss_url="/iptradenet.tss.8.0.0.28175" />

 </installs>

o Save changes

Update TSS Settings

•Edit table content APP_GLOBALSETTING.

•Change value of key version.redundancy.identity.x (where x is redundancy identity) and set version of TSS Application

•Change value of key versionselector.redundancy.identity.x (where x is redundancy identity) and set url of TSS Component Manager

•Change value of key tss.redundancy.total and set total number of instance

Example:

•version.redundancy.identity.x = a.a.a.aaaaa

•versionselector.redundancy.identity.x = http://[IP_ADDRESS]/iptradenet

•tss.redundancy.total = 2

Copy dll file

From TSS firmware, copy the StdConfigX.dll to c:\windows\system32\   (where X is replaced by major version). Give Network Service full permission right to this file.

Reset IIS

•Open command line.

•End following command iisreset and press ENTER.

Upgrade Logging Service

This section describes how to upgrade and configure the TSS Logging engine. It is dedicated to listening and storing the log messages coming either through Syslog or through Syslog over WebSocket. It comes in the form of a Windows service that can be controlled (started, stopped or restarted).

1.Stop the IPTRADE Logging Service. 

2.Copy content of folder 'Components\LoggingService' of package to the logging service's folder and replace all existing files. For instance, paste copied files into C:\Program Files\IPTrade\LoggingService.

3.Update (or create if it doesn't exist) the logging service's configuration file named application.cfg in the logging service's folder and write the following default configuration (which can be adapted according to your needs):

syslog.path=C:\Syslog

syslog.filesize=5

syslog.port=514

syslog.http.port=8000

syslog.https.port=

syslog.totalsize=1024

syslog.totalday=180

4.Update the IPTRADE Logging Service using the command (where the option start= auto can be replaced by start= demand to prevent the logging service to automatically start each time the computer is restarted):

sc.exe CONFIG "IPTRADE Logging Service" start= auto

5.Restart the newly updated IPTRADE Logging Service.