RADIUSdesk

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
getting_started:install_ubuntu_update [2017/05/25 22:10] – [Update the code] admingetting_started:install_ubuntu_update [2017/06/14 12:59] (current) – [Applying the Database Patches] admin
Line 117: Line 117:
  
  
-===== Changing the naming convention on the rights ===== +===== Applying the Database Patches ===== 
-  * RADIUSdesk makes use of the advanced rights management available with CakPHP. +  * As the code evolve we sometimes create patches to the database. Run the following instructions to apply the latest patches. 
-  * 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 /usr/share/nginx/html/cake3/rd_cake/setup/db 
-  * The following table will indicate which methods were updated with the migration. +sudo mysql -u root rd < correct_realm_acos.sql 
-  * Go to **Other -> Rights Managment -> Access Controll Objects -> Access Providers -> Controllers** and check that your system has the following changes: +sudo mysql -u root rd < rd_rename_key_column.sql 
- +sudo mysql -u root rd < rd_photo_add_active_column.sql 
-^ Controller      ^ CakePHP v2 Value       ^ CakePHP v3 Value          ^ +sudo mysql -u root rd < rd_photo_more_enhancements.sql 
-| Ssids    | index_ap     | indexAp        | +sudo mysql -u root rd < top_up_improvements.sql 
-| AccessProviders    | change_password     | changePassword    | +sudo mysql -u root rd < add_language_selection_to_dynamic_details.sql 
-| AccessProviders    | export_csv     | exportCsv    | +sudo mysql -u root rd < captive_portal_dns.sql 
-| AccessProviders    | note_index     | noteIndex    | +sudo mysql -u root rd < byod_improvements.sql 
-| AccessProviders    | note_add    | noteAdd    | +sudo mysql -u root rd < rd_rename_key_column_2.sql 
-| AccessProviders    | note_del    | noteDel    | +sudo mysql -u root rd < correct_users_and_groups_aros.sql 
-| AccessProviders    | enable_disable    | enableDisable    | +</code>
-| Tags    | export_csv    | exportCsv   | +
-| Tags    | index_for_filter    | indexForFilter   | +
-| Tags    | note_index     | noteIndex    | +
-| Tags    | note_add    | noteAdd    | +
-| Tags    | note_del    | noteDel    | +
-| Ssids    | index_ap    | indexAp   | +
-| Realms   | export_csv    | exportCsv   | +
-| Realms   | index_for_filter    | indexForFilter   | +
-| Realms    | note_index     | noteIndex    | +
-| Realms    | note_add    | noteAdd    | +
-| Realms    | note_del    | noteDel    | +
-| Realms   | index_ap   | indexAp   | +
-| Realms   | update_na_realm   | updateNaRealm   | +
-| DynamicDetails   | upload_logo   | uploadLogo   | +
-| DynamicDetails   | index_photo   | indexPhoto   | +
-| DynamicDetails   | upload_photo   | uploadPhoto   | +
-| DynamicDetails   | delete_photo   | deletePhoto   | +
-| DynamicDetails   | edit_photo   | editPhoto   | +
-| DynamicDetails   | index_page   | indexPage   | +
-| DynamicDetails   | add_page   | addPage   | +
-| DynamicDetails   | edit_page   | editPage   | +
-| DynamicDetails   | delete_page   | deletePage   | +
-| DynamicDetails   | index_pair   | indexPair   | +
-| DynamicDetails   | add_pair   | addPair   | +
-| DynamicDetails   | edit_pair   | editPair   | +
-| DynamicDetails   | delete_pair   | deletePair   | +
-| DynamicDetails   | note_index   | noteIndex   | +
-| DynamicDetails   | note_add   | noteAdd   | +
-| DynamicDetails   | note_del   | noteDelr  | +
-| DynamicDetails   | edit_settings   | editSettings   | +
-| DynamicDetails   | view_social_login   | viewSocialLogin  | +
-| DynamicDetails   | edit_social_login   | editSocialLogin  | +
-| DynamicDetails   | **NEW**   | shufflePhoto  | +
-| Profiles   | index_ap   | indexAp  | +
-| Profiles   | manage_components   | manageComponents  | +
-| Profiles   | note_index   | noteIndex  | +
-| Profiles   | note_add   | noteAdd  | +
-| Profiles   | note_del   | noteDel  | +
-| Profiles   | index_for_filter  | **DELETE**   | +
-| Profiles   | export_csv  | **DELETE**   |+
  
-  * Be sure to also allow new additions under **Access Provider Rights** +------
- +
- +
-<WRAP center round info 100%> +
-Be sure to check this table out upon each SVN update since it will grow as we migrate more and more controllers from CakePHP v2 to CakePHP v3. +
-</WRAP>+
  
 ===== Copy the existing images  ===== ===== Copy the existing images  =====
Line 198: Line 153:
  
  
-===== Patching the database ===== +===== Updating the rights system on the database ===== 
-  * Here we'll list the sql patches to run against 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> <code bash>
-#You can run this multiple times they are non-destructive +cd /usr/share/nginx/html/cake3/rd_cake 
-#Rename the key column to avoid clashing with SQL reserved words +sudo ./bin/cake migrate_radiusdesk 
-sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_rename_key_column.sql  +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/tmp 
-#Add feature to enable / disable photos +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/logs 
-sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_photo_add_active_column.sql +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/realms 
-#Some more enhancements +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_details 
-sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/rd_photo_more_enhancements.sql +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/dynamic_photos 
-#Some DNS Enhancements +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/img/access_providers 
-sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/captive_portal_dns.sql +sudo chown -R www-data. /usr/share/nginx/html/cake3/rd_cake/webroot/files/imagecache
-#Adjust ACOs rights +
-sudo mysql -u root rd < /usr/share/nginx/html/cake3/rd_cake/setup/db/correct_realm_acos.sql+
 </code> </code>
  
Last modified: 2017/05/25 22:10