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.

• 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.

• The ExtJS files are the viewer component and lives under the /usr/share/nginx/html/rd directory.

cd /usr/share/nginx/html/rd
sudo svn update

 sudo cp -R /usr/share/nginx/html/rd/build/production/Rd/* /usr/share/nginx/html/

#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>

• We are runnig both CakePHP v2 and CakePHP v3 and will be updating both.

#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

• We made a few enhancements which require the database to be patched

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

• Also a fix or two

cd /usr/share/nginx/html/rd_login/
sudo svn update

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