Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

APEL Server and Accounting Portal

From EGIWiki
Revision as of 16:52, 29 November 2012 by Krakow (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Currently the Accounting portal retrieves database tables directly from the APEL server. When the new APEL server is in place, the data will be sent to the portal via the SSM.

The portal will therefore also need to run the SSMAPEL/Server#SSM code so that they can receive the messages containing the Summary and SpecIntHistory records. Messages are encrypted/decrypted by the SSM so it will no longer be necessary for the portal to run the apelProcessor decryption code once the SSM system is in place.

It will be necessary to modify the code which inserts the data into the portal database as the method of collecting the data has changed as well as the database schema. It will be possible for the portal to use the Record Loader APEL/Server#Record_Loader code to insert the messages sent via the SSM into their database, with some modifications. The message types sent will be:

  • SpecIntHistory Record messages (in place of SpecIntHistory table)
  • Summary Record messages (in place of UserCPU and SumCPU tables)

There are also some other tables which are currently downloaded from the APEL server, one set:

  • org_Tier1
  • org_Tier2
  • Tier2MOU_v4
  • org_OSG

will be created by the portal as they can now access the data directly.


The other table:

  • MetricVO_Cumulative

is under review, as it may no longer be required.