Custom Upgrading 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 database parameters.To do that, copy the file actiTIME\WEB-INF\classes\com\actimind\actitime\AT.properties to actiTIME\ where 'actiTIME' is the directory where actiTIME is installed.
- Delete all old application resources. To do that, delete all files and directories from the directory 'actiTIME\WEB-INF', where 'actiTIME' is the directory where actiTIME is installed.
- Replace actiTIME installation files with the new ones. To do that, copy the installation package file (.tar.gz) to the parent directory of the 'actitime' directory (where actiTIME is installed). Unpack the file. The files of your existing actiTIME installation will be overwritten with their new versions.
- Restore your old database parameters. To do that, move the file actiTIME\AT.properties back to the directory actiTIME\WEB-INF\classes\com\actimind\actitime\
- Enter the 'actitime' directory
- 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
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_mysql.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. Log in to your actiTIME.
actiTIME will ask you to copy your license key during the first start. If you don’t have license key and want to continue using the free basic 5-user version, click on the 'Run with Free License' button.