TCC Audit - ISO/IEC 27002:2022

Summary

• About
• Technologies
• Instructions for Use with Docker
• API Endpoints
• Screenshots
• Troubleshooting
• Contribution
• License
• Contact

About

The TCC Audit is a tool developed as part of the Course Completion Project (TCC) at FATEC São Caetano do Sul, specifically within the Information Security field. Its main objective is to help organizations assess their maturity in information security best practices, based on the guidelines outlined in the ISO/IEC 27002:2022 standard.

This standard establishes a comprehensive framework consisting of controls, guidelines, and best practices designed to improve information security in organizations. The overall objective is to ensure the confidentiality, integrity, and availability of confidential data.

The creation of the TCC Audit means a commitment to applying the practical knowledge acquired throughout the course. Taking advantage of the principles and insights acquired in the Information Security course at FATEC São Caetano do Sul.

Technologies

• Backend:
  • Java 21
  • Apache Maven
• Database:
  • MySQL Server
• Frontend:
  • JavaScript
  • HTML5
  • CSS3
• Visualization:
  • Grafana
• Tools:
  • Visual Studio Code (VSCode)
  • Postman
  • phpMyAdmin
  • Git
  • Docker

Instructions for Use with Docker

Prerequisites:

• Docker

Step 1: Install Docker:

• Windows:

  • Install Docker Desktop

• Linux:

  • Install Docker

• macOS:

  • Install Docker Desktop

Step 2: Clone the Repository:

• Clone the repository using the following Git command:

  git clone https://github.com/vicentejluz/tcc-audit-27002.git

Step 3: Navigate to the Project Directory:

• Navigate to the directory where the cloned repository is located:

  cd tcc-audit-27002

Step 4: Configure and Start the Application:

• Create a .env file in the root directory of your project:

    MYSQLDB_DATABASE=`<Database Name>`
    MYSQLDB_ROOT_PASSWORD=`<Database Root User Password>`
    MYSQLDB_USER=`<Database User>`
    MYSQLDB_USER_PASSWORD=`<Database User Password>`
    TOKEN_SECRET=`<JWT Token Secret>`

• Start the application using Docker-Compose:

  docker compose up -d

• Optionally, if you want to rebuild the Docker images during startup:

  docker compose up -d --build

Step 5: Access the Frontend Application:

• The Frontend will be running at http://localhost/index.html

To access phpMyAdmin, go to http://localhost:8888/

Note: If you change the ports for the Backend or Grafana service in the docker-compose.yml file, make sure to update them in the frontend (project view directory) as well. Modify the following files accordingly:

• For Backend port, update the HTTP_PORT variable in ./view/scripts/module/api.js.

• For Grafana port, update the port variable in ./view/scripts/module/utils/grafana.js.

API Endpoints

For more information, access the API Documentation. Please note that this link is functional only when the system is running.

The API provides the following endpoints:

• Employee:

GET /employees - List all employees. (ADMIN access required)
GET /employee/:id - Retrieve information about a specific employee based on ID. (all authenticated employees)
POST /sign-up - Register a new employee in the system. (ADMIN access required)
PUT /is-enabled/:id - Block or unblock an employee's login. (ADMIN access required)

• Company:

POST /sign-up-company - Registers a new company in the system. (Public access, no authentication required.)

• Authentication:

POST /login - Performs employee authentication, generating an access token. (Public access, no authentication required.)

• Evidence:

GET /evidences/:id - Retrieves information about a specific evidence based on its ID. (all authenticated employees)
GET /evidences/download/:id - Downloads the file associated with a specific evidence. (all authenticated employees)
POST /evidences/upload - Uploads a new evidence to the system. (all authenticated employees)
DELETE /evidences/delete/:id - Deletes a specific evidence from the system. (all authenticated employees)

• Answer:

GET /answers/count/:id - Returns the total count of responses for a specific company. (all authenticated employees)
GET /answers/by-topic - Returns responses organized by topic. (all authenticated employees)
POST /answers - Submits a new response to the system. (all authenticated employees)

• Address:

GET /via-cep - Returns address information based on the provided postal code. (public access, no authentication required.)

• Topic:

GET /topics/:topic - Returns detailed information about a specific topic. (all authenticated employees)

• Summary:

GET /summaries/:topic - Returns a summary related to a specific topic. (all authenticated employees)

• Question:

GET /questions/summaries/:id - Returns questions associated with a specific summary. (all authenticated employees)

• Department:

GET /departments - Returns information about all departments. (ADMIN access required)

Screenshots

Representation of the logical data model illustrating entities, relationships, and attributes, providing a structured overview of the data structure within the system.

Home page of the system.

Registering a new company in the system.

Logging into the system.

Overview of the system's dashboard.

Employee registration page.

Blocking or unblocking an employee in the system.

ISO-related questionnaire form for employees to provide information about the company's adherence to ISO standards.

Pop-up notification displayed upon completing all questionnaire responses.

Grafana visualization to filter and analyze data from form responses.

Troubleshooting:

1. If you encounter the "exec /usr/local/bin/docker-entrypoint.sh: no such file or directory" error when running Docker, it may be due to incorrect line endings in the docker-entrypoint.sh file. Follow these steps to fix it:

   • Fix with text editor or IDE:

     • Step 1: Open the docker-entrypoint.sh file in your preferred text editor or IDE.

     • Step 2: Change the line endings from CRLF (Windows) to LF (Unix). Most text editors have an option to do this in the status bar or the file menu.

     • Step 3: Save the file and try running the Docker container again.

   • Fix with command line for Linux:

     • Step 1: Install dos2unix (If it is not installed, if it is already installed, skip this step).

       sudo apt-get install dos2unix

     • Step 2: Navigate to the directory where the docker-entrypoint.sh file is located:

       cd /path/to/directory/where/the/file/docker-entrypoint.sh/is

     • Step 3: Run dos2unix (assuming it's installed):

       dos2unix docker-entrypoint.sh

     • Step 4: Save the file and try running the Docker container again.

   This should resolve the "exec /usr/local/bin/docker-entrypoint.sh: no such file or directory" issue.

Contribution

Contributions are welcome! If you encounter any issues or have suggestions for improvements, please open an issue or submit a pull request to the repository.

License

This project is licensed under the MIT License - see the LICENSE file for more details.

Contact