OsTicket

osTicket is a widely-used open source support ticket system. It seamlessly integrates inquiries created via email, phone and web-based forms into a simple easy-to-use multi-user web interface. Manage, organize and archive all your support requests and responses in one place while providing your customers with accountability and responsiveness they deserve.

osTicket is an attractive alternative to higher-cost and complex customer support systems; simple, lightweight, reliable, open source, web-based and easy to setup and use. The best part is, it's completely free. learn more»»

Set up osTicket on Alpine Linux

This document will be a quick c/p guide to setup osTicket on Alpine linux. What we will setup is the following:

• Lighttpd with PHP
• MySql
• osTicket

Basic Installation

For installing the additional packages first activate community packages and update the package index

Install the required packages:

# apk add lighttpd php82 fcgi php82-cgi

Configure Lighttpd

Edit lighttpd.conf (/etc/lighttpd/lighttpd.conf) and uncomment the line:

Contents of /etc/lighttpd/lighttpd.conf

... include "mod_fastcgi.conf" ...

Edit mod_fastcgi.conf (/etc/lighttpd/mod_fastcgi.conf), find and change /usr/bin/php-cgi to /usr/bin/php-cgi82.

Contents of /etc/lighttpd/mod_fastcgi.conf

... "bin-path" => "/usr/bin/php-cgi82" # php-cgi ...

Start lighttpd service and add it to default runlevel

# rc-service lighttpd start # rc-update add lighttpd default

Install extra packages:

apk add php-mysql mysql mysql-client

Installing and configuring osTicket

Install osTicket

Make webapps folder

mkdir /usr/share/webapps/ -p

Download

cd /usr/share/webapps/ wget http://osticket.com/dl/osticket_1.6.0.tar.gz

Unpack

tar zxvf osticket_1.6.0.tar.gz rm zxvf osticket_1.6.0.tar.gz

Change direcroty name

mv osticket_1.6.0 osticket

Make symlinks to osTicket

mv /var/www/localhost/htdocs/ /var/www/localhost/htdocs.old ln -s /usr/share/webapps/osticket/upload/ /var/www/localhost/htdocs

Prepare the config file

cp /usr/share/webapps/osticket/upload/include/ost-config.sample.php /usr/share/webapps/osticket/upload/include/ost-config.php

Edit the php.ini

vi /etc/php/php.ini

• Set:

short_open_tag = On

Restart lighttpd

/etc/init.d/lighttpd restart

Config and start MySql

/usr/bin/mysql_install_db --user=mysql /etc/init.d/mysql start && rc-update add mysql default /usr/bin/mysqladmin -u root password 'password'

Create the osTicket database

mysql -u root -p

CREATE DATABASE osticket; GRANT ALL PRIVILEGES ON osticket.* TO 'osticket'@'localhost' IDENTIFIED BY 'osticket password'; FLUSH PRIVILEGES; EXIT

Config your osTicket

Browse to: http://WEBSERVER_IP_ADDRESS/ and set:

All fields are required.

• osTicket web path and title

Url to osTicket installation on your server and the title.
HelpDesk URL:	
HelpDesk Title:	 

• System email

Default system email (e.g support@yourdomain.com) You can change or add more emails later.
Default Email:	 

• Admin user

Min of six characters for the password. You can change or add more users later.
Username: 	 
Password: 	 
Password (again): 	 
Email:	 

• Database

MySQL (version 4.4+) is the only database supported at the moment.
MySQL Table Prefix: ost_
MySQL Hostname: localhost
MySQL Database: osticket
MySQL Username: root
MySQL Password: password	

and click in Install

After the Congratulations osTicket basic installation completed!. click Admin Panel

• Login

After config all in the diferentes tabs, goto Settings tab and check Online on Helpdesk Status

You have osTicket working!

• To add a ticket: http://WEBSERVER_IP_ADDRESS/
• To administrate: http://WEBSERVER_IP_ADDRESS/scp/login.php

Final steps

• Remove the installer

rm /usr/share/webapps/osticket/upload/include/setup/

chmod 644 /usr/share/webapps/osticket/upload/include/ost-config.php