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_rasberry [2024/02/08 19:04] – [Modify Nginx] systeminstall_rasberry [2024/02/08 19:07] (current) – [Disable strict mode] system
Line 83: Line 83:
 ===== Install MariaDB ===== ===== Install MariaDB =====
 ==== Why MariaDB? ==== ==== Why MariaDB? ====
-  * We discovered that the version of MySQL that comes bundled by default with Debian 12 (bookworm) are breaking things on RADIUSdesk. +  * We have  found that the version of MySQL that comes with Debian 12 (bookworm) by default causes problems with RADIUSdesk. 
-  * For this reason we install MariaDB as an alternative. +  * For this reason, we have installed MariaDB as an alternative. 
-  * MariaDB is an open-source relational database management system, commonly used as an alternative for MySQL as the database portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. +  * MariaDB is an open-source relational database management system that is often used as an alternative to MySQL as the database part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. 
-  * It is intended to be a drop-in replacement for MySQL. +  * It is intended as an immediate replacement for MySQL. 
-  * Be sure to supply a root password for the MariaDB database when asked for it if you are security conscious else simply hit the ESC key.+  * Be sure to provide a root password for the MariaDB database when prompted if you are security conscious, otherwise just hit the ESC key.
 <code bash> <code bash>
 sudo apt-get -y install mariadb-server php8.2-mysql sudo apt-get -y install mariadb-server php8.2-mysql
Line 95: Line 95:
 </code> </code>
 ==== Disable strict mode ==== ==== Disable strict mode ====
-  * With Debian 12 (bookworm), the bundled release of MariaDB is at version 15.1 which introduced a few Strict modes which have some problems with RADIUSdesk database implementation. +  * With Debian 12 (Bookworm), the bundled version of MariaDB is on version 15.1, which has introduced some strict modes that have some issues with the RADIUSdesk database implementation. 
-  * We will disable Strict SQL Mode in MariaDB by creating a new file /etc/mysql/conf.d/disable_strict_mode.cnf+  * We will disable the Strict SQL mode in MariaDB by creating a new file /etc/mysql/conf.d/disable_strict_mode.cnf
 <code bash> <code bash>
 sudo vi /etc/mysql/conf.d/disable_strict_mode.cnf sudo vi /etc/mysql/conf.d/disable_strict_mode.cnf
Line 105: Line 105:
 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 and restart the MySQL server
 <code bash> <code bash>
 sudo systemctl restart mariadb sudo systemctl restart mariadb
  • install_rasberry.1707411892.txt.gz
  • Last modified: 2024/02/08 19:04
  • by system