Differences

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

--- install_24_4 [2024/04/24 07:27] – system
+++ install_24_4 [2026/07/06 21:09] (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
 </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>
 sudo systemctl restart mariadb
 </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    |
++-----------------+-------+
+row in set (0.001 sec)
+</code>
 -----
 ==== Performance tuning for Nginx ====
@@ Line 297: / Line 322: @@
 cd /var/www
 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>
@@ Line 310: / Line 345: @@
 #For the RD Mobile UI
 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>
@@ Line 335: / Line 374: @@
 #Some error messages may appear in the output, which is not a problem - no need to worry
 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>
@@ Line 359: / Line 398: @@
 <code bash>
 sudo mysql -u root rd < /var/www/rdcore/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/cake4/rd_cake/tmp/cache/models
+rm *
+exit
 </code>
 </alert>