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/01/17 23:01] – [Patching the database] admingetting_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 and only needs to be done once if you are still running a CakePHP v2 based system
 </WRAP> </WRAP>
  
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 and only needs to be done once if you are still running a CakePHP v2 based system.
 </WRAP> </WRAP>
  
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.
 +</WRAP>
 +
 +  * Check out the latest login pages from the SVN repository.
 +<code bash>
 +cd /usr/share/nginx/html
 +sudo svn checkout svn://dvdwalt@svn.code.sf.net/p/radiusdesk/code/trunk/login ./login
 +</code>
 +
 +----------------------
 +
  
 ===== Update the code ===== ===== Update the code =====
Line 75: Line 89:
 sudo svn update sudo svn update
 #Login Pages #Login Pages
-cd /usr/share/nginx/html/rd_login+cd /usr/share/nginx/html/login
 sudo svn update sudo svn update
  
Line 92: Line 106:
 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/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/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
 +
  
 </code> </code>
Line 98: 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   | +
- +
  
- +------
-<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 152: 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 
 +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
 </code> </code>
  
 +<WRAP center round important 100%>
 +== Please Take Note ==
 +  * The current version of FreeRADIUS available on the repository (3.0.12) has this bug: http://lists.freeradius.org/pipermail/freeradius-users/2016-October/085317.html
 +  * 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:install_ubuntu_freeradius_upgrade|Upgrade FreeRADIUS]] using our own set of packages.
 +  * Once the repository has been updated we will remove this //'detour'// instructions 
 +</WRAP>
  
  
  
Last modified: 2017/01/17 23:01