Aerospace Software Ltd.

phpSupport Installation How-to Guide

For Mandriva Linux 10.2, 2005LE

August 2005

Scope

This guide describes the installation of phpSupport, a nice and simple trouble ticket system. When people have trouble, the last thing they need is a complicated ticket system, however, some systems are too simple!

This one strikes a good balance and you can create different classes of users, for clients and support staff, such that clients can create tickets, while staff can both create and modify tickets.

Install

You can get phpSupport here, http://phpsupport.jynx.net

For this program, you need Apache and MySQL - see my FreeRADIUS installation guide if you need help with that. I installed phpSupport a simple way, but with some security against modification by hackers. Save the tarball in /var/www/html and untar it:

# cd /var/www/html
# tar -xvf phpWupport-current.tar

For security, put config.php in/var/www/cgi-bin, then modify the paths in all .php files to point there.

MySQL Configuration

Create the database and the administrator user:

# mysql -uroot -ppassword
mysql> create database phpsupport;
mysql> use phpsupport;
mysql> grant all priveleges on phpsupport.* to
'supportadmin'@localhost identified by 'supportpassword' with grant option;
mysql> quit;

phpSupport Configuration

Run a browser and goto http://localhost/phpSupport/admin/index.html

Create at least two groups, for support and users, then add some users to both categories. When done, delete the admin directory.

From now on, you can go to http://localhost/phpSupport/index.html and log in.

Have fun!