Sunday, 1 November 2015

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

Downloading osTicket installation script
Go to the Apache root directory:
#cd /var/www/html
Download osTicket latest version from the official download page.

Create a directory called ‘osticket’ and extract the zip in it.
#mkdir osticket
#unzip -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 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

Save setting, 

Now configure email id, password and other setting. 
from here browse to  Admin Panel > emails

select/add the email address you would like to associate with osTicket.

Done...! Enjoy open source...

1 comment:

  1. how to remove email field from create new ticket, if possiable please help me to do this