Difference between revisions of "APEL Server and Accounting Portal"

From EGIWiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
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.   
 
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 SSM code so that they can receive the messages containing the Summary and SpecIntHistory records.  [SSM [https://wiki.egi.eu/wiki/APEL/Server#SSM]]
+
The portal will therefore also need to run the SSM[[APEL/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.
 
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 sending data has changed as well as the database schema.  It will be possible for the portal to use the Record Loader code to insert the messages sent via the SSM into their database, with some modifications.  [Record Loader [https://wiki.egi.eu/wiki/APEL/Server#Record_Loader]]
+
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:
 
The message types sent will be:
 
   
 
   
Line 18: Line 17:
 
* org_OSG  
 
* org_OSG  
  
may be created by the portal as they can now access the data directly.
+
will be created by the portal as they can now access the data directly.
  
  
Line 25: Line 24:
  
 
is under review, as it may no longer be required.
 
is under review, as it may no longer be required.
 +
 +
[[Category:Accounting]]

Latest revision as of 17:52, 29 November 2012

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.