This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| getting_started:install_ubuntu_update [2017/05/25 22:25] – [Changing the naming convention on the rights] admin | getting_started:install_ubuntu_update [2017/06/14 12:59] (current) – [Applying the Database Patches] admin | ||
|---|---|---|---|
| Line 130: | Line 130: | ||
| sudo mysql -u root rd < captive_portal_dns.sql | sudo mysql -u root rd < captive_portal_dns.sql | ||
| sudo mysql -u root rd < byod_improvements.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 | ||
| </ | </ | ||
| Line 151: | Line 153: | ||
| - | ===== Patching | + | ===== Updating the rights system on the database ===== |
| - | * Here we'll list the sql patches | + | * 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> | <code bash> | ||
| - | #You can run this multiple times they are non-destructive | + | cd / |
| - | #Rename the key column to avoid clashing with SQL reserved words | + | sudo ./bin/cake migrate_radiusdesk |
| - | sudo mysql -u root rd < / | + | sudo chown -R www-data. |
| - | #Add feature to enable | + | sudo chown -R www-data. |
| - | sudo mysql -u root rd < / | + | sudo chown -R www-data. |
| - | #Some more enhancements | + | sudo chown -R www-data. |
| - | sudo mysql -u root rd < / | + | sudo chown -R www-data. |
| - | #Some DNS Enhancements | + | sudo chown -R www-data. |
| - | sudo mysql -u root rd < / | + | sudo chown -R www-data. / |
| - | #Adjust ACOs rights | + | |
| - | sudo mysql -u root rd < / | + | |
| </ | </ | ||