====== Upgrading VM 2017-0-1 ======
  * There has been some bugs which were identified in the 2017-0-1 VM. 
  * These instructions will help to update your VM to include fixes for these bugs.
  * Always remember to make a backup of your VM before you start to be prepared when disaster strikes.

===== Updating the Hostname to reflect the new version =====
  * Edit the **/etc/hosts** file and update the version.
  * Edit the **/etc/hostname** file and update the version.
  * Reboot the VM and log into it again. Issue the **hostname** command to confirm that it updated successfully.

===== Updating the ExtJS files =====
  * The ExtJS files are the viewer component and lives under the **/usr/share/nginx/html/rd** directory.
<code bash>
cd /usr/share/nginx/html/rd
sudo svn update
</code>
<WRAP center round tip 100%>
Should you wish to serve the optimized code from the Webroot instead of /rd/build/production/Rd/ do the following: 
<code>
 sudo cp -R /usr/share/nginx/html/rd/build/production/Rd/* /usr/share/nginx/html/
</code>
</WRAP>
#If served out of Webroot
sudo vi /usr/share/nginx/html/app.js 
#If served out of built dir
sudo vi /usr/share/nginx/html/rd/build/production/Rd/app.js 
</code>
</WRAP>
<WRAP center round alert 100%>
Be sure to flash you browser cache after this to pull in the latest changes
</WRAP>

===== Updating the CakePHP APPs =====
  * We are runnig both CakePHP v2 and CakePHP v3 and will be updating both.
<code bash>
#First CakePHP v2
cd /usr/share/nginx/html/cake2/rd_cake/
sudo svn update
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/tmp
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/Locale
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/img/flags
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/img/nas
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/img/realms
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/img/dynamic_details
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/img/dynamic_photos
sudo chown -R www-data. /usr/share/nginx/html/cake2/rd_cake/webroot/files/imagecache

#Now CakePHP v3
cd /usr/share/nginx/html/cake3
sudo svn update

#================
#NOTE You might be asked questions on some files, simply choose tc / tf (Their side) each time
#================

sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/tmp
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/logs
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/realms
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_details
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_photos
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/access_providers
sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/files/imagecache

</code>

===== Patch the SQL =====
  * We made a few enhancements which require the database to be patched
<code bash>
cd /usr/share/nginx/html/cake3/rd_cake/setup/db/
#You can run this multiple times they are non-destructive
#Rename the key column to avoid clashing with SQL reserved words
sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_rename_key_column.sql 
#Add feature to enable / disable photos
sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_photo_add_active_column.sql
#Some more enhancements
sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_photo_more_enhancements.sql
#Some DNS Enhancements
sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/captive_portal_dns.sql
#Adjust ACOs rights
sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/correct_realm_acos.sql
</code>

===== Update the Login Pages =====
  * Also a fix or two
<code bash>
cd /usr/share/nginx/html/rd_login/
sudo svn update
</code>

  * **After this your system should contain the very latest code from SVN**

<WRAP center round important 100%>
== Please Take Note ==
  * The current version of FreeRADIUS available on the repository (3.0.12) has this bug: http://lists.freeradius.org/pipermail/freeradius-users/2016-October/085317.html
  * While we wait for the maintainer of the repository to update to the latest stable release please follow the instructions in this page to [[getting_started:install_ubuntu_freeradius_upgrade|Upgrade FreeRADIUS]] using our own set of packages.
  * Once the repository has been updated we will remove this //'detour'// instructions 
</WRAP>