inSecurity

This is the Flight Reservation Web Application repository for UCD BSc Computer Science module COMP47660 Secure Software Engineering in 2020-21

Authors (Team inSecurity)

• Ee En Goh (Current maintainer)
• Seán Conor McLoughlin
• Olanipekun Akintola
• Svetoslav Nizhnichenkov

Pre-requisites

• Java 8 or higher version (version 1.8+)
• Maven

Project Status

How to run this program

1. Decrypt encrypted sensitive properties

   • Encryption of sensitive properties inside file application.properties is enabled with Jasypt

   • To generate the encoded credential value, go to maven library path ~/.m2/repository/org/jasypt/jasypt/1.9.0 on terminal (CLI)

   • Use the following command to run the JAR program to generate the encoded value

      java -cp jasypt-1.9.0.jar org.jasypt.intf.cli.JasyptPBEStringEncryptionCLI input="value" password=<key> algorithm=PBEWithMD5AndDES
     

     • input - The value in string to be encoded
     • password - The key for both encryption and decryption of the input
     • algorithm - The encoding algorithm, that here we use a Password-Based version of DES Encryption algorithm, with the MD5 hash of the password as the encryption key

   • Jasypt reads all the properties from application.properties or any classpath properties that you passed, with value prefix ENC( and suffix )

   • The password is required to run this application, with the following Maven argument :

     -Djasypt.encryptor.password=secretkey

   • Reference : https://medium.com/@mail2rajeevshukla/hiding-encrypting-database-password-in-the-application-properties-34d59fe104eb

2. Open a terminal on the root directory of this project (ie. where this doc is stored)

3. Run the command mvn clean install to run tests and build the project

4. Run the command mvn spring-boot:run to run the Spring Boot application

5. Note that the first run of this web app will return certain Exception since initialization of database tables is not included in the relevant SQL script, while those tables will be initialized automatically after those exceptions are thrown. Thus, it will run smoothly after the first time.

6. Go to http://localhost:<server.port> to open the web application (setting can be done in application.properties)

   # 8080 by default
   server.port=<open_port>

7. To connect to the h2 database, open up any browser and navigate to localhost:8080/h2-console

• Click on Advanced -> Proceed to localhost (unsafe).

  

Introduction to this web application

Homepage is the first page you will always see when you open this application with localhost:<server.port>

1. Header of the navigation bar, also the link to homepage
2. Reservation retrieval form for any guest with their email address & reservation id
3. Club member registration link
4. Member login link
5. Flight search as a guest

Member

1. Register a Club Member Account by clicking the Register link (3) in the upper right-hand corner.

2. Input the required details and click Register at the bottom of the form.

3. Upon returning to the login page, you can login as the created Member via the Login button (4) in the upper-right hand side of the page.

   

4. Clicking on the Member icon (displayed as your username) that has nor replaced the Register/Login icons, a dropdown menu will give you a choice of viewing reservations (6), your profile (7) or logging out (8).

5. Click on Profile to see your personal details and find links to edit user details (9), view stored credit cards (10), changing password (11), or delete the Member registration (12).

   

6. By default, credit cards are required to book a flight. Select View Credit cards, then Add New Card to create one. If you do not you will be propmpted to do so during the boooking process.

7. From the home page, select a Fight to book. An example might be From Sofia to Dublin on the 19th of March.

8. After completing a booking it will be available to view in Reservations in the Member drop-down menu in the upper-right hand side.

9. If more than 24 hours away, an option to cancel will be available.

Guest

1. As a guest, you can use the flight search form (5) right away to make reservation
2. You will require the email address and the reservation id to retrieve your reservation information

Admin

As an admin, you can look at users' profiles, update their information, and change their reservations.