Skip to content

Latest commit

Β 

History

History
1188 lines (935 loc) Β· 53.7 KB

ARCHIDEP.md

File metadata and controls

1188 lines (935 loc) Β· 53.7 KB

Deploy Flood It, a Spring Boot (Java) & Angular (JavaScript) application with a PostgreSQL database

The goal of this exercice is to put in practice the knowledge acquired during previous exercices to deploy a new application from scratch on your server.

The goal

You must deploy the provided application in a similar way as the PHP todolist in previous exercises:

  • Install the language(s) and database necessary to run the application (which are different than for the PHP todolist).
  • Run the application as a systemd service.
  • Serve the application through nginx acting as a reverse proxy.
  • Provision a TLS certificate for the application and configure nginx to use it.
  • Set up an automated deployment via Git hooks for this application.

Additionally:

  • The application MUST run in production mode (see its documentation).
  • The application MUST restart automatically if your server is rebooted (i.e. your systemd service must be enabled).
  • The application MUST be accessible only through nginx. It MUST NOT be exposed directly on a publicly accessible port. In the cloud servers used in this course, ports 3000 and 3001 should be open for testing. DO NOT use these ports in the final setup.
  • Clients accessing the application over HTTP MUST be redirected to HTTPS.

As an optional bonus challenge:

  • Create a dedicated Unix user (e.g. floodit) other than your personal user (e.g. john_doe) to run the application.
  • This user must be a system user, not a login user. It must not be able to log in with a password, although you can set up SSH public key authentication for the automated deployment.
  • Clone the project's repository with the dedicated user instead of your personal user.
  • Configure systemd to run the application as the dedicated user instead of your personal user.
  • Set up the automated deployment with the dedicated user instead of your personal user.
  • Use the application's local configuration file instead of environment variables (see its documentation), and set up file/directory permissions so that only the dedicated user has access to the configuration file (the root user will of course have access as well).

Legend

Parts of this guide are annotated with the following icons:

  • ❗ A task you MUST perform to complete the exercise.
  • ❓ An optional step that you may perform to make sure that everything is working correctly. But you can skip it because it is not necessary.
  • ⚠️ Critically important information about the exercise.
  • πŸ’Ž Tips on the exercise, reminders about previous exercises, or explanations about how this exercise differs from the previous one.
  • πŸ‘Ύ More advanced tips on how to save some time, or tips about the bonus challenge.
  • πŸ“š Additional information that you can read if you want to know more about the commands and tools used during this exercise.
  • 🏁 The end of the exercise.
    • πŸ›οΈ The architecture of what you deployed during the exercise.
  • πŸ’₯ Troubleshooting tips: how to fix common problems you might encounter.

The application

The application you must deploy is a small web game. Its code is available on GitHub.

It has two components: a backend and a frontend:

πŸ“š What the hell are Spring Boot, Angular & PostgreSQL?

The application uses the following buzzword salad technologies:

  • The backend has been developed with Spring Boot, a Java framework that makes it easy to create stand-alone, production-grade Spring based Applications that you can "just run".

    • Java is a popular programming language and development platform. It reduces costs, shortens development timeframes, drives innovation, and improves application services. With millions of developers running more than 60 billion Java Virtual Machines worldwide, Java continues to be the development platform of choice for enterprises and developers.
    • Spring makes programming Java quicker, easier, and safer for everybody. Spring's focus on speed, simplicity, and productivity has made it the world's most popular Java framework.
  • The frontend has been developed with Angular, a JavaScript application-design framework and development platform for creating efficient and sophisticated single-page apps. It also uses Tailwind, a utility-first CSS framework packed with classes that can be composed to build any design, directly in your markup.

  • PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

You do not need to know the specifics of these technologies. Your goal is only to deploy the application as indicated by the instructions. You will not need to modify it except for a very small change at the end to test your automated deployment.

⚠️ Before starting the exercise

Your Azure server has limited memory (about 1GB of RAM). Unfortunately, this may not be enough memory to run the MySQL database server, the PostgreSQL database server, PHP-FPM, the PHP todolist and the Flood It application all at the same time.

Make sure that you have added enough memory swap space by displaying available memory with the free -h command. There should be a "Swap" line indicating that you have 2.0Gi of swap space:

$> free -h
               total        used        free      shared  buff/cache   available
Mem:           906Mi       162Mi       471Mi       5.0Mi       272Mi       592Mi
Swap:          2.0Gi       797Mi       1.2Gi

