Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: tolistim on May 11, 2018, 01:02:51 AM

Title: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim 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:

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?
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: warren 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 (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

(http://)
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim on May 11, 2018, 11:43:45 PM
Just Followed the wiki howto  https://wiki.contribs.org/Osticket (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.
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: ReetP 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

Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim 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.
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: ReetP 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.

Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: warren 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/


Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim 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
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: Drifting 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.
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: warren on July 30, 2018, 08:23:25 PM
Install https://wiki.contribs.org/Webhosting (https://wiki.contribs.org/Webhosting) Webhosting contrib.
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim 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?
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: ReetP on November 14, 2018, 09:02:32 PM
Rule 1 Check your logs.

/var/log/messages
/var/log/httpd/error_log (check the spellig)
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: michelandre 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é
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: warren 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 (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
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: ReetP on November 15, 2018, 11:05:10 AM
Can someone update the wiki on all this please ??
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: michelandre on November 15, 2018, 02:14:40 PM
Hi all,

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

The "http server" is better if you don't have something else in another i-bay. If you installed WordPress in Primary a long time ago using the default PHP and you change the version for "http server", WordPress might not work anymore...

As always, make a backup before making changes...

Michel-André
Title: Re: Getting the current 1.10 osTicket to run in an ibay
Post by: tolistim on November 21, 2018, 03:58:14 PM
I made a Howto about osTicket. It is in French but you can follow the commands: https://wiki.contribs.org/OsTicket-1.10.4 (https://wiki.contribs.org/OsTicket-1.10.4).

Michel-André

Hi Michel-André,


Thank you for this - the combination of the proper PHP version AND setting FollowSymLinks to "enabled" were the two missing pieces.  I now have osTicket running and am walking through the configuration this morning.