Is there a OTRS gateway for joomla 3.0

solidcomm commented 11 years ago

I wunder if there is a OTRS gateway for JOOMLA 3.0 or did anyone test did already.

vittala commented 11 years ago

Hi solidcomm

At present we have not had a chance to try the component under Joomla 3.0. Because of the changes to the J3.0 templates we can't guarantee the current component will work as expected under J3.0.

We have not currently scheduled in a time to work on the J3.0 testing.

Regards Vittal

entnx-01 commented 10 years ago

Hey there,

do you have any new informations about Joomla 3 ?

Regards entnx

vittala commented 10 years ago

Hi entnx

Sorry, we don't have an update on OTRS 3 support at the moment.

Regards Vittal

ChuckNorrison commented 10 years ago

// You can find all the files for Joomla 3.x in the pull request. Have fun :) https://github.com/cognidox/OTRS-Joomla-Gateway/pull/36 or get it directly from my fork https://github.com/ChuckNorrison/OTRS-Joomla-Gateway

I would like to have update for Joomla 3 too :)

Trying to convert...

Some changes needed:

replace "DS" with "DIRECTORY_SEPARATOR"
replace nameQuote with quoteName
replace JModel with JModelLegacy
replace JView with JViewLegacy
replace JController with JControllerLegacy
replace "JHtmlBehavior::mootools();" with "JHtml::_('behavior.framework');"

replace "JHTML::_( 'stylesheet', 'otrsgateway.css', 'components/com_otrsgateway/assets/' );" with

  $doc = JFactory::getDocument();
  $doc->addStyleSheet( JUri::root() . 'components/com_otrsgateway/assets/otrsgateway.css' );

now it gets more tricky...

replace all "$this->assignRef" calls like this:

  //$this->assignRef( 'stateList', $stateList );
  $this->stateList=$stateList;

replace all JRequest::getVar calls with JInput. Its nessecary to create object first (i.e.):

  //$ticketID = JRequest::getVar( 'ticketID' );
$jinput = JFactory::getApplication()->input;
$ticketID = $jinput->get( 'ticketID', null, null );

replace all JRequest::SetVar calls with JInput. Use the object $jinput (created like above):
```
  //JRequest::setVar( 'view', 'tickets' );
  $jinput->set( 'view', 'tickets' );
```
replace all JRequest::getCmd calls with JInput. Use the object $jinput (created like above):
```
  //if ( ! JRequest::getCmd( 'view' ) )
if ( ! $jinput->getCmd( 'view' ) )
```

replace JFactory::getEditor() with JEditor::getInstance like this:

  //$editor =& JFactory::getEditor();
  $conf = JFactory::getConfig();
  $editor_conf = $conf->get('editor');
  $editor = JEditor::getInstance($editor_conf);

replace JUtility::getHash with JApplication::getHash
replace JRequest::checkToken() with JSession::checkToken()

replacements for attachments in view.raw.php:

// $file = JRequest::getVar( 'attachment', null, 'files', 'array' );
$jinput_new = new JInput($_FILES);
$file = $jinput_new->get( 'attachment', null, 'array' );

rewrite javascript from mootools to jquery in reply.php...

I did some more specific changes for my situation, but i think after all that changes it should work :)

entnx-01 commented 10 years ago

Wow, works fine for my Joomla 3., thanks a lot.

But there is one small problem. My OTRS is now version 3.3 and the plugin for OTRS only supports max 3.2. Is there a solution for that, too?

Regards entnx

ChuckNorrison commented 10 years ago

add 3.3 in the opm file. i added this change in https://github.com/ChuckNorrison/OTRS-Joomla-Gateway/commit/a6e65197c9033618afe093f8a8cf942cc8372c28

entnx-01 commented 10 years ago

Thanks for your fast answer!

That works for me. I connected my joomla to my otrs 3.3.

But there must be a bug. If I want to see all Tickets on my joomla page i don´t see anything till I refresh the page and then there are my open tickets. That problem appears every time I open my page.

There is one Message which is shown in the gateway options in joomla: SOAP Fault: (faultcode: soap:Client, faultstring: Application failed during request deserialization: no element found at line 1, column 0, byte -1 at /usr/lib/perl5/vendor_perl/5.16.0/i586-linux-thread-multi/XML/Parser.pm line 187. )

