List of sites not publishing userDN

Main

EGI.eu operations services

Support

Documentation

Tools

Activities

Performance

Technology

Catch-all Services

Resource Allocation

Security

Page contains current status of handing sites not publishing UserDN

Last update: 5.12.2012

List of sites

Master ticket

NGI	Ticket	Site	Comment
NGI_IBERGRID	88662	ESA-ESAC
ROC CERN	88660	CERN-PROD	Publishing the user DN is indeed part of our future tasks. We hope to be able to take care of this in the next few weeks.
NGI_BY	88658	BY-NCPHEP BY-UIIP
NGI_HU	88657	BMEGrid SZTAKI
ROC_CANADA	88654	CA-ALBERTA-WESTGRID-T2
NGI_IL	88651	IL-TAU-HE
NGI_DE	88649	BMRZ-FRANKFURT RWTH-Aachen TUDresden-ZIH UNI-FREIBURG	https://helpdesk.ngi-de.eu/?mode=ticket_info&ticket_id=2802 https://helpdesk.ngi-de.eu/?mode=ticket_info&ticket_id=2801
NGI_RO	88648	NIHAM  RO-01-ICI         RO-02-NIPNE  RO-07-NIPNE  RO-11-NIPNE| RO-13-ISS RO-14-ITIM RO-15-NIPNE	NIHAM will not publish user DNs as long as this is not mandatory.
NGI_NL	88647	BCBR BEgrid-BELNET BEgrid-ULB-VUB BelGrid-UCL NIKHEF-ELPROD RUG-CIT
ROC_Russia	88646	ru-Moscow-SINP-LCG2 RU-Protvino-IHEP Ru-Troitsk-INR-LCG2
NGI_BG	88645	BG-INRNE BG05-SUGrid BG06-GPHI
NGI_AEGIS	88644	AEGIS01-IPB-SCL AEGIS02-RCUB AEGIS03-ELEF-LEDA AEGIS04-KG AEGIS11-MISANU	Due to privacy protection laws, we are not permitted to publish User DNs
ROC_AP	88643	INDIACMS-TIFR KR-KNU-T3 KR-UOS-SSCC MY-UM-CRYSTAL MY-UPM-BIRUNI-01 MY-UTM-GRID NCP-LCG2 TH-HAII TH-NECTEC-LSR

• 
  
• How the list is gathered
• The data in the following tables have been generated by the Accounting Portal staff, on June 5th, 2012.
• The "published_perc" column indicated the number of non-NULL DNs this site has published on the period since 2012.
• A 100% percentage means all the records have non-NULL UserDN, but may have gaps in the publishing. The accounting portal staff is working on a visualization of these publication gaps.
• Sites with NULL "published_perc" don't have any user records on the APEL repository.
• mysql> select c.rocname, c.sitename, (count(a.UserDN)-sum(IF(a.UserDN='NULL',1,0)))*100/count(a.UserDN) as published_perc, sum(NJobs) as num_jobs, MAX(RecordEnd) as last_published from gocdb3.org_EGEE join gocdb3.sites as c on RefID=SiteID and status='Certified' and type='Production' left join UserCPU2 as a on c.sitename=a.ExecutingSite and RecordStart>'2012-01-01' group by sitename, rocname order by rocname, published_perc;