Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Upgrading to Web Help Desk 12.6 for MySQL users

Upgrading to Web Help Desk 12.6 for MySQL users

Updated December 17, 2018

Overview

The Web Help Desk 12.6 database upgrade scripts may block the upgrade from finishing for some Web Help Desk environments using MySQL Server database on the backend. The error below is seen in the User Interface.

Spring application did not start successfully.
java.lang.RuntimeException: Spring application did not start successfully.
at com.macsdesign.whd.spring.SpringAppRestClient.waitForSpringApplication(SpringAppRestClient.java:64)
at com.macsdesign.whd.HelpDeskDBLoader.updateDatabase(HelpDeskDBLoader.java:127)
at com.macsdesign.whd.ui.DBUpdateProgress.performAction(DBUpdateProgress.java:139)
at com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:125)
at java.lang.Thread.run(Thread.java:745)

Environment

  • Web Help Desk 12.6
  • MySQL Community Server

Cause 

The installation script cannot locate the 'client' table because it is in lower case. The logs show that the table does not exist due to the lower-case name.

Workaround

Open your MySQL workbench and review the table names for the WHD database. If the table names are in upper case, your configuration will cause the WHD 12.6 upgrade to fail.

There are two ways to work around this issue. Begin by configuring MySQL Community Server to allow non-case-sensitive queries. If you complete this procedure and the issue is not resolved, modify the update script. 

Configure MySQL Community Server to allow non-case-sensitive queries

Perform this procedure to allow non-case-sensitive queries. 

Warning! This procedure applies changes to all databases stored in MySQL Server.

  1. Log in to the server hosting Web Help Desk's MySQL database.
  2. Back up your database using mysqldump.
  3. Drop the database.
  4. In your MySQL Community Server configuration, navigate to:
    /etc/my.cnf
  5. In the [mysqld], add:

    lower_case_table_names=1

  6. Restart mysqld.
  7. Import the backup using the following syntax:

    mysql –u [user] –p < [backup_file]

    This procedure may take several minutes to complete, depending on the size of your database.

  8. Run the Web Help Desk installer.
    If the issue is not resolved, go to Option 2.

Modify the update script

There are two SQL statements that reference the “client” table in lowercase letters when it should be all uppercase letters.

  1. Log in to the server hosting Web Help Desk and run the Web Help Desk 12.6.0 installer to start the upgrade.
    If the upgrade fails, stop Web Help Desk.
  2. Navigate to:

    <webhelpdesk>/bin/webapps/helpdesk/WEB-INF/lib

  3. Back up the following file to another location:

    whd-persistence.jar

    This copied file is where the changes in the steps below will be made

  4. Change the file name from:

    whd-persistence.jar

    to

    whd-persistence.zip

    You can also use 7-Zip for extraction.

  5. Unzip the JAR/ZIP file (from step 4).
  6. Locate upgrade-mysql-12-6-0.sql and open in an editor.
  7. Locate:
    UPDATE client SET email = NULL WHERE email LIKE '%<%>%';
    UPDATE client SET secondary_email = NULL WHERE secondary_email LIKE '%<%>%';
  8. Change this code to:
    UPDATE CLIENT SET email = NULL WHERE email LIKE '%<%>%';
  9. UPDATE CLIENT SET secondary_email = NULL WHERE secondary_email LIKE '%<%>%';
  10. Save the file.
  11. Zip the folder.
  12. Change the ZIP extension to JAR (if JAR was changed).
    The updated archive must have the following name:
    whd-persistence.jar
  13. Copy the updated archive file to the directory below, overwriting the existing file.
    <webhelpdesk>/bin/webapps/helpdesk/WEB-INF/lib
  14. Start Web Help Desk.

 

 

 

Last modified

Tags

Classifications

Public