Koozali.org: home of the SME Server

Getting the current 1.10 osTicket to run in an ibay

Offline tolistim

  • *
  • 27
  • +0/-0
Getting the current 1.10 osTicket to run in an ibay
« on: May 11, 2018, 01:02:51 AM »
Hi Folks,

I've searched and read through the limited entries here for getting older versions of osTicket running on SME/Koozali, but they don't seem to apply to SME-9 and the newer 1.10 version of osTicket.

What I've tried up to this point:

  • Created a new iBay named tickettest
  • Extracted the osTicket ZIP file into tickettest/html
  • Moved the contents of the osticket upload folder to the top level html folder
  • Set owner and group to www.apache for the entire iBay
  • Set up the MySQL database and permissions
  • Executed "signal-event ibay-modify tickettest" and
    "/etc/rc.d/init.d/httpd-e-smith restart"
Now, when I go to https://tickettest.mydomain.com/setup/, I get a blank page and there is no source shown in the Firefox source window.  In the access_log, I see a 500 error every time I tried to access the /setup/ folder.

Has anyone gotten osTicket 1.10 working in an iBay in SME-9?

Offline warren

  • *
  • 291
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #1 on: May 11, 2018, 11:29:59 AM »
Hi Folks,

I've searched and read through the limited entries here for getting older versions of osTicket running on SME/Koozali, but they don't seem to apply to SME-9 and the newer 1.10 version of osTicket.

What I've tried up to this point:

  • Created a new iBay named tickettest
  • Extracted the osTicket ZIP file into tickettest/html
  • Moved the contents of the osticket upload folder to the top level html folder
  • Set owner and group to www.apache for the entire iBay
  • Set up the MySQL database and permissions
  • Executed "signal-event ibay-modify tickettest" and
    "/etc/rc.d/init.d/httpd-e-smith restart"
Now, when I go to https://tickettest.mydomain.com/setup/, I get a blank page and there is no source shown in the Firefox source window.  In the access_log, I see a 500 error every time I tried to access the /setup/ folder.

Has anyone gotten osTicket 1.10 working in an iBay in SME-9?

Just Followed the wiki howto  https://wiki.contribs.org/Osticket  and it installs in /opt
why change it ?

the following steps / sections not in wiki :
Quote
changes / deviation from wiki :
===============================

osTicket installer needs to be able to write and modify ostconfig.php found in the upload's root directory. Change the permission settings for the ostconfig.php file so that it is writable by the webserver.

cd /opt/osticket/upload/include   !! not in wiki

cp ost-sampleconfig.php ostconfig.php   !!! the ostconfig.php is not present so need to create it from the sample one

chmod 777 /opt/osticket/upload/include/ost-config.php



Finishing Up

If the setup script has finished running with no errors, then congratulations osTicket is installed. Your next step should be to fully configure your new support ticket system for use, but before you get to it please take a second to cleanup.

Change permission of ostconfig.php to 644

Delete install directory.
 
cd /opt/osticket/upload/include   !!wiki==>cd /opt/osticket/upload

chmod 644 ostconfig.php


cd /opt/osticket/upload      !! not in wiki

rm -rf /opt/osticket/upload/setup


Offline tolistim

  • *
  • 27
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #2 on: May 11, 2018, 11:43:45 PM »
Just Followed the wiki howto  https://wiki.contribs.org/Osticket  and it installs in /opt
why change it ?
We use the iBays to keep differing parts of our web presence separate.  Installing into /opt removes that separation and modifies the SME convention away from the norm making it more difficult to manage if we change staff or systems.

I will take your added notes about the "/opt" install and try them within an iBay making the appropriate changes to the template.
« Last Edit: May 11, 2018, 11:54:17 PM by tolistim »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #3 on: May 12, 2018, 02:51:57 AM »
AFAIAA there is no real need to use /opt these days.

This can help if you want to

https://wiki.contribs.org/Webapps-common

For your 500 error it does seem most like a perms error and likely a chmod as indicated should reap dividends.

Also check the phpbasebir etc

https://wiki.contribs.org/Useful_Commands under Apache

...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline tolistim

  • *
  • 27
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #4 on: May 12, 2018, 03:35:51 AM »
AFAIAA there is no real need to use /opt these days.
That's my point.  I want to keep things in iBays, so the Webapps contrib isn't really something I would want to implement.

What I meant by the above is that some have gotten osTicket running properly in the /opt folder and @warren provided some additional information beyond what I'd previously found in my searching.

I'm taking that additional info relating to the /opt config and applying it to an iBay config.

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #5 on: May 12, 2018, 03:39:06 AM »
I was just noting the options :-)

Let us know if you get it running or get stuck.

...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline warren

  • *
  • 291
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #6 on: May 14, 2018, 08:56:52 PM »
Hi Folks,

I've searched and read through the limited entries here for getting older versions of osTicket running on SME/Koozali, but they don't seem to apply to SME-9 and the newer 1.10 version of osTicket.

What I've tried up to this point:

  • Created a new iBay named tickettest
  • Extracted the osTicket ZIP file into tickettest/html
  • Moved the contents of the osticket upload folder to the top level html folder
  • Set owner and group to www.apache for the entire iBay
  • Set up the MySQL database and permissions
  • Executed "signal-event ibay-modify tickettest" and
    "/etc/rc.d/init.d/httpd-e-smith restart"
Now, when I go to https://tickettest.mydomain.com/setup/, I get a blank page and there is no source shown in the Firefox source window.  In the access_log, I see a 500 error every time I tried to access the /setup/ folder.

Has anyone gotten osTicket 1.10 working in an iBay in SME-9?

So here is what i did in Ibay and it looks all good :

