2009
10.27

First we have to download osTicket and make it a available via http:

cd /var/www
wget http://osticket.com/dl/osticket_1.6.rc5.tar.gz
tar -xzvf osticket_1.6.rc5.tar.gz
ln -s /var/www/osticket_1.6.rc5/upload /var/www/html/osticket

Then we create a database by means of the MySQL client:

mysql>
CREATE USER 'osticket'@'localhost' IDENTIFIED BY '****************';

GRANT USAGE ON * . * TO 'osticket'@'localhost' IDENTIFIED BY '****************'
	WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
	MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `osticket` ;

GRANT ALL PRIVILEGES ON `osticket` . * TO 'osticket'@'localhost';

FLUSH PRIVILEGES;

Change the owner of the osticket folder,

cd /var/www
chown -R apache:apache osticket_1.6.rc5

because include/settings.php must be writable for the installer (user: apache).

Access the installer through http://192.168.1.1/osticket and fill in the right data (e.g. MySQL username and password)

Finally, follow the suggestions of the installer:

  • Change permission of include/settings.php to remove write access
  • Delete or move setup directory
cd /var/www
chown -R root:root osticket_1.6.rc5
cd osticket_1.6.rc5
mv setup _setup

Optional (for password encryption):

yum install php-mcrypt

11 comments so far

Add Your Comment
  1. Mischa ter Smitten

    When access http://localhost/osticket during installtion and fill in form and click install, The next page I receive is the blank page. Please guide me about the fields to be filled in http://localhost/osticket/setup/install.php I am not sure about database name, username and password

  2. Mischa ter Smitten

    Please have a look in your Apache error_log. Maybe there’s some information there. Also make sure that error_reporting is set to E_ALL in your PHP configuration. This should give you inside in whats going on. P.S. make sure to disable it later on.

    About the database configuration page. I created a user called `osticket` with a database called `osticket` by PHPMyAdmin. So if you followed my guide you would end up filling in:

    Host: localhost
    Port: 3306
    Database: osticket
    Username: osticket
    Password: whateveryouchoose

  3. Mischa ter Smitten

    To get rid of the blank page problem you need to do yum install php-mysql.

  4. Mischa ter Smitten

    thank u very much for u nice tutorial.

  5. Mischa ter Smitten

    I have done everything requested and its ton easier than anything else I’ve read, but I do have a slight issue. When I go to 192.168.1.1/osticket, I get “page not found”. I have tried several times with the same result. any help would be appreciated.

  6. Mischa ter Smitten

    Does apache listen on 192.168.1.1? Use ifconfig to find your server’s ip address and make sure apache listens on that address (netstat -tap | grep www).

  7. Mischa ter Smitten

    I should have prefaced by telling you I’m still learning linux… in short, I’m a noob. I have changed the httpd.conf file to listen to “my IP address” and “192.168.1.1”. Its my understanding you wanted me to have httpd listen to my ip address and I left it as such.
    However, I am still getting “page not found”… I believe bcause of my noob-ness, I am missing some sort of configuiration. thanks for the help.

  8. Mischa ter Smitten

    Didn’t need ur help after all thanks for not answer. classy move.

  9. Mischa ter Smitten

    Many thanks for the How-To.

    Do you know how I can configure OSticket so that users can send an email and then OSticket
    can create a ticket automatically?

  10. Mischa ter Smitten

    I have no experience doing that, but I guess you need to configure your mailserver to pipe mail to osTicket. See the osTicket wiki.

  11. Mischa ter Smitten

    Thank you so much. Finally, I found very clear explanation on how to setup OSTicket. Really helpful for linux novice like me. :-).