A Raspberry Pi Ticketing System Image With osTicket!

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!

Download osTicketPi:

You Can Download v2.0 HERE(requires 8gb+ SD card)
.

To Install osTicketPi:

  1. Download win32DiskImager.
  2. Write image to SD Card.
  3. After initial Boot-up, Run “Sudo raspi-config” to expand the file system.

This slideshow requires JavaScript.

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:

2.) Run the usual updates:

 

3.) Install & Test Apache

From another PC on your network, Browse to your Pi’s IP address:

For Example:
http://192.168.1.24

Test_Apache_Install_Pi4.) Install MySQL

 

During the Install, You will get prompted to create a root password…

Install_MySQL_PW_Prompt

**In our case the root pw will be: !osTicket!

 

5.) Install PHP5

 

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.

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.

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:

 

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:

http://192.168.1.24/setup

osTicket_Setup_Prompt

 

10.) Configuration file missing!
osTicket_ConfigFile_Missing

During startup you will get prompted to rename your config file like so:

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.

osTicket_Admin_and_DB_Setup

 

12.) If everything goes smoothly you should be greeted by a congratulations screen.

osTicket_Cleanup

**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:

 

13.) When you first login, You will be prompted to remove the install directory…

 

14.) You will also want to delete the default index.html file, so that http://osTicket can load as the default.

 

 15.) That’s it! You should be able to browse to your 2 important osTicket interfaces now.

  • http://osticket/
  • http://osticket/scp

 

[/learn_more][learn_more caption=”Installing & Configuring Samba”]

 

1.) Install samba

 

2.) Next we need to configure our samba directory:

At the very end of the file, we want to add something like:

[osTicket]
     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.

 

2.) Next we need to alter the Apache configuration to include PHPmyadmin.

Scroll to very bottom of the file and add the following line:

Include /etc/phpmyadmin/apache.conf

Save the file. ( Ctrl + X  > Then Y to confirm )

 

3.) Now just restart the pache service:

 

4.) Now you should be able to access your MySQL database by accessing:

http://osticket/phpmyadmin

User: root
Pass: !osTicket!

[/learn_more]

 

 

Image Change Log:

osTicketPi – v1.0

  • Installed osTicket v1.8.1.2
  • 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.

 

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!

 

Pin It on Pinterest