Upgrading actiTIME from an Auto Installation Package

You will need local administrator privileges to upgrade actiTIME.

To upgrade actiTIME, perform the following steps:

1. Stop actiTIME web application
2. Launch actiTIME Auto installation package installer (an .exe file)
3. Follow the installation instructions in the installer interfaces. The installer will back up your current database and upgrade the database structure. Your old data will be available after this procedure.
4. Click the "Next" button and continue actiTIME setup.
5. Enter your license key for the installed version and log in to your actiTIME.

The installer will create a new database file and copy data into it from the existing actiTIME database. Your old database file will not be modified.

Upgrading actiTIME from a Custom Installation Package for Windows

actiTIME upgrade procedure includes replacement of actiTIME installation files with the newer ones and update of the database structure. Follow the steps outlined in this instruction to make actiTIME work correctly with your old data.

1. Stop the Tomcat server.
2. Make sure Java 8 is installed.

   If not, upgrade it. You can check your current Java version as follows:

   1. Launch Windows Start menu
   2. Click on Programs
   3. Find the Java program listing
   4. Click About Java and see the Java version

   OR:

   Run Command Prompt and execute the command:

   java -version

3. Make a backup copy of your actiTIME folder located at: <Tomcat directory>\webapps\actitime\.
4. Delete the entire <Tomcat directory>\webapps\actitime\ folder.
5. Extract actiTIME installation files from the .zip archive to the <Tomcat directory>\webapps\ folder.
6. Enter the 'actitime' directory.
7. Copy the file actitime\WEB-INF\classes\com\actimind\actitime\AT.properties from the folder you’ve backed up on step 3 to the folder <Tomcat directory>\webapps\actitime\WEB-INF\classes\com\actimind\actitime
8. Allow actiTIME to create stored functions in its database.

   To do that, run the following query in MySQL under the 'root' user account or under any other user account with SUPER privilege:

   SET GLOBAL log_bin_trust_function_creators = 1;

9. Set up database parameters by launching the setup_admin.vbs script from the <Tomcat directory>\webapps\actitime folder.

   The script has the following launch format:

   setup_admin.vbs
   [/mysqlpath <MYSQLPATH>]

   where

   <MYSQLPATH> is the path to the MySQL executables (where the 'mysql' and 'mysqldump' executable files are placed). If not specified, setup_admin.vbs will ask for it when running.

   Prior to updating the database structure, the setup script backs up the database and saves the data in a file in the 'actitime' directory. The name of the backup file is actitime.mysql4.sql.backup_<YYYYMMDDhhmmss>, where <YYYYMMDDhhmmss> is date and time when the script was run.

10. Revert the MySQL parameter that allows to create stored functions to its previous value (if necessary).

    To do that, run the following query in MySQL under the 'root' user account or under any other user with SUPER privilege:

    SET GLOBAL log_bin_trust_function_creators = 0;

11. Delete old web application data by deleting all files from the Tomcat cache directory <tomcat>/work/<Engine Name>/<Host Name>/actitime/

    where

    <tomcat> is the directory where Tomcat is installed;

    <Engine Name> is the name of the Tomcat engine configured for your installation. Usually it is 'Standalone' or 'Catalina';

    <Host Name> is the name of the virtual host configured for your Tomcat installation.

12. Start the Tomcat server. Enter your license key for the installed version and log in to your actiTIME.

Upgrading actiTIME from a Custom Installation Package for Unix

actiTIME upgrade procedure includes replacement of actiTIME installation files with the newer ones and update of the database structure. Follow the steps outlined in this instruction to make actiTIME work correctly with your old data.

1. Stop the Tomcat server.
2. Make sure Java 8 is installed.If not, upgrade it. You can check your current Java version by executing the command:

   java -version

3. Make a backup copy of your actiTIME folder located at: <Tomcat directory>/webapps/actitime/.
4. Delete the entire <Tomcat directory>/webapps/actitime/ folder.
5. Extract actiTIME installation files from the .zip archive to the <Tomcat directory>/webapps/ folder.
6. Enter the 'actitime' directory
7. Copy the file actitime/WEB-INF/classes/com/actimind/actitime/AT.properties from the folder you’ve backed up on step 3 to the folder <Tomcat directory>/webapps/actitime/WEB-INF/classes/com/actimind/actitime
8. Allow actiTIME to create stored functions in its database.

   To do that, run the following query in MySQL under the 'root' user account or under any other user account with SUPER privilege:

   SET GLOBAL log_bin_trust_function_creators = 1;

9. Set up database parameters by launching the setup.sh script from the /webapps/actitime folder

   Launch the script provided in the installation package:

   The script has the following launch format:

   bash ./setup.sh
   [-mysqlpath <MYSQLPATH>]

   where

   <MYSQLPATH> is the path to the MySQL executables (where the 'mysql' and 'mysqldump' executable files are placed). If not specified, setup.sh will ask for it when running.

   Prior to updating the database structure, the setup script backs up the database and saves the data in a file in the 'actitime' directory. Name of the backup file is actitime.mysql4.sql.backup_<YYYYMMDDhhmmss> where <YYYYMMDDhhmmss> is date and time when the script was run.

10. Revert the permission to create stored functions to the previous (if necessary).

    To do that, run the following query in MySQL under the 'root' user account or under any other user with SUPER privilege:

    SET GLOBAL log_bin_trust_function_creators = 0;

11. Delete old web application data by deleting all files from the Tomcat cache directory <tomcat>/work/<Engine Name>/<Host Name>/actitime/

    where

    <tomcat> is the directory where Tomcat is installed;

    <Engine Name> is the name of the Tomcat engine configured for your installation. Usually it is 'Standalone' or 'Catalina';

    <Host Name> is the name of the virtual host configured for your Tomcat installation.

12. Start the Tomcat server. Enter your license key for the installed version and log in to your actiTIME.