Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
install_24_4 [2024/04/24 07:27] – systeminstall_24_4 [2026/08/15 07:32] (current) – system
Line 243: Line 243:
 sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 </code> </code>
-  * Save the file and restart the MySQL server+  * Save the file. 
 + 
 +=== Enable the Event Scheduler === 
 +  * MariaDB and MySQL has a built in Event Scheduler (like CRON for a database) which is disabled by default. 
 +  * We make use of this feature to automatically optimize some of the database tables. 
 +  * We will enable the Event Scheduler in MariaDB by creating a new file /etc/mysql/conf.d/enable_event_scheduler.cnf 
 +<code bash> 
 +sudo vi /etc/mysql/conf.d/enable_event_scheduler.cnf 
 +</code> 
 +  * Enter these two lines: 
 +<code bash> 
 +[mysqld] 
 +event_scheduler=on 
 +</code> 
 +  * Save the file. 
 +  *  Restart the MySQL server
 <code bash> <code bash>
 sudo systemctl restart mariadb sudo systemctl restart mariadb
 </code> </code>
 +  * You can confirm that it is now enabled by checking the following from the SQL terminal: 
 +<code bash> 
 +sudo mysql -u root  
 +MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'event_scheduler'; 
 ++-----------------+-------+ 
 +| Variable_name   | Value | 
 ++-----------------+-------+ 
 +| event_scheduler | ON    | 
 ++-----------------+-------+ 
 +1 row in set (0.001 sec) 
 +</code>
 ----- -----
 ==== Performance tuning for Nginx ==== ==== Performance tuning for Nginx ====
Line 276: Line 301:
   * RADIUSdesk consists of three components.   * RADIUSdesk consists of three components.
     * **rd** directory with its contents contains all the HTML and JavaScript code and is used as the presentation layer.     * **rd** directory with its contents contains all the HTML and JavaScript code and is used as the presentation layer.
-    * **cake4** is a CakePHPv4 application and can be considered the engine room. This is where the data is processed before it is displayed by the presentation layer.+    * **cake4** is a CakePHPv5 (It was CakePHPv4 initially) application  and can be considered the engine room. This is where the data is processed before it is displayed by the presentation layer.
     * **login** is a directory with various login pages that are managed centrally via the **RADIUSdesk Dynamic Login Pages** applet.     * **login** is a directory with various login pages that are managed centrally via the **RADIUSdesk Dynamic Login Pages** applet.
   * Later we will create various symbolic links from locations within the **rdcore** directory to locations within the document root directory of the web server.   * Later we will create various symbolic links from locations within the **rdcore** directory to locations within the document root directory of the web server.
Line 291: Line 316:
 sudo git clone https://github.com/RADIUSdesk/rdcore.git sudo git clone https://github.com/RADIUSdesk/rdcore.git
 </code> </code>
-  *   This will create an **rdcore** directory containing some subfolders.+  * This will create an **rdcore** directory containing some sub-folders. 
 +  * Check out the CakePHPv5 API back-end application 
 +<code bash> 
 +cd /var/www  
 +sudo git clone https://github.com/RADIUSdesk/rd_cake5.git 
 +</code>
   * It is recommended that you also include the RD Mobile UI.   * It is recommended that you also include the RD Mobile UI.
   * Check out the **rd_mobile** git repository.   * Check out the **rd_mobile** git repository.
Line 297: Line 327:
 cd /var/www cd /var/www
 sudo git clone https://github.com/RADIUSdesk/rd_mobile.git sudo git clone https://github.com/RADIUSdesk/rd_mobile.git
 +</code>
 +  * It is further recommended that you include RD-Connect for users to manage their accounts.
 +<code bash>
 +cd /var/www
 +sudo git clone https://github.com/RADIUSdesk/rd_connect.git
 +</code>
 +  * If you feel brave you can also try out out latest RdClient for clients to manage a couple of APs, Mesh Nodes or Permanent Users.
 +<code bash>
 +cd /var/www
 +sudo git clone https://github.com/RADIUSdesk/rd_client.git
 </code> </code>
  
