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.
Please note that we’ve stopped support for MS Access databases. actiTIME versions starting from 2019 are working with MySQL databases only. You can keep running your old version with MS Access database, or switch to MySQL to upgrade actiTIME to the newest version.
Please contact actiTIME Support Team at firstname.lastname@example.org to convert actiTIME database from MS Access to MySQL.
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 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_admin.vbs script from the <Tomcat directory>\webapps\actitime folder.
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_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.
- 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;
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.