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

Press Continue
9 - Enable configuration file

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

ost2 Press Continue
10 - Input system settings
ost3 11 - Input admin user data
ost4 12 - Input Database Settings from point 4
ost5 Press 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
ost7 15 - Log in
ost8 16 - Open first ticket
ost9 17 - Go to Admin panel / Dashboard / Information
ost10
18 - Remove setup directory, for security reason