How to Install a LAMP Stack on Ubuntu 18.04

04 Mar

How to Install a LAMP Stack on Ubuntu 18.04

What is a LAMP Stack?

A LAMP (Linux, Apache, MySQL, PHP) stack is a common, free, and open-source web stack used for hosting web content in a Linux environment. Many consider it the platform of choice on which to develop and deploy high-performance web apps.

Before You Begin

Update your system:
```
sudo apt update && sudo apt upgrade
```

Install Using Tasksel

Instead of installing Apache, MySQL, and PHP separately, Tasksel offers a convenient way to get a LAMP stack running quickly.

Install Tasksel if not already installed by default:
```
sudo apt install tasksel
```
Use Tasksel to install the LAMP stack:
```
sudo tasksel install lamp-server
```

Install Packages Separately

If you prefer not to install the bundled packages via Tasksel, you can instead install them separately:

Install Apache 2.4 from the Ubuntu repository:
```
sudo apt install apache2
```
Install the mysql-server package:
```
sudo apt install mysql-server
```
Install PHP, the PHP Extension and Application Repository, Apache support, and MySQL support:
```
sudo apt install php7.2 libapache2-mod-php7.2 php-mysql
```
Optionally, install additional cURL, JSON, and CGI support:
```
sudo apt install php-curl php-json php-cgi
```

Configuration

Apache

The KeepAlive setting allows Apache to better utilize server-side memory, reducing latency for users on the hosted site. KeepAlive makes a website faster if the host has enough memory to support it. This is done by allowing Apache to reuse connections, instead of opening a new connection for every request.Open the apache2.conf Apache config file and adjust the KeepAlive setting:
/etc/apache2/apache2.conf
1 2 3

KeepAlive On MaxKeepAliveRequests 50 KeepAliveTimeout 5
Note

The MaxKeepAliveRequests setting controls the maximum number of requests during a persistent connection. 50 is a conservative amount; you may need to set this number higher depending on your use-case. The KeepAliveTimeout setting controls how long the server waits (measured in seconds) for new requests from already connected clients. Setting this to 5 will avoid wasting RAM.

The default multi-processing module (MPM) is the prefork module. mpm_prefork is the module that is compatible with most systems. Open the mpm_prefork.conf file located in /etc/apache2/mods-available and edit the configuration.

/etc/apache2/mods-available/mpm_prefork.conf

1
2
3
4
5
6
7


<IfModule mpm_prefork_module>
        StartServers            4
        MinSpareServers         3
        MaxSpareServers         40
        MaxRequestWorkers       200
        MaxConnectionsPerChild  10000
</IfModule>

Enable the firewall to allow web traffic. This guide lists the commands to enable web traffic if you configured UFW on your server.a. Check the ports that are enabled for Apache Full Profile:
```
sudo ufw app info "Apache Full"
```
Ports 80 and 443 should be listed as enabled for Apache Full profile.

b. To allow incoming HTTP and HTTPS traffic for Apache Full profile:
```
sudo ufw allow in "Apache Full"
```

Disable the event module and enable prefork:

sudo a2dismod mpm_event
sudo a2enmod mpm_prefork

Restart Apache:
```
sudo systemctl restart apache2
```

Virtual Hosts

You can set up virtual hosts several ways, and the following steps outline the recommended method. For each of these steps, replace example.com with your domain name.

Create a copy of the default Apache configuration file for your site:

sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/example.com.conf

Open the new example.com configuration file in your text editor. Uncomment the ServerName option and update it with your domain. Enter the document root path and log directories as shown below, and add a Directory block before <VirtualHost>:

/etc/apache2/sites-available/example.com.conf

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13


<Directory /var/www/html/example.com/public_html>
        Require all granted
</Directory>
<VirtualHost *:80>
        ServerName example.com
        ServerAlias www.example.com
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html/example.com/public_html

        ErrorLog /var/www/html/example.com/logs/error.log
        CustomLog /var/www/html/example.com/logs/access.log combined

</VirtualHost>

Note
The file example above has all comment sections removed for brevity. Keep or remove the commented areas as you see fit.
The ServerAlias directive allows you to include multiple domain names or subdomains for a single host. The example above allows visitors to use example.com or www.example.com to navigate to this virtual host.

Create the directories referenced above:
```
sudo mkdir -p /var/www/html/example.com/{public_html,logs}
```
Note

