Step by Step OsTicket setup and configuration

osTicket is an open source tool which is free to install and easy to configure. it is an great IT ticketing tool.this is a framework written in PHP language and utilizes MySql as database.

osTicket has below prerequisites:-

1. PHP (version 5.6 or above)

2. My sql database (version 5 or above)

3. Apache web server to deploy the osTicket application

Here we will use XAMPP for above installations. XAMPP is easy to use and contains all the required software we need.

XAMPP Includes: Apache 2.4.43, MariaDB 10.4.13, PHP 7.3.20, phpMyAdmin 5.0.2, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.105 (with mod_proxy_ajp as connector), Strawberry Perl 5.30.2.1 Portable  

Step 1 :- download page for  XAMPP for windows os.

               https://www.apachefriends.org/download.html

              For 64 bit windows OS, you can directly download from below url.

https://www.apachefriends.org/xampp-files/7.2.32/xampp-windows-x64-7.2.32-0-VC15-installer.exe

Step 2 :- Once the executable file is downloaded we can install its simple and straight forward.

             

above figure shows the list of servers, Programming Languages and API we can install.

Perl language can be skipped as it is not needed in this setup.

Step 3:- Once the installation is completed we can open the XAMPP control panel and start the apache and mysql 

Here first important thing we need to do is to set the mysql root password .

for that open the url http://localhost/phpmyadmin/index.php

 a. select mysql database and under that select user table.

b. here set the password for all root users 

Note :- Once we set the password the phpmyadmin configuration also needs to be changed 

 

for that open config.inc.php located in xampp\phpMyAdmin.

and update below auth type to cookie.

        $cfg['Servers'][$i]['auth_type'] = 'cookie';

save the change and restart apache and mysl from xampp.

step 4:- Download osTicket (LTS version) from the below link and extract.

                     https://osticket.com/download/

Once extracted copy the upload folder  (C:\Users\Ashu\Downloads\Compressed\osTicket-v1.14.2\osTicket-v1.14.2\upload)  and paste it in xampp\htdocs directory.

Step 5:- Now we can configure the osTicket. go to browser and enter the below url 

http://localhost/upload/

Step 6:- rename include/ost-sampleconfig.php to ost-config.php.

step 7:- create a new database in myql server from phpmyadmin page and provide it in configuration page. In my case i have created database osticketdb

click install now and it will add all the required tables in mentioned database.

Some of the important tables are :-

ost_user                    :- contains user information

ost_ticket    

ost_ticket_priority

ost_ticket_status

ost_help_topic

Step 8 :-

Below, you'll find some useful links regarding your installation.

Your osTicket URL: http://localhost/upload/	Your Admin/ Staff Control Panel: http://localhost/upload/scp
osTicket Forums: https://forum.osticket.com/	osTicket Documentation: https://docs.osticket.com/