If there is no "Swap" line or it indicates no available swap or less than 2 GB, follow this guide.

⚠️ A note about the project's documentation

The project's README explains how to set up and run the application. That README is generic: it is not written specifically for this course or this exercise.

The instructions on this page explain the exercise step-by-step.

The instructions in the project's README will be useful to you at various points, but be careful not to blindly copy-paste and execute commands from it without understanding what you are doing in the context of the exercise.

❗ Getting started

❗ Fork the repository

You must fork the application's repository to your own GitHub account, because this exercise requires that you make changes to the application later, after setting up the automated deployment with Git hooks.

⚠️ On your local machine, use your own repository's SSH clone URL. This way you will have push access to your repository.

⚠️ On your Azure VM, use your own repository's HTTPS clone URL.

❗ Install the requirements

You may want to start by making sure you have installed all the requirements described in the project's README on your server:

  • How to install Java: there are several methods to install Java. Java was originally developed by Sun Microsystems and now by Oracle, but there are also free, open source implementations. We suggest you use OpenJDK, one of the most popular open source implementations originally released by Sun.

    The OpenJDK publishes easy-to-install APT packages. You can list then with:

    $> apt search openjdk-

    You should install a package named openjdk-<version>-jdk where <version> is the Java version required by the Flood It application.

  • How to install Maven: Depending on your Ubuntu version, the version of Maven available from APT might not be compatible with Java 17. You will therefore install a newer version, using a script located in the Flood It application's repository.

    Download and run the maven-install.sh script from the Flood It repository:

    $> curl -s https://raw.githubusercontent.com/MediaComem/floodit/main/maven-install.sh | sudo bash
    $> source /etc/profile.d/maven.sh

    πŸ’Ž If you prefer not to run a strange script from the Internet on your server, you can also read the script and execute the commands yourself.

  • How to install Node.js: there are several methods to install Node.js. One of the simplest is to use the binary distributions provided by NodeSource. You should look for installation instructions specific to Ubuntu, the Linux distribution used on your server. If possible, you should find instructions for the apt package manager (using the apt or apt-get command).

  • How to install PostgreSQL: you can follow the official instructions on the Downloads page of the PostgreSQL website. You should look for installation instructions specific to Ubuntu, the Linux distribution used on your server.

❓ Check that everything has been correctly installed

  • You can check that Java has been correctly installed by displaying the version of the java command:

    $> java -version
    openjdk version "17.0.5" 2022-10-18
    OpenJDK Runtime Environment (build 17.0.5+8-Ubuntu-2ubuntu122.04)
    OpenJDK 64-Bit Server VM (build 17.0.5+8-Ubuntu-2ubuntu122.04, mixed mode, sharing)

    It's not a problem if you don't have this exact version installed, as long as you have a version compatible with the Flood It application's requirements.

  • You can check that Maven has been correctly installed by displaying the version of the mvn command:

    $> mvn -version
    Apache Maven 3.8.6 (84538c9988a25aec085021c365c560670ad80f63)
    Maven home: /opt/maven
    Java version: 17.0.5, vendor: Private Build, runtime: /usr/lib/jvm/java-17-openjdk-amd64
    Default locale: en, platform encoding: UTF-8
    OS name: "linux", version: "5.15.0-1023-azure", arch: "amd64", family: "unix"

    It's not a problem if you don't have this exact version installed, as long as you have a version compatible with the Flood It application's requirements.

  • You can check that Node.js has been correctly installed by displaying the version of the node command:

    $> node --version
    v18.12.1

    It's not a problem if you don't have this exact version installed, as long as you have a version compatible with the Flood It application's requirements.

    You can also check that Node.js is working correctly by running the following command:

    $> node -e 'console.log(1 + 2)'
    3
  • You can check that PostgreSQL has been correctly installed by displaying the version of the psql command:

    $> psql --version
    psql (PostgreSQL) 15.1 (Ubuntu 15.1-1.pgdg22.04+1)

    It's not a problem if you don't have this exact version installed, as long as you have a version compatible with the Flood It application's requirements.

    You can also verify that PostgreSQL is running by showing the status of its Systemd service:

    $> sudo systemctl status postgresql
    ● postgresql.service - PostgreSQL RDBMS
        Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
        Active: active (exited) since Fri 2021-12-10 20:54:52 UTC; 3 days ago
      Main PID: 2724 (code=exited, status=0/SUCCESS)
          Tasks: 0 (limit: 1087)
        Memory: 0B
        CGroup: /system.slice/postgresql.service
    
    Dec 10 20:54:52 john-doe.archidep.ch systemd[1]: Starting PostgreSQL RDBMS...
    Dec 10 20:54:52 john-doe.archidep.ch systemd[1]: Finished PostgreSQL RDBMS.

    You can also verify that PostgreSQL is working by listing available databases, also with the psql command:

    $> sudo -u postgres psql -l
                                  List of databases
       Name    |  Owner   | Encoding | Collate |  Ctype  |   Access privileges
    -----------+----------+----------+---------+---------+-----------------------
     postgres  | postgres | UTF8     | C.UTF-8 | C.UTF-8 |
     template0 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | =c/postgres          +
               |          |          |         |         | postgres=CTc/postgres
     template1 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | =c/postgres          +
               |          |          |         |         | postgres=CTc/postgres
    (3 rows)

    Note that PostgreSQL runs on port 5432 by default, which you can verify by checking the port setting in its configuration file:

    $> cat /etc/postgresql/15/main/postgresql.conf | grep '^port'
    port = 5432