Create I-bay : support

Downloaded the osTicket-v1.10.1.zip to desktop

Extracted the zip file . Moved the 2 folders ( upload ; scripts ) to the ibay using scp.

 from console / putty :
Code: [Select]
# cd /home/e-smith/files/ibays/support/html
# cd upload
# pwd /home/e-smith/files/ibays/support/html/upload
# mv * ../
# cd /home/e-smith/files/ibays/support/html
# cd include
# cp ost-sampleconfig.php ost-config.php
# chmod 777 os-config.php
# cd /home/e-smith/files/ibays/support/html
# mkdir attachments
# chmod 777 attachments
# chown -R www.www *


Create Template fragment :

Code: [Select]
# cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/

# nano 99osticket

##------------------------------------------------------------
# support ibay directories ( Support)
#------------------------------------------------------------
Alias /support /home/e-smith/files/ibays/support/html
<Directory /home/e-smith/files/ibays/support/html>
     Options -Indexes
     AllowOverride None
     order deny,allow
     deny from all
     allow from all
     AuthName "osticket"
     AuthType Basic
     AuthExternal pwauth
     Satisfy all
     AddType application/x-httpd-php .php .php3
     php_admin_value upload_tmp_dir /home/e-smith/files/ibays/support/html
     php_flag  magic_quotes_gpc  on
     php_flag  track_vars        on
</Directory>

Save by pressing Ctrl x, press y to save changes and press enter

Code: [Select]
# expand-template /etc/httpd/conf/httpd.conf

# service httpd-e-smith condrestart

This is what the I-bay settings look like :
Code: [Select]
# db accounts show support
support=ibay
    AllowOverride=None
    AllowUrlfOpen=enabled
    CgiBin=enabled
    FollowSymLinks=disabled
    Gid=5155
    Group=admin
    Indexes=disabled
    MaxExecTime=disabled
    MemoryLimit=disabled
    ModDav=disabled
    Name=Support
    PHPBaseDir=/home/e-smith/files/ibays/support/html/:/tmp
    PasswordSet=no
    PostMaxSize=disabled
    PublicAccess=local
    SSL=disabled
    Uid=5155
    UpMaxFileSize=disabled
    UserAccess=wr-group-rd-everyone

Create Database as per the wiki:

Code: [Select]
# mysql -e "create database osticket"

# mysql -e "grant all privileges on osticket.* to osticketuser@localhost identified by 'osticketpassword'"

# mysql -e "flush privileges"

Using web installation script:

http://192.168.1.1/support/setup/



Offline tolistim

  • *
  • 27
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #7 on: May 15, 2018, 12:00:07 AM »
So here is what i did in Ibay and it looks all good :
Warren - thanks for validating this.  This mirrors what I figured out with a few minor differences.

I think this should become a howto.

Tim

Offline Drifting

  • ****
  • 431
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #8 on: July 30, 2018, 03:55:50 PM »
Followed this thread with interest. As I too wished to use this program

However, I am confused as to how you set the ebay settings you showed? Eveything else seems to have installed correctly but all I get is a blank screen.

Regards Paul.
Infamy, Infamy, they all have it in for me!

Offline warren

  • *
  • 291
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #9 on: July 30, 2018, 08:23:25 PM »
Install https://wiki.contribs.org/Webhosting Webhosting contrib.

Offline tolistim

  • *
  • 27
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #10 on: November 14, 2018, 08:20:29 PM »
It's been a few months and I've finally been able to revisit this.


I've started from scratch and followed Warren's guidance to the letter.  However, I am still greeted with a blank page when I go to either the ibay or the setup folder.


There must be something else that is missing at the base SME setup WRT the hopped and php setups.  That is the only thing that I can guess.


Is there a package that I should be checking for version or missing parts?

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #11 on: November 14, 2018, 09:02:32 PM »
Rule 1 Check your logs.

/var/log/messages
/var/log/httpd/error_log (check the spellig)
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline michelandre

  • *
  • 261
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #12 on: November 15, 2018, 02:51:21 AM »
Hi all,

I think osTicket requires PHP-5.6 or newer. An updated SME Server 9.2 runs php-5.3.3-49.el6.x86_64.


Code: [Select]
# rpm -qa | grep php

...
php-gd-5.3.3-49.el6.x86_64
php-5.3.3-49.el6.x86_64
php-mysql-5.3.3-49.el6.x86_64
...

I installed the PHP Contrib: https://wiki.contribs.org/PHP_Software_Collections. I set PHP70 in Server Manager for the i-bay "support". If I remember right, PHP71 gives problems with certain software?

I used git to download osTicket so it will be easy to make the updates.

I made a Howto about osTicket. It is in French but you can follow the commands: https://wiki.contribs.org/OsTicket-1.10.4.

Michel-André

Offline warren

  • *
  • 291
  • +0/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #13 on: November 15, 2018, 09:05:32 AM »
It's been a few months and I've finally been able to revisit this.


I've started from scratch and followed Warren's guidance to the letter.  However, I am still greeted with a blank page when I go to either the ibay or the setup folder.


There must be something else that is missing at the base SME setup WRT the hopped and php setups.  That is the only thing that I can guess.


Is there a package that I should be checking for version or missing parts?

I think this was missing from notes i had :

1. Install https://wiki.contribs.org/PHP_Software_Collections

2. Click on the Choose another PHP-mod version for the http server, instead of an Ibay.

3. Select "PHP-mod version : php56

4. Save

Then re-run setup

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Getting the current 1.10 osTicket to run in an ibay
« Reply #14 on: November 15, 2018, 11:05:10 AM »
Can someone update the wiki on all this please ??
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation