Update TermWeb 4 with new version

Prior to start update:

  1. Stop Tomcat

  2. Make database backup, backup previous installation from apache httpd www folder, <Tomcat>/webapps ROOT folder.

  3. Your distributive archive will contain two files: termweb4.war and termweb-ui.zip.

    1. termweb4.war must replace previous version installed to <Tomcat>/webapps/ROOT, don’t forget to delete all old files from ROOT folder.

    2. Contents of directory dist from termweb-ui.zip must replace previous version installed to /var/www/termweb4, don’t forget to delete all old files from termweb4 folder.

  4. Start Tomcat and check startup logs in catalina.out

  5. If tomcat logs doesn’t contain any error start Apache httpd and test installation of TermWeb 4.

If you’re upgrading from a version earlier than 4.0.5-2 to a later version you will also need to perform the following two actions:

  • Prior to start tomcat with new version update your database with next script:

    ALTER DATABASE `<scheme_name>` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci; ALTER TABLE `schema_version` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; ALTER TABLE `schema_version` CHANGE `description` `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `schema_version` CHANGE `installed_by` `installed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `schema_version` CHANGE `script` `script` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `schema_version` CHANGE `type` `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `schema_version` CHANGE `version` `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

     

  • Modify database connection string by replacing characterEncoding=UTF8 with character_set_server=utf8mb4&connectionCollation=utf8mb4_general_ci in termweb.properties file.

If you’re upgrading to version 4.0.9 or later you will also need to download and install mysql-connector-j, as outlined under Install TermWeb 4: .