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.
We have done our best to ensure that your data stays safe. However, it is strongly recommended that you make a backup of actiTIME files prior to upgrading actiTIME.
We also recommend you to back up your actiTIME database before the upgrade procedure.
- Stop the Tomcat server.
- Make sure Java 8 is installed.If not, upgrade it. You can check your current Java version by executing the command:
- Make a backup copy of your actiTIME folder located at: <Tomcat directory>/webapps/actitime/.
- Delete the entire <Tomcat directory>/webapps/actitime/ folder.
- Extract actiTIME installation files from the .zip archive to the <Tomcat directory>/webapps/ folder.
- Enter the 'actitime' directory
- 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
- 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;
- Set up database parameters by launching the setup.sh script from the
Launch the script provided in the installation package:
The script has the following launch format:
<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.
- 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;
- Delete old web application data by deleting all files from the Tomcat cache directory <tomcat>/work/<Engine Name>/<Host Name>/actitime/
<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.
- Start the Tomcat server. Enter your license key for the installed version and log in to your actiTIME.