osTicket - Installation

This tutorial outlines the prerequisites and installation of the open-source help desk ticketing system osTicket.

Technologies Used

• Microsoft Azure (Virtual Machines/Compute)
• Remote Desktop
• Internet Information Services (IIS)

Required Prerequisites

• Heidi SQL
• MySQL 5.5
• Web Platform Installer 5.1
• Information Internet Systems (IIS)

Installation

Create a Virtual Machine (Windows 10 Pro) using Microsoft Azure

Connect to the VM with Remote Desktop

Once you are in the Virtual Machine you will need to enable IIS

Go to "turn windows features on or off" in the control panel and then enable Internet Information Services

We will be using the following link to install the Web Platform Installer and all the required files or applications https://drive.google.com/drive/u/1/folders/1APMfNyfNzcxZC6EzdaNfdZsUwxWYChf6

Download the Web Platform Installer and open it

Now add and install MySQL 5.5 and add all the version of x86 PHP up until 7.3

(Note: MySQL 5.5 will ask credintials to be created later)

Once the installation is complete you will notice that some of the files are failed to install

We will need to install them manually

Go to the google drive installation files link and download the following files:

1. Microsoft C++

2. PHP Manager for IIS

Next download the osTicket from the installation files: https://drive.google.com/drive/u/1/folders/1APMfNyfNzcxZC6EzdaNfdZsUwxWYChf6

Within osTicket extract the "uplaod" folder into c:\inetpub\wwwroot

Rename "upload" folder to "osTicket"

Now open IIS and restart the server

On the Connections menu go to Vm2\Sites\default Web Site\osTicket

Click on "Browse *:80 (http)" on the right hand side of the screen

The osTicket installer will pop up in the default browser of your virtual machine once you click on "Browse *:80 (http)"

Before we continue to install osTicket we will have to enable some extensions in the PHP manager and assign permissions for ost-config.php

Go back to IIS and go to VM2 >sites >Default Web Site >osTicket

Open PHP Manager and under PHP Extensions, click on "enable or disable an extension"

Enable the following extensions:

Once you enable the extenstions go back to the osTicket installer browser and refresh the browser

Observe any changes

Rename: From: C:\inetpub\wwwroot\osTicket\include\ost-sampleconfig.php To: C:\inetpub\wwwroot\osTicket\include\ost-config.php

Next assign permissions to ost-config:

1. Disable Inheritance- Right click on ost-config.php, go to Properties >Security >Advanced >Disable Inheritance >Remove all inherited permissions from this object
2. Add Permissions- Go to properties >Security >Advanced >Add >Select a principal, Enter "Everyone" and allow them to Full Control

Once you disable inheritance and assign permissions we are ready to begin the installaion process of the osTicket

Name the help desk and fill in the required information

Before we fill out the Database connection information we will have to install and setup the HeidiSQL

Download HeidiSQL from the installation files

Once you install the HeidiSQL create a new connection and name it "osTicket"

While setting up the connection it will ask you for a password, enter the password that you created at the installtion of MySQL

Once you are done with the setup go back to osTicket installer in the bowser and complete the Database connection information

Set the name as "osTicket"

Set the username and password same as mySQL

Install the osTicket

Congratulations! Your osTicket installation is sucessfully completed