Differences

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

--- install_24_4 [2024/08/02 07:38] – system
+++ install_24_4 [2025/07/22 12:31] (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>
@@ Line 310: / Line 340: @@
 #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
 </code>