2009
10.27
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
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
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
To get rid of the blank page problem you need to do yum install php-mysql.
thank u very much for u nice tutorial.
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.
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).
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.
Didn’t need ur help after all thanks for not answer. classy move.
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?
I have no experience doing that, but I guess you need to configure your mailserver to pipe mail to osTicket. See the osTicket wiki.
Thank you so much. Finally, I found very clear explanation on how to setup OSTicket. Really helpful for linux novice like me. :-).