❗ Perform the initial setup

You must perform the initial setup instructions indicated in the project's README.

⚠️ Since you will need to commit and push changes later, do not use the https://github.com/MediaComem/floodit.git URL to clone the repository as suggested in the README. That repository belongs to the school. Use your own fork's HTTPS clone URL.

πŸ’Ž When you reach the step where you need to "Configure the application", you will see that the Flood It application has two configuration mechanisms: environment variables or a local configuration file. You can use either one of them. It does not matter which you choose. Both are equally valid way of configuring the application.

If you choose to use environment variables, you will need to provide these environment variables through Systemd later, as you have done with the PHP todolist. The export sample commands provided in the README are only examples and will only set the variables in the shell and SSH session where you run them.

πŸ“š What sorcery is this?

Read this section if you want to understand what you have done/installed so far.

πŸ“š The Java Virtual Machine (JVM), Java Runtime Environment (JRE) and Java Development Kit (JDK)

The backend of the Flood It application is written in Java.

When you write a program in Java, your source code is compiled to produce byte code that can be run in a Java Virtual Machine (JVM). This is what makes Java cross-platform: any system that has a JVM can run Java byte code compiled on any other system. There are JVM implementations for all major operating systems and processor architectures.

The Java Runtime Environment (JRE) is a software package that you can install on your favorite operating system (e.g. Linux, macOS, Windows) that provides a JVM. It contains everything you need to run already compiled Java programs (i.e. Java byte code, often distributed in the form of JAR files).

The Java Development Kit (JDK) is a software development kit that includes the JRE but also everything you need to compile Java programs into Java byte code. You will use it to compile the backend of the Flood It application.

πŸ“š The PostgreSQL createuser and createdb commands

The setup instructions use the createuser and createdb commands. These commands are binaries that come with the PostgreSQL server and can be used to manage PostgreSQL users and databases on the command line:

  • The createuser --interactive --pwprompt floodit command creates a PostgreSQL user named "floodit" and asks you to define a password for that user. The application will use this PostgreSQL username and password to connect to the database.

  • The createdb --owner floodit floodit command creates an empty PostgreSQL database named "floodit" and owned by the "floodit" user. This is the database that the application will use.

    You can see this new database by listing all available databases:

    $> sudo -u postgres psql -l
                                                List of databases
      Name    |  Owner   | Encoding | Collate |  Ctype  | ICU Locale | Locale Provider |   Access privileges
    -----------+----------+----------+---------+---------+------------+-----------------+-----------------------
    floodit   | floodit  | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            |
    ...

These database setup commands are equivalent to part of the todolist.sql script you executed when first deploying the PHP todolist.

