Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The net.dante.otrs.OTRSConsumer JAVA class does not require any parameters.

In a nutshell, the OTRSPruducer, queries the OTRS system for all maintenance tickets that were updated in the last 60 minutes. It retrieves those tickets and creates XML messages within the Enterprise Service Bus in the OTRS queue. Once it has completed it's processing, a Consumer, OTRSConsumer, processes the message within the OTRS queue OTRConsumer retrieves the XML messages from the ESB OTRS queue, and parses the XML, and uses a standard classOTRSTicket to store the parsed XML values into. The OTRSTicket class is then used to store the data within the two MySQL databases described below.

The class uses the standard AuditLog class to write log message to /tmp/otrs/OTRSConsumer-YYYYMMDD.log. The location and name of the log file is configurable from within the otrs.properties file

...

The XML returned from the OTRS Web Service TicketGet operation from the OTRSProducer class is sent as a plain text message to the ESB and stored in the OTRS queue.


MySQL Database Connections

The OTRSConsumer connects to two MySQL databases:

sde database on test-msr.geant.net using user reportsUser

maintenance database on uat-dboard01-corr.geant.net using user maintainor. This database is used by the UAT version of the new dashboard correlator. This is not in use by the Production instance.

*** IMPROVEMENT - Add a configuration flag to turn on / off this connection