OsTicket: Difference between revisions

From Alpine Linux
(Created page with "== What is 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 simpl...")
 
m (Categorized: PHP, SQL)
(8 intermediate revisions by 5 users not shown)
Line 1: Line 1:
== What is osTicket? ==
[http://osticket.com 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 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.


= Install lighttpd, PHP, and MySql =


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»»
<pre># apk add lighttpd php5-common php5-iconv php5-json php5-gd php5-curl php5-xml php5-pgsql php5-imap php5-cgi fcgi php5-pdo php5-pdo_pgsql php5-soap php5-xmlrpc php5-posix php5-mcrypt php5-gettext php5-ldap php5-ctype php5-dom php5-mysql mysql mysql-client php5-mysqli</pre>
= Configure lighttpd =


== Set up osTicket on Alpine Linux ==
<pre># vim /etc/lighttpd/lighttpd.conf</pre>
Uncomment line:


This document will be a quick c/p guide to setup osTicket on Alpine linux. What we will setup is the following:
<pre>include &quot;mod_fastcgi.conf&quot;</pre>
= Start lighttpd service and add to needed runlevel =


* Lighttpd with PHP
<pre># rc-service lighttpd start &amp;&amp; rc-update add lighttpd default</pre>
* MySql
= Installing and configuring osTicket =
* osTicket


== Install lighttpd, PHP, and MySql ==
Create a webapps folder
{{:Setting Up Lighttpd With FastCGI}}


Install extra packages:
<pre># mkdir -p /usr/share/webapps/</pre>
{{Cmd|apk add php-mysql mysql mysql-client}}
Get the source code


== Installing and configuring  osTicket ==
<pre># cd /var/www/localhost/htdocs
# wget http://osticket.com/sites/default/files/download/osTicket-v1.9.14.zip
# unzip osTicket-v1.9.14.zip
# rm *.zip</pre>
= Prepare the config file =


'''Install osTicket'''
<pre># cp /var/www/localhost/htdocs/include/ost-sampleconfig.php /var/www/localhost/htdocs/include/ost-config.php
# chmod 0666 /var/www/localhost/htdocs/include/ost-config.php</pre>
= Edit the php.ini =


Make webapps folder
<pre># vim /etc/php5/php.ini</pre>
Set:


{{Cmd|mkdir /usr/share/webapps/ -p}}
<pre>short_open_tag = On</pre>
Restart lighttpd


Download
<pre># /etc/init.d/lighttpd restart</pre>
= Config and start MariaDB =


{{Cmd|cd /usr/share/webapps/
<pre>/usr/bin/mysql_install_db --user=mysql
wget  http://osticket.com/dl/osticket_1.6.0.tar.gz}}
/etc/init.d/mariadb start &amp;&amp; rc-update add mariadb default
/usr/bin/mysqladmin -u root password 'password'</pre>
= Create the osTicket database =


Unpack
<pre>mysql -u root -p</pre>
<pre>CREATE DATABASE osticket;
GRANT ALL PRIVILEGES ON osticket.* TO 'osticket'@'localhost' IDENTIFIED BY 'osticket password';
FLUSH PRIVILEGES;
EXIT</pre>
= Config osTicket =


{{Cmd|tar zxvf osticket_1.6.0.tar.gz
Browse to http://WEBSERVER_IP_ADDRESS/ and set:
rm zxvf osticket_1.6.0.tar.gz}}


Change direcroty name
<pre>All fields are required.</pre>
osTicket web path and title


{{Cmd| mv osticket_1.6.0 osticket}}
<pre>Url to osTicket installation on your server and the title.
HelpDesk URL:
HelpDesk Title:</pre>
System email


Make symlinks to osTicket
<pre>Default system email (e.g support@yourdomain.com) You can change or add more emails later.
Default Email:</pre>
Admin user


{{Cmd|mv /var/www/localhost/htdocs/ /var/www/localhost/htdocs.old
<pre>Min of six characters for the password. You can change or add more users later.
ln -s /usr/share/webapps/osticket/upload/ /var/www/localhost/htdocs
Username:
}}
Password:
Password (again):
Email:</pre>
Database


== Prepare the config file ==
<pre>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</pre>
and click '''Install'''


{{Cmd| cp /usr/share/webapps/osticket/upload/include/ost-config.sample.php  /usr/share/webapps/osticket/upload/include/ost-config.php}}
After the '''Congratulations osTicket basic installation completed!.''' click '''Admin Panel''' -&gt; Login


== Edit the php.ini ==
After config all in the diferentes tabs, goto '''Settings''' tab and check '''Online''' on ''Helpdesk Status''


{{Cmd|vi /etc/php/php.ini}}
You have osTicket working!


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


short_open_tag = On
= Final steps =


Restart lighttpd
Remove the installer


{{Cmd| /etc/init.d/lighttpd restart
<pre># rm /usr/share/webapps/osticket/upload/include/setup/</pre>
}}
<pre># chmod 644 /usr/share/webapps/osticket/upload/include/ost-config.php</pre>
= Adding language support =


== Config and start MySql ==
You can add a new language by just downloading the <code>phar</code> file to <code>include/i18</code>


{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
Here is an example
/etc/init.d/mysql start && rc-update add mysql default
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}


'''Create the osTicket database'''
<pre># cd /var/www/localhost/htdocs/include/i18n
 
# wget http://osticket.com/sites/default/files/download/lang/pt_PT.phar</pre>
{{Cmd|mysql -u root -p}}
 
{{Cmd|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 access go to http://WEBSERVER_IP_ADDRESS/ and enjoy!


[[Category:Server | PHP | SQL ]]
[[Category:PHP]]
[[Category:SQL]]

Revision as of 01:30, 21 September 2017

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.

Install lighttpd, PHP, and MySql

# apk add lighttpd php5-common php5-iconv php5-json php5-gd php5-curl php5-xml php5-pgsql php5-imap php5-cgi fcgi php5-pdo php5-pdo_pgsql php5-soap php5-xmlrpc php5-posix php5-mcrypt php5-gettext php5-ldap php5-ctype php5-dom php5-mysql mysql mysql-client php5-mysqli

Configure lighttpd

# vim /etc/lighttpd/lighttpd.conf

Uncomment line: 

include "mod_fastcgi.conf"

Start lighttpd service and add to needed runlevel

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

Installing and configuring osTicket

Create a webapps folder 

# mkdir -p /usr/share/webapps/

Get the source code 

# cd /var/www/localhost/htdocs
# wget http://osticket.com/sites/default/files/download/osTicket-v1.9.14.zip
# unzip osTicket-v1.9.14.zip
# rm *.zip

Prepare the config file

# cp /var/www/localhost/htdocs/include/ost-sampleconfig.php /var/www/localhost/htdocs/include/ost-config.php
# chmod 0666 /var/www/localhost/htdocs/include/ost-config.php

Edit the php.ini

# vim /etc/php5/php.ini

Set: 

short_open_tag = On

Restart lighttpd 

# /etc/init.d/lighttpd restart

Config and start MariaDB

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

Adding language support

You can add a new language by just downloading the phar file to include/i18

Here is an example 

# cd /var/www/localhost/htdocs/include/i18n
# wget http://osticket.com/sites/default/files/download/lang/pt_PT.phar
Retrieved from "https://wiki.alpinelinux.org/w/index.php?title=OsTicket&oldid=13900"