OsTicket: Difference between revisions

From Alpine Linux
mNo edit summary
(replace /etc/init.d with rc-service)
 
(14 intermediate revisions by 7 users not shown)
Line 1: Line 1:
[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.
[https://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 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»»
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.


== Set up osTicket on Alpine Linux ==
= Install lighttpd, PHP, and MySql =


This document will be a quick c/p guide to setup osTicket on Alpine linux. What we will setup is the following:
{{cmd|# 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 =


* Lighttpd with PHP
{{cmd|# vim /etc/lighttpd/lighttpd.conf}}
* MySql
Uncomment line:
* osTicket


== Install lighttpd, PHP, and MySql ==
<pre>include &quot;mod_fastcgi.conf&quot;</pre>
{{:Setting Up Lighttpd With FastCGI}}
= Start lighttpd service and add to needed runlevel =


Install extra packages:
{{cmd|# rc-service lighttpd start &amp;&amp; rc-update add lighttpd default}}
{{Cmd|apk add php-mysql mysql mysql-client}}
= Installing and configuring osTicket =


== Installing and configuring  osTicket ==
Create a webapps folder


'''Install osTicket'''
{{cmd|# mkdir -p /usr/share/webapps/}}
Get the source code


Make webapps folder
{{cmd|# cd /var/www/localhost/htdocs
wget <nowiki>https://osticket.com/sites/default/files/download/osTicket-v1.9.14.zip</nowiki>
unzip osTicket-v1.9.14.zip
rm *.zip}}


{{Cmd|mkdir /usr/share/webapps/ -p}}
= Prepare the config file =


Download
{{cmd|# 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}}


{{Cmd|cd /usr/share/webapps/
= Edit the php.ini =
wget  http://osticket.com/dl/osticket_1.6.0.tar.gz}}


Unpack
{{cmd|# vim /etc/php5/php.ini}}
 
Set:
{{Cmd|tar zxvf osticket_1.6.0.tar.gz
rm zxvf osticket_1.6.0.tar.gz}}
 
Change direcroty name
 
{{Cmd| mv osticket_1.6.0 osticket}}
 
Make symlinks to osTicket
 
{{Cmd|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 ==
 
{{Cmd| cp /usr/share/webapps/osticket/upload/include/ost-config.sample.php  /usr/share/webapps/osticket/upload/include/ost-config.php}}
 
== Edit the php.ini ==
 
{{Cmd|vi /etc/php/php.ini}}
 
* Set:
 
short_open_tag = On


<pre>short_open_tag = On</pre>
Restart lighttpd
Restart lighttpd


{{Cmd| /etc/init.d/lighttpd restart
{{cmd|# rc-service lighttpd restart}}
}}
= Config and start MariaDB =


== Config and start MySql ==
<pre>/usr/bin/mysql_install_db --user=mysql
rc-service mariadb start &amp;&amp; rc-update add mariadb default
/usr/bin/mysqladmin -u root password 'password'</pre>
= Create the osTicket database =


{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
{{cmd|mysql -u root -p}}
/etc/init.d/mysql start && rc-update add mysql default
<pre>CREATE DATABASE osticket;
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}
GRANT ALL PRIVILEGES ON osticket.* TO 'osticket'@'localhost' IDENTIFIED BY 'osticket password';
FLUSH PRIVILEGES;
EXIT</pre>


'''Create the osTicket database'''
= Config osTicket =


{{Cmd|mysql -u root -p}}
Browse to <nowiki>http://WEBSERVER_IP_ADDRESS/</nowiki> and set:


{{Cmd|CREATE DATABASE osticket;
<pre>All fields are required.</pre>
GRANT ALL PRIVILEGES ON osticket.* TO 'osticket'@'localhost' IDENTIFIED BY 'osticket password';
osTicket web path and title
FLUSH PRIVILEGES;
EXIT}}


== Config your osTicket ==
<pre>Url to osTicket installation on your server and the title.
HelpDesk URL:
HelpDesk Title:</pre>
System email


Browse to: http://WEBSERVER_IP_ADDRESS/ and set:
<pre>Default system email (e.g support@yourdomain.com) You can change or add more emails later.
Default Email:</pre>
Admin user


All fields are required.
<pre>Min of six characters for the password. You can change or add more users later.
Username:
Password:
Password (again):
Email:</pre>
Database


* osTicket web path and title
<pre>MySQL (version 4.4+) is the only database supported at the moment.
Url to osTicket installation on your server and the title.
MySQL Table Prefix: ost_
HelpDesk URL:
MySQL Hostname: localhost
HelpDesk Title:
MySQL Database: osticket
MySQL Username: root
MySQL Password: password</pre>
and click '''Install'''


* System email
After the '''Congratulations osTicket basic installation completed!.''' click '''Admin Panel''' -&gt; Login
Default system email (e.g support@yourdomain.com) You can change or add more emails later.
Default Email:


* Admin user
After config all in the diferentes tabs, goto '''Settings''' tab and check '''Online''' on ''Helpdesk Status''
Min of six characters for the password. You can change or add more users later.
Username:
Password:
Password (again):
Email:


* Database
You have osTicket working!
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'''
* To add a ticket: <nowiki>http://WEBSERVER_IP_ADDRESS/</nowiki>
* To administrate: <nowiki>http://WEBSERVER_IP_ADDRESS/scp/login.php</nowiki>


= Final steps =


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


* Login
{{cmd|# rm /usr/share/webapps/osticket/upload/include/setup/
After config all in the diferentes tabs, goto '''Settings''' tab and check '''Online''' on ''Helpdesk Status''
chmod 644 /usr/share/webapps/osticket/upload/include/ost-config.php}}


You have osTicket working!
= Adding language support =
* To add a ticket: http://WEBSERVER_IP_ADDRESS/
* To administrate: http://WEBSERVER_IP_ADDRESS/scp/login.php


== Final steps ==
You can add a new language by just downloading the <code>phar</code> file to {{path|include/i18}}


* Remove the installer
Here is an example


rm /usr/share/webapps/osticket/upload/include/setup/
{{cmd|# cd /var/www/localhost/htdocs/include/i18n
wget <nowiki>https://osticket.com/sites/default/files/download/lang/pt_PT.phar</nowiki>}}


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


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

Latest revision as of 10:27, 17 November 2023

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

# rc-service lighttpd restart

Config and start MariaDB

/usr/bin/mysql_install_db --user=mysql
rc-service 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!

  • 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

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 https://osticket.com/sites/default/files/download/lang/pt_PT.phar