If you prefer using SQL, you could instead connect to the database as the postgres user (equivalent to MySQL's root user) with sudo -u postgres psql and run equivalent CREATE USER and CREATE DATABASE queries.

Note that on the command line, PostgreSQL uses peer authentication based on the Unix username by default. This is why the commands are prefixed with sudo -u postgres to execute them as the postgres Unix user. This user was created when you installed PostgreSQL and has administrative privileges on the entire PostgreSQL cluster. You can verify the existence of this user with the command cat /etc/passwd | grep postgres.

πŸ“š The mvn command

The setup instructions use the mvn command. Maven is a software project management tool for the Java ecosystem, much like Composer for PHP or npm for Node.js.

  • A Maven project has one or several Project Object Model (POM) files. These pom.xml files describe a project's dependencies and how to build it (you can look at the Flood It application's backend/pom.xml file as an example).

  • The mvn clean install -Pskip-test command is used to:

    • Download all of the Flood It application's dependencies (i.e. the Java libraries it requires to work), like the Spring Boot web framework. Spring Boot is a web framework written in Java much like Laravel is a web framework written in PHP.

      The dependencies are downloaded from Maven Central, the main package registry for the Java ecosystem, and saved into the ~/.m2 directory (in your home directory).

    • Build the application (i.e. compile the Java source code into JVM bytecode).

    • Install the application into the local Maven repository.

πŸ“š Node.js

Node.js is an open-source, cross-platform JavaScript runtime environment. Where JavaScript could traditionally only run in a browser, Node.js allows you to run JavaScript code on any machine, like on your Azure VM, just like you would any other dynamic programming language like PHP, Ruby or Python.

πŸ“š The npm command

The setup instructions use the npm command. npm is the world's largest software registry for the JavaScript and Node.js ecosystems. The npm command can be used to install and manage JavaScript packages, much like Composer for PHP or Maven for Java

πŸ“š The configuration of the Flood It application

The configuration you are instructed to perform either through environment variables or through the backend/config/application-default.local.yml file is equivalent to the configuration of the PHP todolist which you improved during the course using environment variables. It is not uncommon for applications to provide multiple configuration mechanisms, letting you choose which is more convenient for you.

❓ Optional: run the automated tests

The Flood It application includes an automated test suite. Automated tests are programs that check that the application works by simulating input and checking output. They are not a replacement for manual testing by humans, but programs can test mundane, repetitive tasks much faster and much more reliably than a human can.

The project's README explains how to set up and run the automated tests.

Running these tests is entirely optional, but it will make sure that everything is working properly, including that:

  • The application executes correctly with the Java Runtime Environment (JRE) you have installed.
  • The application can successfully connect to and migrate the database.
  • The application behaves as specified.

Running the tests might take a minute or two, then the following output should be displayed, indicating that all tests were successful:

...
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 19, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO]
[INFO] --- jacoco-maven-plugin:0.8.8:report (jacoco-site) @ floodit ---
[INFO] Loading execution data file /home/john_doe/floodit/backend/target/jacoco.exec
[INFO] Analyzed bundle 'floodit' with 19 classes
[INFO]
[INFO] ------------------< ch.comem.archidep:floodit-parent >------------------
[INFO] Building floodit-parent 1.0.0                                      [2/2]
[INFO] --------------------------------[ pom ]---------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ floodit-parent ---
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] floodit 1.0.0-SNAPSHOT ............................. SUCCESS [ 34.216 s]
[INFO] floodit-parent 1.0.0 ............................... SUCCESS [  0.069 s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  34.789 s
[INFO] Finished at: 2022-11-24T09:51:34Z
[INFO] ------------------------------------------------------------------------

πŸ“š If you are curious, the source code for these tests is in the test directory.

❓ Optional: run the application in development mode

Before running the application in production mode and attempting to set up the systemd service, nginx configuration and automated deployment, you can manually run the application in development mode to make sure it works. The project's README explains how to do this. You will need two terminals connected to your server: one to run the backend, and one to run the frontend.

You can run the frontend application on port 3001 for this simple test, as that is one of the ports that should be open in your server's firewall. You must also make it available to external clients. The project's README explains how to do this.

Once you have both backend and frontend running in your two terminals, you should be able to visit http://W.X.Y.Z:3001 to check that the application works (replacing W.X.Y.Z by your server's IP address). Stop both components by typing Ctrl-C once you are done.

❗ Run the application in production mode

Follow the instructions in the project's README to run the application in production mode.

πŸ“š To run a Maven project in production, you must install it (i.e. the mvn clean install command), which will create a JAR file.. This is basically a ZIP file of the compiled Java application, which can be run by any Java Virtual Machine (JVM). Once you have created that JAR file, you could copy it to any system that has the Java Runtime Environment (JRE) and run it there. The Java Development Kit (JDK) is only required to perform the compilation.

πŸ“š The npm run build command used in the instructions bundles the frontend's files in production mode, compressing and digesting them. To "digest" a web asset is to include a hash of its contents in the filename for the purposes of caching. This optimizes the delivery of web assets to browsers especially when they come back to your website after having already visited once.

πŸ“š You can list the frontend/dist directory to see the digested assets: ls frontend/dist. Observe that a file named runtime.a185471aecb581c1.js (the hash may differ) has appeared. The hash part of the filename (a185471aecb581c1 in this case) depends on the content. When the content changes, the hash changes. This means you can instruct client browsers to cache web assets indefinitely, since you know that an asset's name will not change as long as its content does not change as well and, conversely, that an asset's name will always change if it has been modified.

❗ Create a systemd service

Create and enable a systemd unit file like in the systemd exercise. Make the necessary changes to run the Flood It application instead of the PHP todolist.

  • πŸ’Ž You will find the correct command to run the application in the project's README.

    Remember that systemd requires absolute paths to commands. You can use which <command> to determine where a command is.

  • πŸ’Ž You may need to set the FLOODIT_SERVER_PORT environment variable or the server.port parameter in the local configuration file to choose the port on which the application will listen. You can use the publicly accessible 3001 port temporarily for testing, but you should use another free port that is not exposed to complete the exercise, since one of the requirements is to expose the application only through nginx.

Once you have enabled and started the service, it should start automatically the next time you restart the server with sudo reboot.

πŸ‘Ύ If you know what you are doing, you can already set up the automated deployment project structure at this point, so that you can point your systemd configuration to the correct directory. That way you will not have to modify it later.

❗ Serve the application through nginx

Create an nginx proxy configuration to serve the application like in the nginx PHP-FPM exercise.

The root directive in your nginx configuration should point to the frontend/dist directory in the repository since that is the directory that contains the application's public web assets.

  • πŸ’Ž Use an absolute path for the root directive.
  • πŸ’Ž Do not follow steps related to PHP FPM, since they are only valid for a PHP application.
  • πŸ’Ž The include and fastcgi_pass directives used in the PHP FPM exercise make no sense for a non-PHP application. You should replace them with a proxy_pass directive. as presented during the course and as you have done in the multi-component exercise.
  • πŸ‘Ύ You can also point the nginx configuration directly to the automated deployment structure. That way you will not have to modify it later.

❗ Provision a TLS certificate

Obtain and configure a TLS certificate to serve the application over HTTPS like in the certbot exercise.

❗ Set up an automated deployment with Git hooks

Change your deployment so that the application can be automatically updated via a Git hook like in the automated deployment exercise.

Once you have set up the new directories, make sure to update your systemd unit file and nginx configuration file to point to the correct directories.

Because the new directory is a fresh deployment, you may have to repeat part of the initial setup you performed in the original directory. The PostgreSQL user, database and extension have already been created, and your hook will handle most of the rest of the setup. But if you used the backend/config/application-default.local.yml configuration file, you must copy it to the new deployment directory as well. You can use the cp <source> <target> command for this.

Complete the post-receive hook. Compared to the PHP todolist, there are additional steps which must be performed in the script for the automated deployment to work correctly:

  • Frontend dependencies must be updated in case there are new or upgraded ones. The PHP todolist had no dependencies so you did not need to do this.

    πŸ“š The backend dependencies of the Flood It application must also be updated, but Maven will do this for you automatically.

  • The Angular frontend must be rebuilt in case changes were made to the frontend source files.

  • The backend application must be rebuilt in case changes were made to the source files.

  • The systemd service must be restarted with systemctl.

    πŸ“š Unlike PHP, code in most other languages is not reinterpreted on-the-fly; the service must be restarted so that the program is reloaded into memory as a new process).

The project's README explains how to do all of this except restarting the Systemd service, which you can easily do with sudo systemctl restart <service>. You should run the appropriate commands in your post-receive hook script.

πŸ’Ž Allowing your user to restart the service without a password

In order for the new post-receive hook to work, your user must be able to run sudo systemctl restart floodit (assuming you have named your service floodit) without entering a password, otherwise it will not work in a Git hook.

πŸ“š This is because a Git hook is not an interactive program. You are not running it yourself, so you are not available to enter your password where prompted.

If you are using the administrator user account that came with your Azure VM to run the application, it already has the right to use sudo without a password.

πŸ“š This has been automatically configured for you in the /etc/sudoers.d/90-cloud-init-users file.

πŸ‘Ύ Allowing the dedicated floodit Unix user to control the Systemd service

If you are trying to complete the bonus challenge, you will need to allow the floodit user run the necessary sudo systemctl ... commands without a password as well.

Make sure your default editor is nano (or whichever you are more comfortable with):

$> sudo update-alternatives --config editor

When you created the floodit Unix user, your server created a corresponding Unix group with the same name by default. Now you will add a file in the /etc/sudoers.d directory to allow users in the floodit Unix group to run some specific commands without a password.

$> sudo visudo -f /etc/sudoers.d/floodit

πŸ“š The visudo command allows you to edit the sudoers file in a safe fashion. It will refuse to save a sudoers file with a syntax error (which could potentially corrupt your system or lock you out of your administrative privileges).

Add the following line to the file:

%floodit ALL=(ALL:ALL) NOPASSWD: /bin/systemctl restart floodit, /bin/systemctl status floodit, /bin/systemctl start floodit, /bin/systemctl stop floodit

πŸ“š This line allows any user in the floodit group to execute the listed commands with sudo without having to enter a password (hence the NOPASSWD option).

Exit with Ctrl-X if you are using Nano or with Esc then :wq if you are using Vim.

πŸ’Ž If you are using nano, the filename you are asked to confirm will be /etc/sudoers.d/floodit.tmp instead of /etc/sudoers.d/floodit. This is normal, because visudo uses a temporary file to validate your changes before saving the actual file. You may confirm without changes.

You can test that it works by first switching to the floodit user with sudo su - floodit and then running sudo systemctl status floodit. It should run the command without asking you for any password (only for the specific commands listed in the file your created).

❗ Test the automated deployment

Clone your fork of the repository to your local machine, make sure you have added a remote pointing to your server, then commit and push a change to test the automated deployment.

Here's some visible changes you could easily make:

❗ Notify the teachers

Send an email or a Teams message to both teachers no later than December 13th 2022 at 23:59 CET indicating that you have finished the exercise.

🏁 What have I done?

You have deployed a new backend/frontend web application to your server from scratch, using the knowledge you acquired during previous deployment exercises.

πŸ›οΈ Architecture

This is a simplified architecture of the main running processes and communication flow at the end of this exercise (after completing all previous course exercises):

Simplified architecture

Simplified architecture PDF version.

πŸ’₯ Troubleshooting

Here's a few tips about some problems you may encounter during this exercise. Note that some of these errors can happen in various situations:

  • When running a command manually from your terminal.
  • When systemd tries to start your service.
  • When your post-receive Git hook executes.

πŸ’₯ Daemons using outdated libraries

When you install a package with APT (e.g. MySQL), it may prompt you to reboot and/or to restart outdated daemons (i.e. background services):

Restart outdated daemons

Simply select "Ok" by pressing the Tab key, then press Enter to confirm.

πŸ“š This happens because most recent Linux versions have unattended upgrades: a tool that automatically installs daily security upgrades on your server without human intervention. Sometimes, some of the background services running on your server may need to be restarted for these upgrades to be applied.

Since you are installing a new background service (the MySQL server) which must be started, APT asks whether you want to apply upgrades to other background services by restarting them. Rebooting your server would also have the effect of restarting these services and applying the security upgrades.

πŸ’₯ No plugin found for prefix 'spring-boot' in the current project

If you get an error similar to this when running the mvn command:

$> mvn spring-boot:run
[INFO] Scanning for projects...
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml (14 kB at 26 kB/s)
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml (21 kB at 36 kB/s)
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  1.467 s
[INFO] Finished at: 2022-11-24T11:27:45Z
[INFO] ------------------------------------------------------------------------
[ERROR] No plugin found for prefix 'spring-boot' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (/home/john_doe/.m2/repository), central (https://repo.maven.apache.org/maven2)] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/NoPluginFoundForPrefixException

It means that you are running the command in the wrong directory. Maven requires a pom.xml file to know what to do. You must be sure to run the mvn command in a directory that contains this pom.xml file, i.e. in the repository of the Flood It application that you cloned.

πŸ’₯ FATAL: password authentication failed for user "floodit"

If you see an error similar to this when starting the application or running the automated tests:

SQL State  : 28P01
Error Code : 0
Message    : FATAL: password authentication failed for user "floodit"

        at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:60) ~[flyway-core-8.5.13.jar:na]
        at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75) ~[flyway-core-8.5.13.jar:na]
        at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:147) ~[flyway-core-8.5.13.jar:na]
        at org.flywaydb.core.Flyway.migrate(Flyway.java:124) ~[flyway-core-8.5.13.jar:na]
        at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-2.7.4.jar:2.7.4]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.23.jar:5.3.23]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.23.jar:5.3.23]
        ... 18 common frames omitted
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "floodit"
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:646) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.Driver.makeConnection(Driver.java:402) ~[postgresql-42.3.7.jar:42.3.7]
        at org.postgresql.Driver.connect(Driver.java:261) ~[postgresql-42.3.7.jar:42.3.7]
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-4.0.3.jar:na]
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-4.0.3.jar:na]
        at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:48) ~[flyway-core-8.5.13.jar:na]
        ... 24 common frames omitted

It means that the Flood It application or its automated tests cannot connect to the database:

  • Are you sure that you followed all the setup instructions and performed all necessary configuration?
  • Did you properly create the floodit PostgreSQL user and database?
  • If you are attempting to run the application in development mode, did you properly configure the database connection with the $FLOODIT_DATABASE_* environment variable or via the backend/config/application-default.local.yml file?
  • If you are attempting to run the automated tests, did you properly configure the database connection with the $FLOODIT_TEST_DATABASE_* environment variable or via the backend/config/application-test.local.yml file?
  • Are you using the correct password?

Just like the PHP todolist required the correct configuration to successfully connect to its MySQL database, the Flood It application also requires the correct configuration to connect to its PostgreSQL database.

πŸ’₯ Web server failed to start. Port 5000 was already in use.

If you see an error similar to this when running the application:

***************************
APPLICATION FAILED TO START
***************************

Description:

Web server failed to start. Port 5000 was already in use.

Action:

Identify and stop the process that's listening on port 5000 or configure this application to listen on another port.

It means that there is already an application or other process listening on the port the Flood It backend is trying to listen on (port 5000 by default). You should use the $FLOODIT_SERVER_PORT environment variable or the server.port parameter in the local configuration file to change the port, for example if you are trying to run the application in development mode:

$> FLOODIT_SERVER_PORT=5001 mvn spring-boot:run

πŸ’₯ remote: sudo: no tty present and no askpass program specified

If you see an error message similar to this when your Git hook is triggered:

remote: sudo: no tty present and no askpass program specified

It means that you have created a dedicated Unix user but you have not performed the following step correctly: Allowing the dedicated floodit Unix user to control the Systemd service.

Make sure that the list of authorized systemctl commands in the sudoers file match the name of your service (if you named your systemd configuration file something other than floodit.service, you must adapt the commands in the /etc/sudoers.d/floodit file to use the correct service name).

πŸ“š This error occurs because ordinarily, a Unix user does not have the right to execute sudo systemctl restart floodit without entering their password to gain administrative rights. A Git hook is executed in a non-interactive context: it can only print information, and you cannot interact with it (e.g. give it input) while it is running. This means that it cannot ask for your password, so any sudo command will fail by default.

This is what the error message indicates: no tty present means that there is no interactive terminal (tty comes from the terminology of the 1970s: it means a teletypewriter, which was one of the first terminals).

The linked instructions above grant the user the right to execute specific sudo commands (like sudo systemctl restart floodit) without having to enter your password. Once that is done, these commands will work from the Git hook as well.

πŸ’₯ code=exited, status=200/CHDIR

If you see an error message similar to this in your systemd service's status:

code=exited, status=200/CHDIR

It means that systemd failed to move into the directory you specified (CHDIR means change directory). Check your Systemd unit file to make sure that the working directory you have configured is the correct one and really exists.

πŸ’₯ 502 Bad Gateway

If you get a 502 Bad Gateway error in your browser when trying to access an nginx site you have configured, it means that you have reached nginx, but that nginx could not reach the proxy address you have configured. The proxy address is defined with the proxy_pass directive in that site's configuration file.

Are you sure that your nginx configuration, namely the proxy address, is correct? Check to make sure you are using the correct address and port. Is your application actually listening on that port?

πŸ’₯ I forgot to fork the Flood It repository and I have already cloned it

You may have cloned the exercise's repository directly:

$> git remote -v
origin  https://github.com/MediaComem/floodit.git (fetch)
origin  https://github.com/MediaComem/floodit.git (push)

Then you won't have push access because this repository does not belong to you. Fork the repository, then change your clone's remote URL by running this command in your clone's directory on the server (replacing MyGitHubUser with your GitHub username):

$> git remote set-url origin https://github.com/MyGitHubUser/floodit.git

