Setup Web-based Help Desk System Using SiT! On Debian 7 Wheezy
SiT!, Support Incident Tracker, is a Free, Open Source web based ‘Help Desk’ or ‘Support Ticket System’ application which uses PHP and MySQL for tracking technical support calls/emails. SiT! can be used to manage contacts, sites, technical support contracts and support incidents in one place. Also we can send emails directly from SiT!, attach files and record every communication in the incident log. SiT is aware of Service Level Agreements and incidents are flagged if they stray outside of them.
- Web based, easy to install, configure and use.
- Configurable service levels (SLA’s).
- Tracks all inbound and outbound emails.
- LDAP Integration (Support for Active Directory, eDirectory, openLDAP).
- Support for over 19+ languages.
You should have a working LAMP installation in your Debian server. Please follow the below link to install LAMP server in Debian 7 Wheezy.
Also make sure that you have installed the following php extensions.
To install the above extensions, enter the below command in Terminal.
apt-get install php5-mysql libpcre3 libpcre3 php5-xmlrpc php5-imap php5-cli php5-gd php5-common
Create Database for SiT!
Let us create a database called ‘sitdb’, database user ‘situser’ with password ‘debian’.
Login to mysql using command:
mysql -u root -p
Enter the commands one by one to create database, database user and password.
mysql> create database sitdb; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL ON sitdb.* TO situser@localhost IDENTIFIED BY 'debian'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
Download the latest from here. To download from directly from Terminal, enter the following command.
Extract it using command:
tar -zxvf sit_3.67p2.tar.gz
Copy the extracted files to apache root document folder.
cp -R sit-3.67/ /var/www/sit
Open web browser and navigate to http://ip-address/sit or http://domain-name/sit. You should see the following like screen.
Enter your MySQL database details and click Save configuration.
Now you will get a message like in the following screenshot. This means that SiT! can’t write the configuration in /var/www/sit/config.inc.php file due to permission problem. If SiT cannot write the config file automatically it will print a message “Could not write…” as shown in the image below.
Copy the contents of box in the above image.
<?php # config.inc.php - SiT! Config file generated automatically by setup.php on Thu, 31 Oct 2013 11:10:53 +0530 # Web Path # The path to SiT! from the browsers perspective with a trailing slash. e.g. /sit/ $CONFIG['application_webpath'] = '/sit/'; # MySQL Database Username $CONFIG['db_username'] = 'situser'; # MySQL Database Password $CONFIG['db_password'] = 'debian'; # MySQL Database Name $CONFIG['db_database'] = 'sitdb'; # Attachment Filesystem Path # The full absolute file system path to a directory to store attachments in (with a trailing slash). This directory should be writable $CONFIG['attachment_fspath'] = '/var/www/sit/attachments-544d2acec01f42a9a6599981837d9613c1202dc7/';
Save and close the file. After the creating the file click on the Next button.
Now you will be able to successfully connected to your database. Click Next to continue.
Now click Next button to continue.
chmod ugo+wx /var/www/sit/attachments-544d2acec01f42a9a6599981837d9613c1202dc7/
Click Next to continue.
Now your new Help Desk system is ready to use. Head over to official help documentation page to know how to use SiT!. I believe usage of SiT! is not that difficult. You can easily learn how to use it if you go through the couple of pages in the official help manual. Cheers!
Like us on Facebook
This week Top Posts
- Top Things To Do After Installing Ubuntu 13.10 'Saucy Salamander' : Ubuntu 13.10 Saucy Salamander will be released on coming October 17th with many new salient featur...0 comments |
- Manage Databases And Hosted Servers Remotely With DbNinja : Database administration via command line is bit difficult for newbie system and database administrat...0 comments |
- Install Sayonara Player In Elementary OS / Ubuntu / Linux Mint : Sayonara is a small, clear and fast audio player for Linux written in C++, supported by the Qt frame...0 comments |
- How To Install Linux Kernel 3.12.4 In Ubuntu : Linux Kernel 3.12.4 has been officially released with fixes for inet6_init() cleanup order, seqlock ...0 comments |
- How To Upgrade From Ubuntu 13.04 Raring To Ubuntu 13.10 Saucy Salamander : Ubuntu 13.10 Saucy will be released on October 17th. Hope it will come with lot of improvements and ...0 comments |
- Firefox 26 Has Been Released, How To Install It In Ubuntu And Its Derivates : Hi guys, Firefox 26 has been released for Windows, Mac OS X, Linux and Android devices. It brings m...0 comments |
- How To Install Linux Kernel 3.12.4 In Ubuntu
- Firefox 26 Has Been Released, How To Install It In Ubuntu And Its Derivates
- How To Install Brasero In Elementary OS ‘Luna’
- Install Sayonara Player In Elementary OS / Ubuntu / Linux Mint
- Manage Databases And Hosted Servers Remotely With DbNinja
- Install FrostWire 5.6.9 In Elementary OS ‘Luna’/ Ubuntu / Linux Mint
- Setup IT And Asset Management System With GLPI On Debian/Ubuntu
- How To Configure Linux Clients To Authenticate Using OpenLDAP
- How To Install Netflix In Ubuntu
- cowsay And fortune Combined Together
This work by unixmen.com is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Copyright © 2008-2013 Unixmen.com .