Server setup guide

Introduction

This is my personal guide to se tup an Ubuntu server. To build this guide I've used the knowledge available on the internet and the sources are, as much as possible, linked on this guide.

I will be updating this guide as my knowledge and experience evolves. I will be glad to take advice, suggestions and/orpull requests.

Table of Contents

1. Initial Setup
   1. Deploy the server
   2. System update
   3. Create a non root user
   4. Setup SSH key-based login
   5. Test the user SSH keys login and secure it
   6. Setup the firewall
   7. Git
   8. Bash prompt customization
   9. Additional folders in the home folder
2. Software installation
   1. Apache Server installation
      1. Install Apache
      2. Set up the firewall
      3. Check the Apache Server
      4. Change the Apache Server web root folder
      5. Set up the default directory to be served by Apache Web Server
      6. Set permissions for the Apache Server root folder
      7. Keep the Apache Server root folder access permissions consistent with a cron job
      8. Install & Configure ModSecurity
   2. MySQL Server installation
      1. Install MySQL
      2. Configure MySQL
      3. Move MySQL data folder
   3. PHP installation
      1. Install PHP
      2. Install PHP extensions
      3. Install FastCGI Process Manager (FPM)
      4. PHP configuration improvements
   4. Docker installation
      1. Install Docker
   5. linkding installation
      1. Install linkding
      2. Reverse Proxy Setup
      3. Create and set an SSL Certificate
      4. www to non-www redirection
   6. traggo installation
      1. Install traggo
      2. Reverse Proxy Setup
      3. Create and set an SSL Certificate
      4. www to non-www redirection
3. Server Management
   1. Apache Server Management
      1. Apache | Create a Virtual Host
      2. Apache | Secure Apache with Let's Encrypt
      3. Apache | www to non-www redirection
   2. MySQL Server Management
      1. MySQL | Create a MySQL database
      2. MySQL | Create a MySQL user
      3. MySQL | Grant privileges to a MySQL user
      4. MySQL | Import a database from a file to a MySQL database
4. Linux Upskill Challenge | Resources & Extensions
   1. Day 1 | Get to know your server