How to configure osTicket, An Open Source Support Ticket System

Configuring MySQL for osTicket

At first we have to configure apache, php, mysql support web server, we can follow this link
Web Server configuration on Centos 6.5

Now, log in to the MySQL console and create a database for the osTicket.

#mysql -u root -p

This will prompt you for a password, so enter your MySQL root password and hit Enter. Then, Create the database for osTicket and assign proper permission.

mysql> create database osticketdb;

Query OK, 1 row affected (0.01 sec)

mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Query OK, 0 rows affected (0.00 sec);

mysql> grant all on osticketdb.* TO 'osticketuser'@'localhost';

Query OK, 0 rows affected (0.00 sec)

Mysql> grant all on osticket.* to username@localhost identified by 'password' #for existing user

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

Downloading osTicket installation script

Go to the Apache root directory:

#cd /var/www/html

Download osTicket latest version from the official download page.

#wget http://osticket.com/sites/default/files/download/osTicket-v1.9.8.1.zip

Create a directory called ‘osticket’ and extract the zip in it.

#mkdir osticket

#unzip osTicket-v1.9.8.1.zip -d osticket

Change html/osticket folder permissions:

Finally, restart the Apache service.

#service httpd restart

#chkconfig httpd restart

Step 6. Accessing osTicket.. And See the Installation wizard has been started.. Open your favorite browser and navigate to

http://yourdomain.com/osticket/upload or http://server-ip/osticket/upload.

On this page click on continue

#cd /var/www/html/osticket

#cd upload/include

#cp ost-sampleconfig.php ost-config.php

Now change permission:

As I mentioned above, configuration file is not writable. So change the file permission from 0644 to 0666 then hit Done, Continue button.

#chmod 0664 include/ost-config.php

How to configure osTicket mail setting.

In this case we have osTicket installed, and we would like to configure the software to automatically send/recieve email using a designated mailbox, in this case

First things first, enable the email configuration, go to Admin Panel > Settings > Emails

set the email configuration to be enabled for osTicket