For anyone not familiar with osTicket, It is a fantastic and Free HelpDesk ticketing system. When I originally covered osTicket – The one thing that I kept thinking to myself was ” I wish I could just create an image to share with people to make this easier “. Enter the Raspberry Pi, Not only is it easy to create & share SD card images for the Pi – But there is a great community built around the Pi and with it a wealth of knowledge to draw from. What makes this project so great, is that you can simply download the osTicket-Pi image and load it onto your PI and away you go. No lengthy setup/troubleshooting process before you can Demo osTicket and for any IT department on a shoestring budget – the hardware couldn’t be cheaper! Literally, within just a few minutes you can be booting up a working version of osTicket to start logging tickets!
You Can Download v2.0 HERE. (requires 8gb+ SD card)
To Install osTicketPi:
- Download win32DiskImager.
- Write image to SD Card.
- After initial Boot-up, Run “Sudo raspi-config” to expand the file system.
About The Image:
- Samba is installed and the /var/www directory is shared.
- Overclocked to “Medium” Setting
- SSH = pi/raspberry
- osTicket Login = osadmin / !osTicket!
- PHPmyadmin = root / !osTicket!
- To Access osTicket:
1.) Run ifconfig to get the Pi’s IP address
2.) Customer Page: http://ipaddress
3.) Admin Page: http://ipaddress/scp
4.) PHPmyadmin: http://ipaddress/phpmyadmin
**Alternatively You can try: http://osticket
In true EDT fashion, I’ve also detailed my install process for osTicketPi below…[learn_more caption=”Installing osTicket v1.8″]
Installing osTicket v1.8
1.) Download & Install The latest Raspbian Wheezy Image:
- Download: http://www.raspberrypi.org/downloads/
- Install: http://sourceforge.net/projects/win32diskimager/files/latest/download
2.) Run the usual updates:
sudo apt-get update
sudo apt-get upgrade
3.) Install & Test Apache
sudo apt-get install apache2
#For Good Measure, Restart the Service Right away
sudo /etc/init.d/apache2 restart
From another PC on your network, Browse to your Pi’s IP address:
sudo apt-get install mysql-server-5.5
During the Install, You will get prompted to create a root password…
**In our case the root pw will be: !osTicket!
5.) Install PHP5
sudo apt-get install php5
sudo apt-get install php5-mysql
sudo apt-get install php5-gd
sudo apt-get install php5-imap
6.) Once all that is done, We can run the MySQL install script:
7.) Next we need to create our osTicket Database and User information.
mysql -u root -p
This should drop you in a mysql> prompt. Copy & paste the below information to create our osTicket Databse and create create/configure our MySQL user account.
CREATE DATABASE osTicket
CREATE USER 'root'@'localhost'
SET PASSWORD FOR 'root'@'localhost'= PASSWORD('!osTicket!')
GRANT ALL PRIVILEGES ON *.* TO osadmin@localhost IDENTIFIED BY '!osTicket!' WITH GRANT
When you are done, simply type \q to drop back into command line.
**If you need to access this command line interface in the future, you can do so by using:
mysql -u osadmin -p
#When Prompted... password = !osTicket!
8.) Download & Extract latest version of osTicket to /var/www
This one took some ingenuity… But if you really want to know – This is how I did it:
- Download the .zip file for osticket HERE.
- Extract contents
- sudo mkdir /home/pi/osticket
- sudo chmod 777 /home/pi/osticket
- FTP to /home/pi/osticket
- Copy contents of extracted osticket folder to /home/pi/osticket
- cd /home/pi/osticket/upload
- sudo mv * /var/www
9.) Next You want to Browse to the following directory to begin setup:
During startup you will get prompted to rename your config file like so:
cp include/ost-sampleconfig.php include/ost-config.php
#While we are here, We also want to make the config file writeable
sudo chmod 0666 include/ost-config.php
Click “Continue” To move to the next part of setup…
11.) Here you will want to setup your Admin account information and enter your MySQL database details.
12.) If everything goes smoothly you should be greeted by a congratulations screen.
**You will also want to take note of the links on this page!
After the install is complete, they recommend reverting permissions for the following config file:
chmod 0664 /var/www/include/ost-config.php
13.) When you first login, You will be prompted to remove the install directory…
sudo rm -rf /var/www/setup
14.) You will also want to delete the default index.html file, so that http://osTicket can load as the default.
sudo rm /var/www/index.html
15.) That’s it! You should be able to browse to your 2 important osTicket interfaces now.
[/learn_more][learn_more caption=”Installing & Configuring Samba”]
1.) Install samba
sudo apt-get install samba
sudo apt-get install samba-common-bin
2.) Next we need to configure our samba directory:
sudo nano /etc/samba/smb.conf
At the very end of the file, we want to add something like:
comment = osTicket
path = /var/www/
force user = pi
force group = users
guest ok = yes
read only = no
Then Save and Exit ( Ctrl + X > Y to confirm save )
3.) You should then be able to connect to your samba share via:
\\osticket\[/learn_more][learn_more caption=”Installing PHPmyadmin”]
1.) Install phpmyadmin.
sudo apt-get install phpmyadmin
2.) Next we need to alter the Apache configuration to include PHPmyadmin.
sudo nano /etc/apache2/apache2.conf
Scroll to very bottom of the file and add the following line:
Save the file. ( Ctrl + X > Then Y to confirm )
3.) Now just restart the pache service:
sudo /etc/init.d/apache2 restart
4.) Now you should be able to access your MySQL database by accessing:
Image Change Log:
osTicketPi – v1.0
- Installed osTicket v184.108.40.206
- Added Samba Share for osTicket files
- Set hostname to “osTicket”
- Installed PHPmyadmin
Ideas For osTicketPi – v1.1
Add customizations from previous osTicket Guide Use Gparted to shrink image size Add RaspControl
- ?? (Suggest something cool in the comments!)
osTicketPi – v2.0
- Updated to be compatible with new Raspberry Pi Models.
**It should be noted that this build uses the free, self-hosted version of osTicket. If you are looking for a fully supported cloud hosted HelpDesk Ticketing system – You can check out osTickets full product line HERE.
For additional configuration tips and information I recommend checking out some of my other related Blog Posts.
- Windows osTicket Install & Customizations Guide
- UltraSlim Image Guide – For Static IP address/overclocking setup
If you have any further questions or would like to see additional features show up in a later version – Please drop me a comment below!