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/31 14:55] – [Update the code] 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. / | ||
| + | |||
| + | |||
| </ | </ | ||
| Line 82: | Line 117: | ||
| - | ===== Changing | + | ===== Applying |
| - | * RADIUSdesk makes use of the advanced rights management available with CakPHP. | + | * As the code evolve |
| - | * Between CakePHP v2 and CakePHP v3 some conventions changed and we have to update some entries in the rights that was defined. | + | * These patches are non-destructive which means you can run them multiple times without harm done. |
| - | * In the past an Access Controller method called by a web page could look like this **index_ap**. | + | <code bash> |
| - | * The new convention is **indexAp**. | + | cd / |
| - | * The following table will indicate which methods were updated with the migration. | + | sudo mysql -u root rd < correct_realm_acos.sql |
| - | * Go to **Other | + | 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 | ||
| + | </code> | ||
| - | ^ Controller | + | ------ |
| - | | Ssids | index_ap | + | |
| - | <WRAP center round info 100%> | + | ===== Copy the existing images |
| - | Be sure to check this table out upon each SVN update since it will grow as we migrate | + | * We need to move the existing images to a new location |
| - | </WRAP> | + | * 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. / | ||
| + | </code> | ||
| - | ===== Patching the database ===== | ||
| - | * Here we'll list the sql patches to run against the database. | ||
| + | ===== 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 //' | ||
| + | </ | ||