Next time I refresh the page the message is: Connected OK Is there a bug or is something wrong with my configuration?

entnx-01 commented 10 years ago

I found something at the documentation fpor the gateway module:

When configuring the OTRS Gateway component, the Gateway Summary reports: SOAP Fault: (faultcode: soap:Client, faultstring: Application failed during request deserialization: no element found... This is caused bug #58538 in the perl SOAP::Lite module (https://rt.cpan.org/Public/Bug/Display.html?id=58538). To resolve this, either downgrade the SOAP::Lite module on the OTRS server to version 0.69, or edit the installed SOAP/Transport/HTTP.pm file, changing the sysread call to a read call.

I will change this line and test it again!

entnx-01 commented 10 years ago

Ok it works!

I changed the sysread call in /opt/otrs/Kernel/cpan-lib/SOAP/Transport/HTTP.pm to raed and there are no errors :)

Thanks for your work!

Regards entnx

MP- commented 10 years ago

Warning

JInstaller: :Install: Cannot find XML setup file

You mentioned a good number of changes. I'm wondering if you were referring to Joomla! 3.0 or 3.3. BTW, I saved the files as a zip & attempted to upload. I'm new at Joomla! & would like to be great at it. :) So, I did not notice any mention of Jinstaller. What did I miss?

ChuckNorrison commented 10 years ago

Its testet with Joomla 3.3. Please just zip the com_otrsgateway folder in "joomla_3.x\com_otrsgateway". There the joomla can find the missing xml ;)

Solution in #39

I would recommend to use latest files from my fork in https://github.com/ChuckNorrison/OTRS-Joomla-Gateway

MP- commented 10 years ago

Thank you!! I'm just trying to configure SOAP Integration, but its component page is blank. From what I gather, it's because of group permissions, but (since it's for Joomla! 2.5) would Joomla SOAP Server API ( JMSOAP) be a better choice for installing SOAP?

ChuckNorrison commented 10 years ago

SoapClient Class which is used in rpchelper.php from com_otrsgateway is integrated in Joomla. There is nothing special needed than the OTRS Plugin (OTRS-Joomla-Gateway-0.9.3.opm). After installing in your OTRS you just have to start sysconf and set user and password to authenticate. Same data is needed in joomla otrsgateway config... like explained here: http://www.cognidox.com/cognidox/download/VI-401963-PR-LATEST_OTRS_Joomla_Gateway_installation.pdf

Maybe i dont understand your Problem.

anthric commented 8 years ago

Hi, I installed the gateway-0.9.3-opm on OTRS 4 which worked fine and also installed the Joomla plugin you fixed for Joomla 3.x. I've set the SOAP user and password in OTRS and also the settings in Joomla, but for some reason it doesn't seem to work. On the Joomla side it still says:

Unconfigured PHP SoapClient class not installed

And the OTRS URL http://localhost/otrs/rpc.extended.pl (running both on the same system) says it's missing.

Probably some changes from OTRS 3 to 4 that's causes this, any thoughts here?

vittala commented 8 years ago

Hi Getting the "SoapClient class not installed" message indicates that the PHP SOAP client extension has not been installed (or is not enabled) in PHP itself. What you will need to do is talk with the administrator of the Joomla server and have the SoapClient (http://php.net/manual/en/class.soapclient.php) installed and enabled.

Regards Vittal

anthric commented 8 years ago

Thank you, vittala.

Installed php-soap, had some issues and errors

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/simplexml.so' - /usr/lib64/php/modules/simplexml.so: cannot open shared object file: No such file or directory in Unknown on line 0

Installed php-xml which seem to solve that error, instead I just got a new kind of level in errors.. :)

Error log: PHP Warning: Module 'SimpleXML' already loaded in Unknown on line 0

Joomla GUI gateway summary now gives an error:

SOAP Fault: (faultcode: soap:Server, faultstring: $Kernel::OM is not defined, please initialize your object manager at /opt/otrs//Kernel/System/Log.pm line 61 Kernel::System::Log::new('Kernel::System::Log', 'LogPrefix', 'OTRS-EXT-RPC', 'EncodeObject', 'Kernel::System::Encode=HASH(0x7f42a8591a78)', 'ConfigObject', 'Kernel::Config=HASH(0x7f42a8240b88)') called at /opt/otrs/bin/cgi-bin/rpc.extended.pl line 69 Core::Dispatch('Core', 'soapu', 'pfsecret', 'TimeObject', 'CurrentTimestamp', 'SystemID', 0) called at /opt/otrs/Kernel/cpan-lib/SOAP/Lite.pm line 2875 eval {...} called at /opt/otrs/Kernel/cpan-lib/SOAP/Lite.pm line 2860 eval {...} called at /opt/otrs/Kernel/cpan-lib/SOAP/Lite.pm line 2826 SOAP::Server::handle('SOAP::Transport::HTTP::CGI=HASH(0x7f42a816abb8)', '<?xml version="1.0" encoding="UTF-8"?>\x{a}<SOAP-ENV:Envelope xml...') called at /opt/otrs/Kernel/cpan-lib/SOAP/Transport/HTTP.pm line 438 SOAP::Transport::HTTP::Server::handle('SOAP::Transport::HTTP::CGI=HASH(0x7f42a816abb8)') called at /opt/otrs/Kernel/cpan-lib/SOAP/Transport/HTTP.pm line 603 SOAP::Transport::HTTP::CGI::handle('SOAP::Transport::HTTP::CGI=HASH(0x7f42a816abb8)') called at /opt/otrs/bin/cgi-bin/rpc.extended.pl line 46 ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_rpc_2eextended_2epl::handler('Apache2::RequestRec=SCALAR(0x7f42a7353dc8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 204 eval {...} called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 204 ModPerl::RegistryCooker::run('ModPerl::Registry=HASH(0x7f42a7353d68)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 170 ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0x7f42a7353d68)') called at /usr/lib64/perl5/vendor_perl/ModPerl/Registry.pm line 31 ModPerl::Registry::handler('ModPerl::Registry', 'Apache2::RequestRec=SCALAR(0x7f42a7353dc8)') called at -e line 0 eval {...} called at -e line 0 )

vittala commented 8 years ago

Hi

This looks like an incompatibility between the current OTRS package and OTRS 4 (https://otrs.github.io/doc/manual/developer/4.0/en/html/package-porting.html). Unfortunately, we have not ported the package to OTRS 4 yet, so there is no quick fix for this.

Regards Vittal

ChuckNorrison commented 8 years ago

Hey anthric,

in your otrs_joomla_module.sopm, please add the OTRS Framework like this:

<?xml version="1.0" encoding="utf-8" ?> 
<otrs_package version="1.0"> 
    <Name>OTRS-Joomla-Gateway</Name> 
    <Version>0.9.5</Version>
    <Framework>4.0.x</Framework>
    <Framework>3.3.x</Framework>

Then you can try to import the package again in your OTRS. The first soap failures seems to be a problem with your webserver config.

Iam on OTRS 3.3 and everything is fine here. Someday i will update my OTRS and have to work on this Joomla Plugin again... so far i cant get so much support for this.

anthric commented 8 years ago

Hi Chuck,

That was one fo the first thing I noticed, it was also mentioned earlier too. The problem must be related to what vittala last mentioned. Due to the the changes in OTRS 4 from 3.3 :/

I just copied the rpc.pl to rpc.extended.pl and overwrote as they are different in the stucture due to the changes OTRS made in OTRS 4. I now can see the result: Connected: OK

BUT I can still see following errors in the error.log due to the complability issues in the codes in other files, which I assume will have to be updated before this work.

[Mon Apr 11 15:16:35 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.5.34 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations Notice: Install /opt/otrs/bin/cgi-bin/rpc.extended.pl (755)! Notice: Install /opt/otrs/Kernel/System/JoomlaGateway.pm (644)! Notice: Install /opt/otrs/Kernel/Config/Files/JoomlaGateway.xml (644)! [Mon Apr 11 16:16:37 2016] [notice] caught SIGTERM, shutting down [Mon Apr 11 16:16:39 2016] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Mon Apr 11 16:16:40 2016] [notice] Digest: generating secret for digest authentication ... [Mon Apr 11 16:16:40 2016] [notice] Digest: done PHP Warning: Module 'SimpleXML' already loaded in Unknown on line 0 [Mon Apr 11 16:16:40 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.5.34 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations

cognidox / OTRS-Joomla-Gateway

Is there a OTRS gateway for joomla 3.0 #32