• We assume you have an existing install on Ubuntu 16.04 which you want to update.

• Make sure the following packages are installed:

sudo apt-get install php-cli php-gd php-curl php-xml php-mbstring php-intl

• Check out the cake3 branch from trunk to /usr/share/nginx/html.

cd /usr/share/nginx/html/
sudo svn checkout svn://dvdwalt@svn.code.sf.net/p/radiusdesk/code/trunk/cake3 ./cake3

• Change the following directories to be writable by www-data:

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

• Since we are running both CakePHP v2 and CakePHP v3 simultaneously, you will need to update the Nginx config.
• Edit the /etc/nginx/sites-available/default file:

sudo vi /etc/nginx/sites-available/default

• Look for the following bit and be sure the location line matches this:

location ~ ^/cake2/.+\.(jpg|jpeg|gif|png|ico|js|css)$ {
    rewrite ^/cake2/rd_cake/webroot/(.*)$ /cake2/rd_cake/webroot/$1 break;
    rewrite ^/cake2/rd_cake/(.*)$ /cake2/rd_cake/webroot/$1 break;
    access_log off;
    expires max;
    add_header Cache-Control public;
}  

• Add the next bit for the CakePHP v3 application

location /cake3/rd_cake {
   rewrite ^/cake3/rd_cake(.+)$ /cake3/rd_cake/webroot$1 break;
   try_files $uri $uri/ /cake3/rd_cake/index.php$is_args$args;
}

• Reload the Nginx web server

sudo systemctl reload nginx.service

• Run the following commands to fetch the latest code

#CakePHP v2 Application
cd /usr/share/nginx/html/cake2/rd_cake
sudo svn update
#CakePHP v3 Application
cd /usr/share/nginx/html/cake3
sudo svn update
#Viever
cd /usr/share/nginx/html/rd
sudo svn update
#Login Pages
cd /usr/share/nginx/html/rd_login
sudo svn update
 
#Confirm the rights
 
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
 
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

• RADIUSdesk makes use of the advanced rights management available with CakPHP.
• Between CakePHP v2 and CakePHP v3 some conventions changed and we have to update some entries in the rights that was defined.
• In the past an Access Controller method called by a web page could look like this index_ap.
• The new convention is indexAp.
• The following table will indicate which methods were updated with the migration.
• Go to Other → Rights Managment → Access Controll Objects → Access Providers → Controllers and check that your system has the following changes:

• Be sure to also allow new additions under Access Provider Rights

• We need to move the existing images to a new location
• This is typically a once off but will include more as more parts is migrated.

#realms
sudo cp /usr/share/nginx/html/cake2/rd_cake/webroot/img/realms/* /usr/share/nginx/html/cake3/rd_cake/webroot/img/realms/
#Dynamic Details
sudo cp /usr/share/nginx/html/cake2/rd_cake/webroot/img/dynamic_details/* /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_details/
#Dynamic Photos
sudo cp /usr/share/nginx/html/cake2/rd_cake/webroot/img/dynamic_photos/* /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_photos/
#Change the ownership
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

• Here we'll list the sql patches to run against the database.

#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