Make sure that you do not put a space after the comma between public_html and logs because it will create a folder named {public_html, and will cause an error when you will reload Apache.
Assign ownership of public_html directory to the $USER environment variable:
```
sudo chown -R $USER:$USER /var/www/html/example.com/public_html
```

Set the permissions for the public_html directory:

sudo chmod -R 755 /var/www/html/example.com/public_html

Link your virtual host file from the sites-available directory to the sites-enabled directory:
```
sudo a2ensite example.com
```
Note

To disable your website, run a2dissite example.com.
Disable the default virtual host to minimize security risks:
```
sudo a2dissite 000-default.conf
```
Reload Apache:
```
sudo systemctl reload apache2
```

Virtual hosting should now be enabled. To allow the virtual host to use your domain name, be sure that you have configured DNS services for your domain to point to your Linode’s IP address.

If there are additional websites you wish to host on your Linode, repeat the above steps to add a folder and configuration file for each.

MySQL

Log in to MySQL’s SQL shell:
```
sudo mysql -u root
```
About MySQL authentication
By default, MySQL is configured to use the auth_socket authorization plugin. This authorization scheme allows you to log in to the database’s root user as long as you are connecting from the Linux root user on localhost, or as a user with sudo privileges (i.e. with sudo mysql -u root). In this scheme, no password is assigned to MySQL’s root user:
mysql> SELECT user,host,authentication_string,plugin FROM mysql.user WHERE user='root'; +------+-----------+-----------------------+-------------+ | user | host | authentication_string | plugin | +------+-----------+-----------------------+-------------+ | root | localhost | | auth_socket | +------+-----------+-----------------------+-------------+ 1 row in set (0.02 sec)
You can keep using the auth_socket plugin, and this is considered a secure option for production systems. If you’d rather switch to password authentication and assign a password, enter the following commands. Replace password with a new root password:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'password'; mysql> FLUSH PRIVILEGES;
After making this change, you should pass the -p option when invoking the MySQL shell:
```
mysql -u root -p
```
Create a database and a user with permissions for it. In this example, the database is called webdata, the user webuser, and password password. Be sure to enter your own password. This should be different from the root password for MySQL:
```
CREATE DATABASE webdata;
GRANT ALL ON webdata.* TO 'webuser' IDENTIFIED BY 'password';
```
Exit the SQL shell:
```
quit
```
Use the mysql_secure_installation tool to configure additional security options. This tool will ask if you want to set a new password for the MySQL root user, but you can skip that step:
```
sudo mysql_secure_installation
```
Answer Y at the following prompts:
- Remove anonymous users?
- Disallow root login remotely?
- Remove test database and access to it?
- Reload privilege tables now?

PHP

Edit the configuration file located in /etc/php/7.2/apache2/php.ini to enable more descriptive errors, logging, and better performance. The following modifications provide a good starting point:
/etc/php/7.2/apache2/php.ini
1 2 3

error_reporting = E_COMPILE_ERROR | E_RECOVERABLE_ERROR | E_ERROR | E_CORE_ERROR max_input_time = 30 error_log = /var/log/php/error.log
Note

The beginning of the php.ini file contains examples commented out with a semicolon (;), which disables these directives. Ensure that the lines you modify in this step follow the examples section and are uncommented.
Create the log directory for PHP and give ownership to the Apache system user:
```
sudo mkdir /var/log/php
sudo chown www-data /var/log/php
```
Restart Apache:
```
sudo systemctl restart apache2
```
Note

If you plan on using your LAMP stack to host a WordPress server, install additional PHP modules: sudo apt install php-curl php-gd php-mbstring php-xml php-xmlrpc

Optional: Test and Troubleshoot the LAMP Stack

In this section, you’ll create a test page that shows whether Apache can render PHP and connect to the MySQL database. This can be helpful in locating the source of an error if one of the elements of your LAMP stack is not communicating with the others.

Paste the following code into a new file, phptest.php, in the public_html directory. Modify webuser and password to match the information entered in the Create a MySQL Database section above:

/var/www/html/example.com/public_html/phptest.php

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24


<html>
<head>
    <title>PHP Test</title>
</head>
    <body>
    <?php echo '<p>Hello World</p>';

    // In the variables section below, replace user and password with your own MySQL credentials as created on your server
    $servername = "localhost";
    $username = "webuser";
    $password = "password";

    // Create MySQL connection
    $conn = mysqli_connect($servername, $username, $password);

    // Check connection - if it fails, output will include the error message
    if (!$conn) {
        die('<p>Connection failed: </p>' . mysqli_connect_error());
    }
    echo '<p>Connected successfully</p>';
    ?>
</body>
</html>

Navigate to example.com/phptest.php from your local machine. If the components of your LAMP stack are working correctly, the browser will display a “Connected successfully” message. If not, the output will be an error message.

Remove the test file:

sudo rm /var/www/html/example.com/public_html/phptest.php

Troubleshooting

If the site does not load at all, check if Apache is running, and restart it if required:
```
sudo systemctl status apache2
sudo systemctl restart apache2
```
If the site loads, but the page returned is the default “Congratulations” page, return to the Configure Virtual Hosts section above and check that the DocumentRoot matches your example.com/public_html folder.
If the page returned says “Index of /” or has a similar folder tree structure, create a test index.html file or a test file as shown above.

How to install MariaDB 10.3 on Ubuntu 18.04 and CentOS 7

How to install NextCloud 18 on Ubuntu 16.04/18.04/19.04/19.10

How to Enable Apache Mod_Rewrite on Ubuntu

Tags:

Apache2,Linux,MySQL,PHP,sys admin