This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| getting_started:install_ubuntu_update [2016/12/29 09:04] – [Install the CakePHP v3 application] admin | getting_started:install_ubuntu_update [2017/06/14 12:59] (current) – [Applying the Database Patches] admin | ||
|---|---|---|---|
| Line 9: | Line 9: | ||
| <WRAP center round tip 100%> | <WRAP center round tip 100%> | ||
| - | This is a once-off action | + | This is a once-off action |
| </ | </ | ||
| Line 30: | Line 30: | ||
| ===== Check the Nginx config | ===== Check the Nginx config | ||
| <WRAP center round tip 100%> | <WRAP center round tip 100%> | ||
| - | This is a once-off action | + | This is a once-off action |
| </ | </ | ||
| Line 61: | Line 61: | ||
| ---------------------- | ---------------------- | ||
| + | |||
| + | ===== Install The Improved Dynamic Login Pages ===== | ||
| + | <WRAP center round tip 100%> | ||
| + | This is a once-off action and only needs to be done once if you are still running the older login pages that has a seperate page for mobile devices and desktop devices. | ||
| + | </ | ||
| + | |||
| + | * Check out the latest login pages from the SVN repository. | ||
| + | <code bash> | ||
| + | cd / | ||
| + | sudo svn checkout svn:// | ||
| + | </ | ||
| + | |||
| + | ---------------------- | ||
| + | |||
| ===== Update the code ===== | ===== Update the code ===== | ||
| Line 75: | Line 89: | ||
| sudo svn update | sudo svn update | ||
| #Login Pages | #Login Pages | ||
| - | cd / | + | cd / |
| sudo svn update | sudo svn update | ||
| + | |||
| + | #Confirm the rights | ||
| + | |||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | |||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | |||
| + | |||
| </ | </ | ||
| ------------ | ------------ | ||
| - | ===== Patching the database ===== | ||
| - | * Here we'll list the sql patches to run against the database. | ||
| + | ===== Applying the Database Patches ===== | ||
| + | * As the code evolve we sometimes create patches to the database. Run the following instructions to apply the latest patches. | ||
| + | * These patches are non-destructive which means you can run them multiple times without harm done. | ||
| + | <code bash> | ||
| + | cd / | ||
| + | sudo mysql -u root rd < correct_realm_acos.sql | ||
| + | sudo mysql -u root rd < rd_rename_key_column.sql | ||
| + | sudo mysql -u root rd < rd_photo_add_active_column.sql | ||
| + | sudo mysql -u root rd < rd_photo_more_enhancements.sql | ||
| + | sudo mysql -u root rd < top_up_improvements.sql | ||
| + | sudo mysql -u root rd < add_language_selection_to_dynamic_details.sql | ||
| + | sudo mysql -u root rd < captive_portal_dns.sql | ||
| + | sudo mysql -u root rd < byod_improvements.sql | ||
| + | sudo mysql -u root rd < rd_rename_key_column_2.sql | ||
| + | sudo mysql -u root rd < correct_users_and_groups_aros.sql | ||
| + | </ | ||
| + | |||
| + | ------ | ||
| + | |||
| + | ===== Copy the existing images | ||
| + | * 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. | ||
| + | <code bash> | ||
| + | #realms | ||
| + | sudo cp / | ||
| + | #Dynamic Details | ||
| + | sudo cp / | ||
| + | #Dynamic Photos | ||
| + | sudo cp / | ||
| + | #Change the ownership | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | </ | ||
| + | |||
| + | |||
| + | ===== Updating the rights system on the database ===== | ||
| + | * Since we are migrating from CakePHP v2 to CakePHP v3 some conventions on the rights system changed. | ||
| + | * We developed a script which you can run to fix these conventions for you. | ||
| + | * Again this script is non-destructive which means you can run it multiple times, especially after new code has been added from the SVN repository. | ||
| + | |||
| + | <code bash> | ||
| + | cd / | ||
| + | sudo ./bin/cake migrate_radiusdesk | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | sudo chown -R www-data. / | ||
| + | </ | ||
| + | |||
| + | <WRAP center round important 100%> | ||
| + | == Please Take Note == | ||
| + | * The current version of FreeRADIUS available on the repository (3.0.12) has this bug: http:// | ||
| + | * 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: | ||
| + | * Once the repository has been updated we will remove this //' | ||
| + | </ | ||