Line 304: Line 344:
 cd /var/www/html cd /var/www/html
 sudo ln -s ../rdcore/rd ./rd sudo ln -s ../rdcore/rd ./rd
-sudo ln -s ../rdcore/cake4 ./cake4+sudo ln -s ../rd_cake5 ./cake4
 sudo ln -s ../rdcore/login ./login sudo ln -s ../rdcore/login ./login
 sudo ln -s ../rdcore/AmpConf/build/production/AmpConf ./conf_dev sudo ln -s ../rdcore/AmpConf/build/production/AmpConf ./conf_dev
-sudo ln -s ../rdcore/cake4/rd_cake/setup/scripts/reporting ./reporting+sudo ln -s ../rd_cake5/rd_cake/setup/scripts/reporting ./reporting
 #For the RD Mobile UI #For the RD Mobile UI
 sudo ln -s ../rd_mobile/build/production/RdMobile ./rd_mobile sudo ln -s ../rd_mobile/build/production/RdMobile ./rd_mobile
 +#For the RD-Connect Mobile UI
 +sudo ln -s ../rd_connect/build/production/RdConnect ./rd_connect
 +#For the RD-Client Mobile UI
 +sudo ln -s ../rd_client/build/production/RdClient ./rd_client
 </code> </code>
  
Line 335: Line 379:
 #Some error messages may appear in the output, which is not a problem - no need to worry #Some error messages may appear in the output, which is not a problem - no need to worry
 sudo su sudo su
-mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root  mysql+mariadb-tzinfo-to-sql /usr/share/zoneinfo | sudo mysql -u root mysql
 </code> </code>
  
Line 358: Line 402:
   * See the example below   * See the example below
 <code bash> <code bash>
-sudo mysql -u root rd < /var/www/rdcore/cake4/rd_cake/setup/db/8.068_add_email_sms_histories.sql +sudo mysql -u root rd < /var/www/html/cake4/rd_cake/setup/db/8.068_add_email_sms_histories.sql  
 +</code> 
 + * Some of these patches may add new columns to existing database tables. In this case, it is recommended to clear the CakePHP models (tables) cache to ensure that the latest changes are also applied there: 
 +<code bash> 
 +sudo su 
 +cd /var/www/rdcore/html/rd_cake/tmp/cache/models 
 +rm * 
 +exit
 </code> </code>
 </alert> </alert>
Line 407: Line 458:
   * To activate the cron scripts, execute the following command, which adds the **RADIUSdesk** cron scripts to the cron system   * To activate the cron scripts, execute the following command, which adds the **RADIUSdesk** cron scripts to the cron system
 <code bash> <code bash>
-sudo cp /var/www/html/cake4/rd_cake/setup/cron/cron4 /etc/cron.d/+sudo cp /var/www/html/cake4/rd_cake/setup/cron/rd_cake5 /etc/cron.d/
 </code> </code>
   * If you want to change the default intervals at which the scripts are executed, simply edit the file /etc/cron.d/cron3.   * If you want to change the default intervals at which the scripts are executed, simply edit the file /etc/cron.d/cron3.
Line 413: Line 464:
 ===== Add LETSENCRYPT certificate ===== ===== Add LETSENCRYPT certificate =====
 <alert type="success"> <alert type="success">
-Since Ubuntu 24.04 has not yet been released, we will use the instructions for 22.04, which should work just as well+Since instructions for Ubuntu 24.04 has not yet been released, we will use the instructions for 22.04, which should work just as well
 </alert> </alert>
   * Instead of repeating the existing documentation, we simply add a URL with the corresponding instructions   * Instead of repeating the existing documentation, we simply add a URL with the corresponding instructions
  • install_24_4.1713936461.txt.gz
  • Last modified: 2024/04/24 07:27
  • by system