Difference between revisions of "OsTicket"

From Alpine Linux
Jump to: navigation, search
(Config and start MySql)
Line 7: Line 7:
  
 
Install extra packages:
 
Install extra packages:
{{Cmd|apk add php-mysql mysql mysql-client}}
+
{{Cmd|apk add php5-mysql mysql mysql-client}}
  
 
= Installing and configuring osTicket =
 
= Installing and configuring osTicket =

Revision as of 13:34, 14 October 2016

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

For installing the additional packages first activate community packages:

vi /etc/apk/repositories

Uncomment the following:

http://pkg.example.com/alpine/v3.9/community

Update the packagelist:

apk update

Install the additional packages:

apk add lighttpd php7-common php7-iconv php7-json php7-gd php7-curl php7-xml php7-mysqli php7-imap php7-cgi fcgi php7-pdo php7-pdo_mysql php7-soap php7-xmlrpc php7-posix php7-mcrypt php7-gettext php7-ldap php7-ctype php7-dom

Configure Lighttpd

Edit lighttpd.conf

vi /etc/lighttpd/lighttpd.conf

Uncomment line:

include "mod_fastcgi.conf"


Edit mod_fastcgi.conf

vi /etc/lighttpd/mod_fastcgi.conf

Edit the section:

/usr/bin/php-cgi

To:

/usr/bin/php-cgi7

Start lighttpd service and add to needed runlevel

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

Install extra packages:

apk add php5-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/mariadb start && rc-update add mariadb 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