Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- content:apache_phpfpm [2022/03/02 18:39] – [Tell Apache to use php-fpm] Daniel
+++ content:apache_phpfpm [2025/02/19 14:30] (aktuell) – [LAMPf: Linux / Apache / MariaDB / PHP- FPM- Serverguide] Daniel
@@ Zeile 1: / Zeile 1: @@
-====== Apache PHP- FPM- Serverguide ======
+====== LAMPf: Linux / Apache / MariaDB / PHP- FPM- Serverguide ======
-===== Howto setup a LAMP-Server in 2018-2020 =====
+Note: The here explained way of setting up a webserver is very performant plus very slim and basic and may be a very good way if your machine is old and/or your ressources are low and you want to deliver solid, fast and small services based on native distribution- liked builds. But it needs some manual maintanance and a well working, full featured Linux- Distribution, delivering all those Services (Apache, php, fpm, mariadb) as binary build packages. As complexity raises and more services are build up on that server, you may run into high maintainance loads and the need to spend a lot of time to configure more and more services always having the complexity in mind.
+For example: if you want to make those Services available on the internet, you should definitively want to make webservices SSL- secured. Getting automatic SSL- Certificates and renew them in a good way, will work if you know how to set it up, but the setup is just another thing to care about.
+So nowadays there are solutions to make complexity for that more handy which would be e.g. using Docker or Podman - which would be another, very different approach for large system, delivering a full, extremly powerful service- infrastructure in a pre- build way (it also delivers apache with php-fpm and automatic ssl-acme-challanges out of the box in many packages!).
+So if you plan to set up a new fully flagged Server which will have many needed services, don't use this setup. Just after installation go straight into installing and setting up e.g. Docker and go on and use it for all services you can find there.
+You can find the new way how to setup a server here: [[.:serverbasics|SoHO Serverbasics]]
+So this for me is deprecated as i bought a new server here. I won't spend any time here. If you wann know more about nowadays setups, feel free and write a mail to me, maybe i will deliver docs to this than. HF and GL obel1x
+===== Howto setup a LAMP-Server in 2018 - 2020+ =====
 This documentation is about how to set up a LAMP- Server (Linux, Apache, MySql aka MariaDB, PhP) in the current, most stable way for home office usage. The reason for me writing this is, that default Installations of common Distruibutions are often based on an old styled configuration, which is not the way it could be done today, leading to instability and complex configuration and dependencies that make it hard to update components individually.
@@ Zeile 8: / Zeile 21: @@
   * Apache-Prefork. That way, Apache is one Application with many threads - which is slower, consumes more memory and doesn't scale good
-  * PHP-Module integrated in the Apache- Server which is not released as stable and may crash the whole Apache- Server on Errors. This module must be released to match the Apache- version, so the versions are tied together
+  * PHP-Module (mod_php) loaded as Module in the Apache- Server which is not released as stable and may crash the whole Apache- Server on Errors. This module must be compiled to match the Apache- Version, so upgrading Apache means upgrading mod_php
   * PHP- Modules, which must be compiled againt the apache-mod_php- module. Updating mod_php means updating all modules.
       * Using Network Connections with overhead to connect to
@@ Zeile 20: / Zeile 33: @@
       * Using Socket Connections to connect to
   * MariaDB
 ==== Choosing Installation-Media & Install Basic System ====
