OsTicket

From Alpine Linux

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»»

Install lighttpd, PHP, and MySql

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

Create a webapps folder

mkdir -p /usr/share/webapps/

Download the source code archive

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

Unpack the archive and delete the archive after

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

Change directory name

mv osticket_1.6.0 osticket

Create a 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/php5/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!

Final steps

  • Remove the installer
rm /usr/share/webapps/osticket/upload/include/setup/
chmod 644 /usr/share/webapps/osticket/upload/include/ost-config.php