Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- content:apache_phpfpm [2020/09/26 04:50] – [Manage Database with phpMyAdmin] Daniel
+++ content:apache_phpfpm [2021/06/24 11:35] – [Howto setup a LAMP-Server in 2018-2020] Daniel
@@ Zeile 1: / Zeile 1: @@
-====== Kleiner Serverguide ======
+====== Small Apache PHP- FPM- Serverguide ======
 ===== Howto setup a LAMP-Server in 2018-2020 =====
 This documentation is about how to set up a LAMP- Server (Linux, Apache, MySql, PhP) in the current, most stable way. The Reason for me writing this is, that default Installations of common Distruibutions are often based on an old way in Server- Configuration, which is not the way it could be done today, leading to instability and complex configuration.
+To get the Differences, this is how my Distro (OpenSuSE) delivers the Packages by default and which disadvanteages it has:
+  * 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 Apche- Server which is not released as stable and may crash the whole Apache- Server on Errors
+      * Using Network Connection to connect to
+  * MariaDB
+And here is what this guide will set up:
+  * Apache- Event. That way, Apache is one small Apache- Manager- Application which will spawn as many Apache- Servers as needed to handle the incoming connections dynamically. This is stable, as one Error may only crash the one Instance, which will be respawned by the Apache- Manager dynamically
+      * Connection to php is done by Proxy- Handling in Apache
+  * PHP-FPM will also Spawn PHP-Instances dynamically for each script beeing run
+      * Using Socket Connections to connect to
+  * MariaDB
 ==== Choosing Installation-Media & Install Basic System ====
-First, starting from Windows, you should make shure to have enough harddisk- space free. Then get a 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.0 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
+  - Download the DVD-Image from the Webpage as described there
   - Make the Installation- Media
   - Install the System with standard Desktop- Packages (KDE)
   - Boot into new Linux and Set Up Desktop as you like
 ==== Basic System- Scaling thoughts ====
@@ Zeile 40: / Zeile 58: @@
 Use "systemctl vm.swappiness = 0" and set it in /etc/sysctl.conf by adding line "vm.swappiness=0".
-==== Install 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:
@@ Zeile 56: / Zeile 74: @@
 Memory-Usage will be: innodb_buffer_pool_size + ( join_buffer_size + sort_buffer_size + readn_rnd_buffer_size ) * max_connections. If your System has more memory, use some tuning script (like MySQLTuner-perl) to see what makes most sense to put the memory to.
-For a local setup, you should use Sockets and disable networking. To do this, set <font inherit/monospace;;inherit;;#000000background-color:#ffffff;>"socket = /run/mysql/mysql.sock"</font> \\
+For a local setup, you should use Sockets and disable networking. To do this, set
+<code>
+socket = /run/mysql/mysql.sock
+</code>
 You should than deactivate TCP/IP with "skip-networking" and comment out the bind-address.
@@ Zeile 62: / Zeile 86: @@
 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>".
 ==== Install Apache ====
@@ Zeile 150: / Zeile 175: @@
 <code>
-listen = /var/run/php-fpm.sock
+listen = /run/php-fpm/php-fpm.sock
 listen.owner = wwwrun
 listen.group = www
@@ Zeile 163: / Zeile 188: @@
 </code>
 ==== PHP Configuration ====
@@ Zeile 270: / Zeile 296: @@
 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.
-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 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.
+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.
 Well: You are done. Now its up to you to fill Apache with content. Have fun!
 ==== Manage Database with phpMyAdmin ====
@@ Zeile 281: / Zeile 308: @@
-===== Mein erstes php- Softwareprojekt =====
+===== Installing Eclipse =====
+Get Eclipse with PDT here: [[https://www.eclipse.org/pdt/|https://www.eclipse.org/pdt/]]
+You may download the file, extract the contents (e.g. to ~/eclipse) and run the installer there in userspace (no superuser is required).
+===== Filling Content to your Server =====
+This is a demo to install some small Software to your Server. I will use the github- Project [[https://github.com/obel1x/ep3-bs.git|EP3-BS]] for testing.
+==== Install git-web ====
+This is a nice tool, to view your git-repositorys. Install it, and create a directory named /srv/git and make it writeable to users. Restart your webserver.
+You should already be able to go to [[http://localhost/git/|http://localhost/git/]] and see an empty project- Directory.
+==== Download some Project ====
+To get the git-project, open a terminal, change to /srv/git and execute "git clone [[https://github.com/obel1x/ep3-bs.git|https://github.com/obel1x/ep3-bs.git"]].
+You should already be set to open the project in eclipse. If you rightclick on the Project, you can add Composer-support to automate the installation of composer-modules while setup of ep3.
+Than create the Apache configuration to point to that directory:
+<code>
+Alias /ep3 "/srv/git/ep3-bs/public/"
+<Directory "/srv/git/ep3-bs/">
+require local
+Options FollowSymLinks
+AllowOverride All
+DirectoryIndex index.php
+</Directory>
+</code>
+After that, follow the instructions in [[https://github.com/tkrebs/ep3-bs/blob/master/data/docs/install.txt|https://github.com/tkrebs/ep3-bs/blob/master/data/docs/install.txt]]. Remember to use eclipse for installing composer-modules as written above!
+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.