Last updated on March 26, 2015

Appspace Upgrade

Introduction

Prior to upgrading your Appspace server, please:

  • Ensure all Appspace installation prerequisites have been fulfilled (.NET framework, Visual C++, and SQL database server). Please refer to the Appspace Installation Prerequisites article.
  • Download the latest version of the Appspace Installation Center.

To perform a full Appspace server upgrade, follow the instructions in the following three sections:

Modifying the MySQL Database

If you are upgrading a version of Appspace that is older than 5.1.0 (e.g. any of the 5.0.3.x releases) – perform the following steps to modify the MySQL database to support ANSI quotes.

Note

If you are upgrading a version of Appspace that is 5.1.0 or later, you may skip the Amending the MySQL Database section and proceed to the Updating Appspace Installation Center section below.

Step 1

Start MySQL Workbench.

In Windows 2008, click the Start button and select MySQL Workbench 6.2 CE (in the MySQL folder).


In Windows 2012, click the Windows icon and select MySQL Workbench 6.2 CE from the Apps menu.

Step 2

Once MySQL Workbench has started, select ‘Local instance MySQL56’ and click Connect.

Note

It is highly recommended that you double-check to ensure the MySQL Workbench connection is pointing to the correct my.ini file. If you recently upgraded MySQL Workbench (e.g. from version 5.x to 6.0) there is a chance that Workbench is pointing to an incorrect path. To edit the my.ini reference, right-click the instance and select Edit Connection. Navigate to the System Profile tab and look at the Configuration File field. This path needs to correctly reference the existing my.ini file of the MySQL database server that was originally configured (i.e. C:/Program Files/MySQL Server 5.x/my.ini).

Step 3

When prompted, type the MySQL server password, g56*k9lp, or enter the custom root password created during the original MySQL installation process. Check the ‘Save password in vault’ option for easier access in the future. Click OK to continue.

Step 4

From the Navigator bar on the left, select Options File under INSTANCE (you may have to re-size the upper half of the menu in order to see and click on this selection). This should open up a tab named ‘Administration – Options File’.

Step 5

Click the General tab and scroll down to the ‘SQL’ section.

Step 6

In the ‘sql-mode’ text field, add the following to the existing string (before the closing quotation marks): ,ANSI_QUOTES .

Warning

Be sure to add the comma and do not leave any blank spaces.

Step 7

Click the Networking tab and scroll down to the ‘Timeout Settings’ and ‘Advanced’ sections. Make the following changes:

  • Check the box for interactive_timeout and give it a value of 30
  • Check the box for wait_timeout and give it a value of 30
  • Check the box for max_connect_errors and give it a value of 300
  • Check the box for max_connections and give it a value of 500

When finished, click the Apply… button to continue.

Step 8

In the ‘Apply Changes to my SQL Configuration File’ window that lists all the configurations that were just made, click the Apply button to confirm the changes.

Step 9

In the Navigator pane on the left, select ‘Startup / Shutdown’ under INSTANCE. ‘The database server instance is’ should read ‘running’. Click the Stop Server button.

Step 10

Wait until you see the ‘The database server instance is’ reads ‘stopped’; this confirms that the MySQL server has shut down. Restart the server at this point by clicking on the Start Server button.


Updating Appspace Installation Center

Before upgrading your Appspace server to a newer version, you must first remove the previous builds of Appspace Installation Center.

Step 1

Go to the Windows Control Panel and double-click ‘Programs and Features’. On the list of installed programs, find Appspace Installation Center and select Uninstall.

Step 2

Locate and launch the latest Appspace Installation Center setup file on your server machine.


If prompted by a security warning, click Run to continue.

Step 3

Click Next on the ‘Welcome to the Appspace Installation Center Setup Wizard’ window.

Step 4

In the End-User License Agreement window, check the box to accept the terms in the License Agreement and click Next to continue.

Step 5

In the Choose Setup Type window, select Typical (this is the most common type of installation).

Step 6

Click Install to begin the installation.

Step 7

If prompted, click Yes to allow the program to make changes to the computer.

Step 8

Click Finished when you see the ‘Completed the Appspace Installation Center Setup Wizard’ message.

Upgrading Appspace

Once the latest version of Appspace Installation Center has been installed, you may proceed with the update of your Appspace server.

Step 1

Locate and launch the Appspace Installation Center (AIC) on your server machine (a shortcut is most likely on the desktop). Launch the AIC using the ‘Run as Administrator’ option (hold down SHIFT + double-click on the icon).

Step 2

If prompted by a warning, click Yes to allow the program to make changes to the computer.

Step 3

Click Upgrade in the ‘Welcome to Appspace Installation Center’ window.

Step 4

You may choose to update Appspace default templates if you desire and click Next to continue.

Danger

Opting to update the templates will also overwrite all existing templates/icons. Do not select this option if you have previously created custom elements/assets relating to widgets (i.e. custom weather widget icons).

Note

Replacing templates increases the duration of the upgrade process. Typical Appspace servers version 5.0 and later do not need to update the templates.

Step 5

Select the correct Database from the drop-down menu and enter the proper values for the Host, Username, and Password fields. Click Validate to proceed with the Appspace server upgrade.

Step 6

Please wait while Appspace is being upgraded. Upgrade durations will vary depending on the system’s resources and hardware specifications. Typical upgrades will require at least 20 minutes. During the upgrade, you may see various messages and status updates.

Step 7

Click OK when you see the “Appspace Installation Complete” message.

Step 8

Perform a manual restart of your Windows server.

In Windows 2008, click the Start button and select the Restart option (you may also alternatively use CTRL + ALT + DEL).


In Windows 2012, press CTRL + ALT + DEL and select the Restart option.