πŸ’₯ I don't remember the password I used for the floodit PostgreSQL user

You can change it with the following command:

$> sudo -u postgres psql -c '\password floodit'

πŸ’₯ System debugging

You can display the last few lines of the logs of your floodit Systemd service with the following command:

$> sudo systemctl status floodit

If you need more details, you can display the full logs with the following command:

$> sudo journalctl -u floodit

πŸ’Ž You can scroll in journalctl logs using the up/down arrow keys, jump directly to the bottom with Shift-G (uppercase G), or back to the top with G (lowercase g). Exit with Q or Ctrl-C.

If the application does not seem to work after running the Systemd service, there might be an error message in these logs that can help you identify the issue.

πŸ’₯ PostgreSQL debugging

You can list available databases with the following command:

$> sudo -u postgres psql -l

You can connect to a database with the following command:

$> sudo -u postgresql psql <database-name>
floodit=#

Note that the prompt has changed, because you are now connected to the interactive PostgreSQL console. You can obtain help by typing the \? command (q to exit the help page), or type SQL queries. For example, here's how to list the tables in the current database and count the number of rows in the games table:

floodit=# \d
                 List of relations
 Schema |         Name          |   Type   | Owner
--------+-----------------------+----------+--------
 public | flyway_schema_history | table    | floodit
 public | games                 | table    | floodit
 public | games_id_seq          | sequence | floodit
 public | moves                 | table    | floodit
 public | moves_id_seq          | sequence | floodit
(5 rows)

floodit=# select count(*) from games;
 count
-------
     2
(1 row)

Run the exit command when you are done to exit the PostgreSQL console.

πŸ’₯ Updating your fork of the repository

If changes (e.g. bugfixes) are made to the original repository after you have started the exercise, these changes will not automatically be included into your fork of the repository. You can follow this procedure to update it.

On your local machine:

# Clone your fork of the Flood It repository on your local machine (replace
# MyGitHubUser by your GitHub username)
cd /path/to/projects
git clone [email protected]:MyGitHubUser/floodit.git
cd floodit

# Add a remote to the original repository
git remote add upstream https://github.com/MediaComem/floodit.git

# Fetch the latest changes from all remotes
git fetch --all

# Merge the latest changes from the original repository into your local repository
git merge upstream/main

# Push the new version to your fork on GitHub
git push origin main

If you have already setup the automated deployment, you simply need to push to your archidep remote again.

Otherwise if you have cloned the repository on your server, you should also update it. Connect to your server and run the following commands:

# Move into the floodit repository you have cloned
cd floodit

# Pull the latest changes
git pull

πŸ’₯ Error creating new order :: too many certificates already issued for: archidep.ch

If you see an error similar to this when attempting to obtain a Let's Encrypt TLS certificate with Certbot:

$> sudo certbot --nginx
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator nginx, Installer nginx

Which names would you like to activate HTTPS for?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1: clock.john-doe.archidep.ch
2: floodit.john-doe.archidep.ch
3: todolist.john-doe.archidep.ch
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Select the appropriate numbers separated by commas and/or spaces, or leave input
blank to select all options shown (Enter 'c' to cancel): 2
Obtaining a new certificate
An unexpected error occurred:
There were too many requests of a given type :: Error creating new order :: too many certificates already issued for: archidep.ch: see https://letsencrypt.org/docs/rate-limits/
Please see the logfiles in /var/log/letsencrypt for more details.

It means that you are running into a rate limit of the Let's Encrypt service: at most 50 certificates can be requested per domain per week. With more than 50 students in both classes of the architecture & deployment course, we may encounter this limit now and then.

A second domain, archidep2.ch, is now available for you. You can access Gandi.net to add entries to its DNS zone like in the DNS exercise.

You should add the same entries you added for archidep.ch to this new archidep2.ch domain:

  • An A entry for john-doe (replacing john-doe with your name) pointing to your server's public IP address.
  • Another A entry for *.john-doe (replacing john-doe with your name) pointing to the same IP address.

You can then connect to your server and perform the following actions:

  • Update your nginx configuration for the exercise to use your new subdomain of archidep2.ch instead of archidep.ch.
  • Test and reload nginx's configuration with sudo nginx -t and sudo nginx -s reload.
  • Run the sudo certbot --nginx command again. There should be no errors this time.

Please notify the teacher immediately if you encounter the same error with the archidep2.ch domain.