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: 10.12.2012

List of sites

Master ticket

no of sites: 42

NGI	Ticket	Site	Comment
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-UIIP
NGI_DE	88649	BMRZ-FRANKFURT TUDresden-ZIH	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-07-NIPNE  RO-13-ISS RO-14-ITIM RO-16-UAIC	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 LSG-HTC
ROC_Russia	88646	ru-Moscow-SINP-LCG2 RU-Protvino-IHEP Ru-Troitsk-INR-LCG2
NGI_BG	88645	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 JP-HIROSHIMA-WLCG - KR-KISTI-GSDC-01 - KR-KNU-T3 KR-UOS-SSCC MY-UM-CRYSTAL MY-UPM-BIRUNI-01 MY-UTM-GRID T2-TH-CUNSTDA- TH-HAII TH-NECTEC-LSR
NGI_CYGRID	89352	CY-01-KIMON
NGI_IT	89351	Hephy-Vienna
NGI_UK	89350	UKI-SCOTGRID-ECDF UKI-SOUTHGRID-BRIS-HEP
ROC_LA	CBPF ULA-MERIDA	CBPF ULA-MERIDA

How the list is gathered

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;