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:01] – [Configure Nginx to interpret .php files] systeminstall_rasberry [2024/02/08 19:07] (current) – [Disable strict mode] system
Line 33: Line 33:
 </code> </code>
 ===== Modify Nginx ===== ===== Modify Nginx =====
-  * Now that the php-fpm service is installed we should change the default **Nginx** server to make use of it.+  * Now that the php-fpm service is installed, let us change the default nginx server to use it.
   * Edit the default server file:   * Edit the default server file:
 <code bash> <code bash>
Line 43: Line 43:
 index index.php index.html index.htm index.nginx-debian.html; index index.php index.html index.htm index.nginx-debian.html;
 </code> </code>
-  * Activate PHP processing by un-commenting this this section. Note that we use the UNIX socket and we are using **8.2** and not **7.4** which is specified originally in the config file.+  * Enable PHP processing by leaving this section uncommented. Note that we are using the UNIX socket and that we are using 8.2 and not 7.4 as originally specified in the configuration file.
 <code bash> <code bash>
 # pass PHP scripts to FastCGI server # pass PHP scripts to FastCGI server
Line 56: Line 56:
 } }
 </code> </code>
-  * Enable the hiding of .htaccess files+  * Activate the hiding of .htaccess files
 <code bash> <code bash>
 # deny access to .htaccess files, if Apache's document root # deny access to .htaccess files, if Apache's document root
Line 65: Line 65:
 } }
 </code> </code>
-  * Reload the **Nginx** web server's configuration+  * Reload the configuration of the Nginx web server 
 <code bash> <code bash>
 sudo systemctl reload nginx.service sudo systemctl reload nginx.service
Line 79: Line 79:
 ?> ?>
 </code> </code>
-  * Navigate to http://127.0.0.1/test.php and see if the page display the PHP info.+  * Navigate to http://127.0.0.1/test.php and check that the page displays the PHP information.
  
 ===== 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.1707411701.txt.gz
  • Last modified: 2024/02/08 19:01
  • by system