-First, starting from Windows, you should make sure to have enough harddisk- space free (i recommend at least 60 GB). Then get the installation-medium of the Linux your choice. I will stick to OpenSuSE as to get from [[https://software.opensuse.org/distributions|OpenSuSE]] (use Leap 15.1 currently as stable Distro. Tumbleweed may be instable). Follow the instructions to
+First, starting from Windows, you should make sure to have enough harddisk space free (i recommend at least 60 GB). Then get the installation-medium of the Linux your choice. I will stick to OpenSuSE as to get from [[https://software.opensuse.org/distributions|OpenSuSE]] (use Leap 15.1 currently as stable Distro. Tumbleweed may be instable). Follow the instructions to
   - Download the DVD-Image from the Webpage as described there
-  - Make the Installation- Media
+  - Create the Installation- Media
   - Install the System with standard Desktop- Packages (KDE)
   - Boot into new Linux and Set Up Desktop as you like
@@ Zeile 33: / Zeile 45: @@
 ==== Basic System- Scaling thoughts ====
-The most important thing to consider when making performant LAMP is to **not overextend memory-usage**  of your System. That means, that the amount of memory used by all Applications, should normally never exeed the system-memory space. If the settings are too high for your setup, the system will start to swap o lot of data, not working fast enough any more. As basic thumb-based Values, you need: 1 GByte Memory for Linux- Base- System 1 GByte Memory if you plan to have the graphical Desktop running (you can run that server in Textmode, which will not consume Memory) 1 GByte free (this will be used by System for filecache)
+The most important thing to consider when making performant LAMP is to **not overextend memory-usage**  of your System. That means, that the amount of memory used by all Applications, should normally never exeed the system-memory space. If the settings are too high for your setup, the system will start to swap o lot of data, not working fast enough any more. As basic thumb-based Values, you need: **1 GByte Memory for linux Base- System and additionally 1 GByte Memory if you plan to have the graphical Desktop running**  (you can run that server in Textmode, which will not consume Memory) **+ at least 1 GByte free**  (this will be used by System for filecache)
 The remaining Memory should be Split around this Values:
@@ Zeile 57: / Zeile 69: @@
 Use "systemctl vm.swappiness = 0" and set it in /etc/sysctl.conf by adding line "vm.swappiness=0".
-==== Install MAriaDB (MySql) ====
+==== Install MariaDB (MySql) ====
-In OpenSuSE MariaDB is available and working out of the Box (maybe change the Admin- Password at first Start). MySQL is tuneable in /etc/my.cnf:
+In OpenSuSE MariaDB is available and working out of the Box. Check with:
+<code>
+sudo zypper install mariadb
+</code>
-You should check the Parameters align with the memory of your machine (see above): Settings for 4 GB Memory (at all), are:
+MySQL is tuneable in /etc/my.cnf. You should check the Parameters align with the memory of your machine (see above): Settings for 4 GB Memory (at all), are:
   * innodb_buffer_pool_size = 768M
@@ Zeile 74: / Zeile 91: @@
 For a local setup, you should use Sockets and disable networking. To do this, set
-<code>
+<code>
 socket = /run/mysql/mysql.sock
@@ Zeile 82: / Zeile 99: @@
 You should than deactivate TCP/IP with "skip-networking" and comment out the bind-address.
-Start Mysql with "rcmysqld start" at the command line as root, it should work now.
+Start Mysql with
+<code>
+systemctl start mariadb
+</code>
+at the command line as root, it should work now.
-After that had worked you should secure your Database by giving a password as it was explained by the step above when starting it. If not shure just run " <font inherit/monospace;;inherit;;#000000background-color:#ffffff;>/usr/bin/mysql_secure_installation</font> ".
+To setup passwords, run /usr/bin/mysql_secure_installation as root on the system.
 ==== Install Apache ====
@@ Zeile 95: / Zeile 119: @@
   * Open the Software Store
-  * Install apache-event
+  * Install apache2-event
-  * Remove apache-prefork
+  * Remove apache2-prefork (if installed)
   * Commit the Changes
   * in /etc/apache2/server-tuning.conf the module will be configured. Event and Worker is nearby the same. I use the following parameters for the event/worker module:
@@ Zeile 124: / Zeile 148: @@
 I would suggest to remove any mpm-specific configurations and use only those settings. You can leave the other settings as defined by initial setup.
+After that, open yast and go to sysconfig- editor. Search for APACHE_MPM and select event.
+Test running apache with
+<code>
+systemctl start apache2.service
+systemctl status apache2.service
+● apache2.service - The Apache Webserver
+    Loaded: loaded (/usr/lib/systemd/system/apache2.service; disabled; vendor preset: disabled)
+    Active: active (running) since Tue 2022-11-22 19:43:17 CET; 1s ag
+</code>
+If thats fine, please stop apache once again to configure php-fpm first.
 ==== Install PhP-FPM ====
@@ Zeile 134: / Zeile 174: @@
 <code>
-sudo zypper remove apache2-mod_php7
+sudo zypper remove apache2-mod_php8
-sudo a2dismod php7
+sudo a2dismod php8
 </code>
@@ Zeile 143: / Zeile 183: @@
 <code>
-sudo zypper install php7-fpm
+sudo zypper install php8-fpm
 </code>
@@ Zeile 150: / Zeile 190: @@
 <code>
-sudo cp /etc/php7/fpm/php-fpm.conf.default /etc/php7/fpm/php-fpm.conf
+sudo cp /etc/php8/fpm/php-fpm.conf.default /etc/php8/fpm/php-fpm.conf
-sudo cp /etc/php7/fpm/php-fpm.d/www.conf.default /etc/php7/fpm/php-fpm.d/www.conf
+sudo cp /etc/php8/fpm/php-fpm.d/www.conf.default /etc/php8/fpm/php-fpm.d/www.conf
 </code>
-  * Than go to /etc/php7/fpm and briefly check if php-fpm.conf is ok for you
+  * Than go to /etc/php8/fpm and briefly check if php-fpm.conf is ok for you
   * Explanation: In php-fpm.d directory you need to set up at least one pool. This is one Instance for Apache to speak to.
@@ Zeile 170: / Zeile 210: @@
 Whenever you can - you should use unix sockets instead of TCP/IP, because of less overhead. If you are on the same machine (apache and php-fpm), than you can.
-So this here is new for the setup: in "/etc/php7/fpm/php-fpm.d/www.conf" set
+So this here is new for the setup: in "/etc/php8/fpm/php-fpm.d/www.conf" set
 <code>
@@ Zeile 189: / Zeile 229: @@
 ==== PHP Configuration ====
-I do not recommend using php.ini in /etc/php7/fpm, but to put it in /etc/php7/conf.d With that Setup, the whole php-configuration will be the same for cli- and web(f)cgi- php execution. Check to move all php.ini files to conf.d. After that, go through the ini-files in conf.d an see if they fit your needs. Especially each Parameter should only be defined once.
+I do not recommend using php.ini in /etc/php8/fpm, but to put it in /etc/php8/conf.d With that Setup, the whole php-configuration will be the same for cli- and web(f)cgi- php execution. Check to move all php.ini files to conf.d. After that, go through the ini-files in conf.d an see if they fit your needs. Especially each Parameter should only be defined once.
 After that, start php-fpm:
@@ Zeile 203: / Zeile 243: @@
 ==== About PHP- Modules ====
-many modules for PHP are offered in the Distrubution. I **would not recommend using those**  - as all php-modules need to be compiled against your php. If you update PHP and your modules are the same, they may brake your PHP!
+many modules for PHP are offered in the Distrubution. I **would not recommend using those**  - as all php-modules need to be compiled against your php. If you update PHP and your modules are not copiled to that version, they may brake your PHP!
 Better use pearl / pecl and install modules with it! Here, i have found no other way, than to search for php-pear and php-pecl in the distribution and use them.
-For me, i needed: php-pear, php-pecl, php7-devel (for command phpize)
+For me, i needed: php8-pear, php8-pecl, php8-devel (for command phpize)
 Which can be found in the Repo: [[https://build.opensuse.org/project/show/devel:languages:php|https://build.opensuse.org/project/show/devel:languages:php]]
-After that, modules can be installed by e.g. "pecl install imagick". They also need to be loaded in php.conf. I would make an new config named /etc/php7/conf.d/pear_pecl.ini and include they modules there. E.g. "extension=imagick.so"
+After that, modules can be installed by e.g. "pecl install imagick". They also need to be loaded in php.conf. I would make an new config named e.g. /etc/php8/conf.d/pear_pecl.ini and include the modules there. E.g. "extension=imagick.so"
+To make pecl/paer alter the ini automagically, use e.g.
+<code>
+pear config-set php_ini /etc/php8/conf.d/pear_pecl.ini
+pecl config-set php_ini /etc/php8/conf.d/pear_pecl.ini
+</code>
 Restart php-fpm for the changes and check the log of php-fpm (usually in /var/log/php-fpm.log) for errors when loading modules.
@@ Zeile 219: / Zeile 267: @@
 For making Apache use php-fpm as php-server, you use the module "proxy_fcgi", which should be included in the apache MPM- Package.
-Caution: this has noting to do with "mod_fcgi"! You will not need mod_fcgi, as this would manage php itself in a new server, which we dont' want! "proxy_fcgi" offers the fcgi- interface and tunnels it to php-fpm. Thus, it will be a small wrapper, not having to manage something as big as php.
+Caution: this has noting to do with "mod_fcgi" or "fastcgi"! You will not need those, as this would execute php itself in the webserver, which we dont' want! "proxy_fcgi" offers the fcgi- interface and tunnels it to php-fpm via socket or ip-interface. Thus, it will be a small wrapper, not having to manage something as big as php.
   * To enable this and all its dependencies, use
@@ Zeile 239: / Zeile 287: @@
 # This is to forward all PHP to php-fpm
 <FilesMatch \.php$>
-  SetHandler "proxy:unix:/var/run/php-fpm/php-fpm.sock|fcgi://localhost/"
+  SetHandler "proxy:unix:/run/php-fpm/php-fpm.sock|fcgi://localhost:9000"
 </FilesMatch>
 DirectoryIndex index.php
@@ Zeile 259: / Zeile 307: @@
 </code>
 ==== Start and check Apache ====
@@ Zeile 297: / Zeile 344: @@
 This should give you the complete Info of your php-configuration. If something fails, check if the above services are started an/or the logfiles.
+If you get Permission denied even if your file is world- readable and the user wwwrun can access the content, in Leap 15.4 there are strict permissions in AppArmor. So check Yast / AppArmor and Check the Protocols. You will most likely find entries that needs to be changed (affects also: executing programs with proc_open() in php). After that, Access should work.
 In Production, you should not run a plain http-server, but switch to SSL. Therefore, you can get ssl-certificates from let's encrypt and follow the instructions there to switch to ssl. You need some internet Name like [[http://www.myname.com|www.myname.com]] registered for your server to get this (e.g. via Dyndns). The process to make your server visible is something to be explained a bit more, but thats basically what you need to do (official internet-name/DNS- entry and ssl-encryption). as long as you don't want to make the server world-reachable and use it nly fr testing, your are also fine without DNS and SSL, but you should make sure, that your firewall blocks http(80) and https(443)-ports.
@@ Zeile 304: / Zeile 353: @@
 ==== Manage Database with phpMyAdmin ====
-To manage your local Database, it would be nice to have phpMyAdmin installed first (via Package-manager). After that, copy the config.sample.inc.php to config.inc.php under /srv/www/htdocs/phpMyAdmin to use the socket <font inherit/monospace;;inherit;;#000000background-color:#ffffff;>/run/mysql/mysql.sock</font>  you specified before for mysql.
+To manage your local Database, it would be nice to have phpMyAdmin installed first (via Package-manager). After that, copy the config.sample.inc.php to config.inc.php under /srv/www/htdocs/phpMyAdmin to use the socket /run/mysql/mysql.sock you specified before for mysql.
 You can finish the setup of your phpMyAdmin by visiting [[http://localhost/phpMyAdmin/index.php|http://localhost/phpMyAdmin/index.php]]
+Hint: phpMyAdmin in Opensuse seems to be reduced in functionality. For example generating config.inc.php with [[http://localhost/phpMyAdmin/setup/|http://localhost/phpMyAdmin/setup/]] will not work. I would recommend to delete contents of /usr/share/phpMyAdmin/ and download a full version here: [[https://www.phpmyadmin.net/downloads/|https://www.phpmyadmin.net/downloads/]]
+==== About security of your WEB- Page (Scripts) ====
+There are really a lot of important Documentations about security of your Webserver going in Details for each functionality. They are important - as functions should be set as tight as possible.
+But there are more basic security settings that may prevent damage if the functional security is breached. So the basic security might be very important - and here especially the file permissions. One big security-hole that is very common misunderstand at permissions is this one:
+**If you make a file ONLY readable for the user of the webserver (400) and make that user own that file, you may expect this user to not be able to write to that file. THIS IS WRONG !**
+Instead, in Linux/Unix the user owning a file can ALWAYs change its permissions. So the user will be able to make it writeable again and write to that file. The ONLY way to prevent the webservers- user form writing to files is not to make this user own that file. So you should make your file owned by root and use groups for controlling the access.
+If you need more detailled file permissions, you may have a look at file acls, which are very powerful and can solve permission- restrictions tha ugo may cause.
 ===== Installing Eclipse =====
@@ Zeile 347: / Zeile 410: @@
 As Database you can create a new user (e.g. named ep3) with corresponid database and fill the configuration to fit.
-After that, your testinstallation should work already.
+==== Using Eclipse to work on that Project ====
+In Eclipse now add a project and use GIT smart import from that directory location - it should configure git and eclipse + php the right way and you should be ready to go programming!
+==== Setup Debugging of PHP ====
+To setup Debugging of code, install xdebug for php via pecl:
+<code>
+pecl install xdebug
+</code>
+Now, also add
+<file>
+xdebug.mode=debug
+</file>
+Now restart php-fpm and check the php_info() if xdebug is enabled and if Step debugging is active. Otherwise check logs.
+Adjusting timeouts in apache fcgi: Add Timeouts to /etc/apache2/conf.d/mod_proxy_fcgi.conf of apache:
+<code>
+...
+ Timeout 600
+ ProxyTimeout 600
+...
+</code>
+And of course restart apache2.
+==== Setup of Eclipse ====
+You need to add the PHP- Environement and the Debugger in Eclipse.
+{{.:apache_phpfpm_20221123-104346.png}}
+and
+{{.:apache_phpfpm_20221123-104629.png}}
+Mind to use the Port phpinfo tells you. Thats it start debugging with e.g. index.php of the project:
+{{.:apache_phpfpm_20221123-105037.png}}
+That should fire up the Browser, connect php in debugging to eclipse and break at the first line.
+You can walk through the code with F5 (dive into), F6 (step over) or just let the work go on with F8.
+You are done setting up webserver, php-fpm, mariadb and eclipse plus your new git- repository. hafe fun!