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

Page is updated only when we receive report form APEL team.

List of sites

Master ticket

no of sites: 39

NGI	Master 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 RWTH-Aachen	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-07-NIPNE RO-13-ISS RO-14-ITIM RO-15-NIPNE	NIHAM will not publish user DNs as long as this is not mandatory. RO-13-SS - Waiting to clear up the possible legal issues regarding user privacy
NGI_NL	88647	BCBR BEgrid-ULB-VUB BelGrid-UCL NIKHEF-ELPROD LSG-AMS	NIKHEF-ELPROD remarks the following: "We do send the DN information for those VOs that have opted into EGI central accounting via the SSM interface. If only EGI accounting finally looked at their SSM system for production everything would work. I think we already communicated this for the last 12 months several times to EGI, Tiziana, Peter & all the world. Even to wLCG. As soon as EGI finally switches to SSM reporting all will be fine."
ROC_Russia	88646	ru-Moscow-SINP-LCG2 RU-SPbSU
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	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 IN-DAE-VECC-02
NGI_IT	89351	Hephy-Vienna INFN-PERUGIA
ROC_LA	SAMPA ULA-MERIDA	SAMPA ULA-MERIDA
NGI_GRNET	89863	GR-11-UPATRAS

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;