IT Support Ticketing System – Built with MariaDB & Apache

Description

This project showcases the setup of a help desk ticketing system using MariaDB and an Apache web server on a localhost environment. The goal is to create an efficient system for tracking and managing IT support requests, simulating a real-world help desk workflow.

Languages and Utilities Used

- GLPI (10.0.18)
- MariaDB (11.4.4)

Environments Used

- Localhost
- Linux (6.11.2)
- Apache (2.4.63)

Program walk-through:

Updating System w/ Dependencies:


Ensuring the LAMP stack is installed:


Ensuring the MariaDB is installed:


Checking if PHP is Installed:


Installing PHP Extentions for GLPI:


Starting and Enabling the Maria Database Service:


Opening MariaDB & Creating a Database:


Creating a Dedicated User & Granting Permissions to the GLPI User:


Go to /var/www/html Directory and List Permissions:


Download GLPI in /var/www/html Directory:


Checking Directory Permissions:


Changing Ownership & Permissions in GLPI Directory:


Restarting Apache2:


Checking IP Address:


*** PROBLEM SOLVED *** (the GLPI web server refused to connect until I...):


Inside the Configuration File, Ensure the Document Root Matches the Directory that the GLPI is in:


Then Fix Permissions:


NOW You Have Access to GLPI:


Install & Ensure PHP Installations:


Database Connection Setup:


Inside the config_db.php file, add the MariaDB connection details:


Set Permissions on config-db.php & glpicrypt.key Files:


Enable Permissions Match the User & Type "USE (your_database_name_here)":


Proceed to Last Installation Page:


Login to GLPI w/ Default Credentials:


Remove the install.php File in the Install Directory & Restart Apache:


Done!: