View source for Installing The LAMP Stack On A Server

LAMP Stack refers to the following software tools all running on the same server together:

L - Linux

A - Apache (replaceable with Nginx)

M - MySQL or MariaDB (replaceable with other database tools)

P - PHP or Python

For this page, Linux, Apache, MariaDB, and PHP will be used. 


== Prerequisites ==

Ensure that you have created, configured, and secured a remote server (at least at a basic level) and that all the software packages installed are up to date. A Wiki page to do so can be found [[Creating_And_Configuring_A_Remote_Server|here.]]

== Apache ==

=== Installing Apache ===
Install Apache using the command below:
 <nowiki>sudo dnf install httpd</nowiki>

Enable the Apache service, httpd.service, to start at boot:
 <nowiki>sudo systemctl start httpd.service</nowiki>
 <nowiki>sudo systemctl enable httpd.service</nowiki>

Check that the service has been started and is enabled:
 <nowiki>sudo systemctl status httpd.service</nowiki>


=== Configuring Apache ===
Before doing anything further, it is a good best practice to back up the Apache configuration file located at '/etc/httpd/conf/httpd.conf' by default and storing that default somewhere just to be safe:
 <nowiki>cp /etc/httpd/conf/httpd.conf /home/EXAMPLE_USER/httpd.conf.backup</nowiki>

Create an Apache config file, httpd-mpm.conf, using the template provided below. These are settings typical for use on a smaller cloud server running on something like Linode, DigitalOcean, AWS, or Azure:
 <nowiki>nano httpd-mpm.conf</nowiki>

Inside httpd-mpm.conf, place the following -- adjust as needed for use-case:
 <nowiki>KeepAlive Off

<IfModule prefork.c>
    StartServers        4
    MinSpareServers     20
    MaxSpareServers     40
    MaxClients          200
    MaxRequestsPerChild 4500
</IfModule></nowiki>

==== Configure Name-based Virtual Hosts ====
Create directories to store the files and logs for the site the server will be hosting:
 <nowiki>sudo mkdir -p /var/www/html/EXAMPLE/{public, logs}</nowiki>
This will create a 'public' and a 'logs' directory at once, replace EXAMPLE with the domain name of the server or the IP address of the server, whichever will be used.

Create directories for the virtual hosts files for the server, 'sites-available' and 'sites-enabled':
 <nowiki>sudo mkdir -p /etc/httpd/sites-available/</nowiki>
 <nowiki>sudo mkdir -p /etc/httpd/sites-enabled/</nowiki>

Tell Apache where to look for the 'sites-enabled' directory to find the virtual hosts by adding the below to the config file '/etc/httpd/conf/httpd.conf' that was copied earlier:
 <nowiki>sudo nano /etc/httpd/conf/httpd.conf</nowiki>
Append the below to 'httpd.conf' file:
 <nowiki>IncludeOptional sites-enabled/*.conf</nowiki> 

Now that Apache knows where to look, create a virtual hosts file for it to find, replacing EXAMPLE with the name of the domain or IP address of the server again:
 <nowiki>cd /var/www/html/EXAMPLE
sudo nano /etc/httpd/sites-available/EXAMPLE.conf</nowiki>

Add the below to the contents of that file:
 <nowiki><Directory /var/www/html/EXAMPLE/public_html>
    Require all granted
</Directory>
<VirtualHost *:80>
    ServerName EXAMPLE
    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html/EXAMPLE/public_html
    ErrorLog /var/www/html/EXAMPLE/logs/error.log
    CustomLog /var/www/html/EXAMPLE/logs/access.log combined
</VirtualHost></nowiki>

Create a symbolic (or soft) link between the 'sites-available' directory created earlier and the 'sites-enabled' directory created at the same time:
 <nowiki>sudo ln -s /etc/httpd/sites-available/EXAMPLE.conf /etc/httpd/sites-enabled/EXAMPLE.conf</nowiki>

Reload the Apache service for all the above changes to take effect:
 <nowiki>sudo systemctl restart httpd.service</nowiki>


=== Configuring Firewalld To Allow HTTP/HTTPS Traffic ===
Firewalld will be used for this page, but the same results can be achieved via different commands for UFW or any other firewall services available.

To view the active set of Firewalld rules/services for the public zone that will be used:
 <nowiki>sudo firewall-cmd --zone=public --list-services</nowiki>
If HTTP/HTTPS are already permitted, nothing further needs to be configured at this time within this section, if they are NOT already permitted proceed with this section.

To allow the HTTP/HTTPS traffic to the server so that connections can reach Apache, use the below:
 <nowiki>sudo firewall-cmd --zone=public --add-service=http --permanent
sudo firewall-cmd --zone=public --add-service=https --permanent
sudo firewall-cmd --zone=public --add-service=http
sudo firewall-cmd --zone=public --add-service=https

sudo firewall-cmd --reload</nowiki>

HTTP/HTTPS traffic needs to be permitted to both the Runtime and the Permanent rule sets for Firewalld so that the changes take effect on the current boot and remain persistent on future boots. Additional information for Firewalld can be found on this Wiki [[Firewalld#Configure_By_Service|here.]]

== MariaDB ==

=== Installation ===
To install the MariaDB packages:
 <nowiki>sudo dnf install mariadb-server</nowiki>

Start and enable the MariaDB service:
 <nowiki>sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service</nowiki>

Run the installation script for MariaDB:
 <nowiki>sudo mysql_secure_installation</nowiki>
This will run a script with prompts to determine the various MariaDB installation security options. These can be configured as desired, left as defaults, or can be configured with the suggestions below:
 <nowiki>Answer 'yes' to the following:
Change the root password for MariaDB
Remove Anonymous user accounts
Disable root logins outside of localhost
Remove test databases
Reload privileges</nowiki>


=== Creating A Database ===
With the MariaDB software installed, log into MariaDB using the root password configured above (if available):
 <nowiki>mysql -u root -p</nowiki>

Create a database for the server to use, replace DATABASE_NAME with the desired name:
 <nowiki>create database DATABASE_NAME;</nowiki>

Create a new user with permission to access this database, replacing USER_NAME and PASSWORD with desired selections:
 <nowiki>grant all on DATABASE_NAME.* to 'USER_NAME' identified by 'PASSWORD';</nowiki>

The database is now created, a user to access it created, and the created user has permissions to use it.

== PHP ==


=== Installation ===
To install PHP and needed modules:
 <nowiki>sudo dnf install php php-pear php-mysqlnd</nowiki>


=== Configuration ===
Edit the below file for better error messages and logs:
 <nowiki>sudo nano /etc/php.ini</nowiki>

By appending/editing the '/etc/php.ini' file with the following:
 <nowiki>error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR
error_log = /var/log/php/error.log
max_input_time = 30</nowiki>

Create the directories for the log files specified in the '/etc/php.ini' file:
 <nowiki>sudo mkdir /var/log/php</nowiki>

Grant the Apache user and group permission to read/write those files:
 <nowiki>sudo chown apache:apache /var/log/php</nowiki>

PHP should now be installed so Apache will need to be restarted for the changes to take effect:
 <nowiki>sudo systemctl restart httpd.service</nowiki>