Custom Upgrading 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.
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 as follows:
- Launch Windows Start menu
- Click on Programs
- Find the Java program listing
- Click About Java and see the Java version
Run Command Prompt and execute 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 (.zip) 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.
Database parameters are set up using scripts provided in the installation package.
If you want actiTIME to work with MS Access database, launch one of the following scripts without parameters:
- setup_access_vista.vbs if you are using Windows Vista
- setup_access_win7.vbs if you are using Windows 7, 8, 8.1 or 10
- setup_access.vbs otherwise
If you want actiTIME to work with MySQL database server, launch one of the following scripts.
- setup_mysql_vista.vbs if you are using Windows Vista
- setup_mysql_win7.vbs if you are using Windows 7, 8, 8.1 or 10
- setup_mysql.vbs otherwise
These scripts have the same 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. The 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 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;
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.