This site will go offline starting with 01-JUL-2017 when web hosting contract expires, I don't have free time and interest anymore to maintain it. If someone wants to copy all tutorials and post them somewhere else like RMerlin Wiki, please do. Contact me for other packages or modules, like debian, minidlna, uvc...

osTicket through Optware-NG

Imagine this, a ticketing system running on a home router :)

1 - Setup Optware-NG from this guide and choose 2GB swap file
2 - Install Lighttpd and php from here
3 - Install mysql server using this guide
4 - Login to mysql shell to create osticket database, user and password (change values in red)

mysql -u root -p
mysql> create database osticket;
mysql> grant all privileges on osticket.* to osticket_db_username@localhost identified by 'osticket_db_password';
mysql> quit

5 - Install necessary packages:

ipkg install php-mysql php-mbstring php-gd php-imap php-intl

6 - Download and install latest version of osTicket

cd /opt/share/www/
wget http://osticket.com/sites/default/files/download/osTicket-v1.10.zip
unzip osTicket-v1.10.zip
mv ./upload ./osticket
rm -r scripts osTicket-v1.10.zip

7 - Fix timezone and restart lighttpd (change values in red if you want)

sed -i "s|;date.timezone =|date.timezone = Europe/Bucharest|g" "/opt/etc/php.ini"
/opt/etc/init.d/S80lighttpd restart

8 - Go to router default ip address and port :81/osticket or www.asusrouter.com:81/osticketost1

Press Continue
9
 - Enable configuration file

cp /opt/share/www/osticket/include/ost-sampleconfig.php /opt/share/www/osticket/include/ost-config.php

ost2Press Continue
10
 - Input system settings
ost3
11 - Input admin user data
ost412 - Input Database Settings from point 4
ost5Press Install Now
13 - Change config file permission
ost6

chmod 644 /opt/share/www/osticket/include/ost-config.php

14 - Go to administration page http://192.168.1.1:81/osticket/scp
ost715 - Log in
ost8
16 - Open first ticket
ost9
17 - Go to Admin panel / Dashboard / Information
ost10

18 - Remove setup directory, for security reason

rm -r /opt/share/www/osticket/setup

To access osTicket from WAN you don't need to input port 81 anymore, use www.your-wan-ip-address/osticket

Please use comments for help or just to leave a feedback...

  • Liviu Ioan

    Very interesting, thanks for this and not only

  • TeHashX

    Updated to v1.10-rc.3

SUBSCRIBE

To be notified by email when a new tutorial is posted :)

Thanks for Subscribing! I'll keeping you up-to-date with latest tutorials!

Something went wrong, try again...