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 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.
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.
Start MySQL Workbench.
Once MySQL Workbench has started, select ‘Local instance MySQL56’ and click Connect.
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).
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.
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’.
Click the General tab and scroll down to the ‘SQL’ section.
In the ‘sql-mode’ text field, add the following to the existing string (before the closing quotation marks): ,ANSI_QUOTES .
Be sure to add the comma and do not leave any blank spaces.
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.
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.
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.
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.
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.
Locate and launch the latest Appspace Installation Center setup file on your server machine.
If prompted by a security warning, click Run to continue.
Click Next on the ‘Welcome to the Appspace Installation Center Setup Wizard’ window.
In the End-User License Agreement window, check the box to accept the terms in the License Agreement and click Next to continue.
In the Choose Setup Type window, select Typical (this is the most common type of installation).
Click Install to begin the installation.
If prompted, click Yes to allow the program to make changes to the computer.
Click Finished when you see the ‘Completed the Appspace Installation Center Setup Wizard’ message.
Once the latest version of Appspace Installation Center has been installed, you may proceed with the update of your Appspace server.
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).
If prompted by a warning, click Yes to allow the program to make changes to the computer.
Click Upgrade in the ‘Welcome to Appspace Installation Center’ window.
You may choose to update Appspace default templates if you desire and click Next to continue.
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).
Replacing templates increases the duration of the upgrade process. Typical Appspace servers version 5.0 and later do not need to update the templates.
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.
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.
Click OK when you see the “Appspace Installation Complete” message.
Perform a manual restart of your Windows server.