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.

Difference between revisions of "APEL Server and Accounting Portal"

From EGIWiki
Jump to navigation Jump to search
(Created page with '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. …')
 
 
(10 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.  The portal will therefore need to run the SSM code so that they can receive the messages containing the Summary and SpecIntHistory records.  They may also use the Record Loader code to insert the data into their database.   
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[[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.
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:
   
   
* SpecIntHistory Record messages (in place of specIntHistory table)
* SpecIntHistory Record messages (in place of SpecIntHistory table)
* Summary Record messages (in place of UserCPU and SumCPU tables)
* Summary Record messages (in place of UserCPU and SumCPU tables)
The portal runs the apelProcessor decryption code at the moment, however, the messages sent via the SSM are encrypted so it will not be necessary to run this apelProcessor code in future. 


There are also some other tables which are currently downloaded from the APEL server, one set:
There are also some other tables which are currently downloaded from the APEL server, one set:
Line 15: 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 22: 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 16: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.