Differences

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

Link to this comparison view

Both sides previous revision Previous revision
install_rasberry [2024/02/08 19:06] – [Why MariaDB?] systeminstall_rasberry [2024/02/08 19:07] (current) – [Disable strict mode] system
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.1707412003.txt.gz
  • Last modified: 2024/02/08 19:06
  • by system