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 "List of sites not publishing userDN"

From EGIWiki
Jump to navigation Jump to search
Line 3: Line 3:
'''Page contains current status of handing sites not publishing UserDN'''  
'''Page contains current status of handing sites not publishing UserDN'''  


'''Last update:''' 20.12.2012
'''Last update:''' 7.01.2013


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


= List of sites  =
= List of sites  =
Line 11: Line 11:
[https://ggus.eu/ws/ticket_info.php?ticket=88641 Master ticket]  
[https://ggus.eu/ws/ticket_info.php?ticket=88641 Master ticket]  


no of sites: 39
no of sites: 42


{| class="wikitable sortable"
{| class="wikitable sortable"
Line 27: Line 27:
| 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.
| 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_HU<br>
| NGI_HU<br>  
| [https://ggus.eu/ws/ticket_info.php?ticket=90124 90124]<br>
| [https://ggus.eu/ws/ticket_info.php?ticket=90124 90124]<br>  
|  
|  
*BMEGrid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
*BMEGrid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
Line 34: Line 34:
| <br>
| <br>
|-
|-
| NGI_IBERGRID<br>
| NGI_IBERGRID<br>  
| [https://ggus.eu/ws/ticket_info.php?ticket=90125 90125]<br>
| [https://ggus.eu/ws/ticket_info.php?ticket=90125 90125]<br>  
|  
|  
*IFCA-LCG2<br>
*IFCA-LCG2<br>
Line 48: Line 48:
| <br>
| <br>
|-
|-
| NGI_CZ<br>
| NGI_CZ<br>  
| [https://ggus.eu/ws/ticket_info.php?ticket=90126 90126]<br>
| [https://ggus.eu/ws/ticket_info.php?ticket=90126 90126]<br>  
|  
|  
*praguelcg2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
*praguelcg2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
Line 58: Line 58:
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649]  
|  
|  
*FZK-LCG2<br>
*FZK-LCG2<br>  
*MaiGRID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
*MaiGRID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*UNI-FREIBURG<br>
*UNI-FREIBURG<br>  
*TUDresden-ZIH<br>  
*TUDresden-ZIH<br>  
*RWTH-Aachen
*RWTH-Aachen
Line 73: Line 73:
| [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648]  
|  
|  
*[https://ggus.eu/ws/ticket_info.php?ticket=89014 NIHAM]<br>
*[https://ggus.eu/ws/ticket_info.php?ticket=89014 NIHAM]<br>  
*[https://ggus.eu/ws/ticket_info.php?ticket=89019 RO-13-ISS]  
*[https://ggus.eu/ws/ticket_info.php?ticket=89019 RO-13-ISS]  
*[https://ggus.eu/ws/ticket_info.php?ticket=89020 RO-14-ITIM]<br>
*[https://ggus.eu/ws/ticket_info.php?ticket=89020 RO-14-ITIM]<br>
Line 87: Line 87:
| [https://ggus.eu/ws/ticket_info.php?ticket=88647 88647]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88647 88647]  
|  
|  
*BCBR <br>
*BCBR <br>  
*BelGrid-UCL<br>
*BelGrid-UCL<br>  
*LSG-AMC&nbsp;&nbsp; <br>
*LSG-AMC&nbsp;&nbsp; <br>  
*LSG-HUB&nbsp;&nbsp;&nbsp;&nbsp; <br>
*LSG-HUB&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*LSG-KUN&nbsp;&nbsp;&nbsp;&nbsp; <br>
*LSG-KUN&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*LSG-LUMC&nbsp;&nbsp;&nbsp;&nbsp; <br>
*LSG-LUMC&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*LSG-NKI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
*LSG-NKI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*LSG-VU&nbsp;&nbsp; <br>
*LSG-VU&nbsp;&nbsp; <br>  
*LSG-WUR&nbsp;&nbsp;&nbsp; <br>
*LSG-WUR&nbsp;&nbsp;&nbsp; <br>  
*NIKHEF-ELPROD <br>
*NIKHEF-ELPROD <br>  
*SARA-MATRIX <br>
*SARA-MATRIX <br>


| <span class="solution">NIKHEF-ELPROD remarks the following:
| <span class="solution">NIKHEF-ELPROD remarks the following:




Line 106: Line 110:


"We do send the DN information for those VOs that have opted into EGI
"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
central accounting via the SSM interface. If only EGI accounting finally




looked at their SSM system for production everything would work.
looked at their SSM system for production everything would work.




I think we already communicated this for the last 12 months several
I think we already communicated this for the last 12 months several




times to EGI, Tiziana, Peter &amp; all the world. Even to wLCG.
times to EGI, Tiziana, Peter &amp; all the world. Even to wLCG.




As soon as EGI finally switches to SSM reporting all will be fine."
As soon as EGI finally switches to SSM reporting all will be fine."




Line 154: Line 173:
| [https://ggus.eu/ws/ticket_info.php?ticket=88643 88643]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88643 88643]  
|  
|  
*IN-DAE-VECC-02 <br>
*IN-DAE-VECC-02 <br>  
*JP-HIROSHIMA-WLCG
*JP-HIROSHIMA-WLCG  
*KR-KISTI-GCRT-01&nbsp;&nbsp; <br>
*KR-KISTI-GCRT-01&nbsp;&nbsp; <br>  
*KR-KISTI-GSDC-01 <br>
*KR-KISTI-GSDC-01 <br>  
*KR-KNU-T3&nbsp;&nbsp;&nbsp;&nbsp; <br>
*KR-KNU-T3&nbsp;&nbsp;&nbsp;&nbsp; <br>  
*KR-UOS-SSCC
*KR-UOS-SSCC  
*MY-UM-CRYSTAL&nbsp; <br>
*MY-UM-CRYSTAL&nbsp; <br>  
*NCP-LCG2&nbsp;&nbsp; <br>
*NCP-LCG2&nbsp;&nbsp; <br>  
*TH-NECTEC-LSR&nbsp;&nbsp; <br>
*TH-NECTEC-LSR&nbsp;&nbsp; <br>


Line 176: Line 195:
|}
|}


<br>
<br>  


= How the list is gathered  =
= How the list is gathered  =

Revision as of 15:08, 7 January 2013

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

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

List of sites

Master ticket

no of sites: 42

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_HU
90124
  • BMEGrid            

NGI_IBERGRID
90125
  • IFCA-LCG2

NGI_BY 88658
  • BY-UIIP

NGI_CZ
90126
  • praguelcg2         

NGI_DE 88649
  • FZK-LCG2
  • MaiGRID            
  • UNI-FREIBURG
  • 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 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
  • BelGrid-UCL
  • LSG-AMC  
  • LSG-HUB    
  • LSG-KUN    
  • LSG-LUMC    
  • LSG-NKI      
  • LSG-VU  
  • LSG-WUR   
  • NIKHEF-ELPROD
  • SARA-MATRIX
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
  • IN-DAE-VECC-02
  • JP-HIROSHIMA-WLCG
  • KR-KISTI-GCRT-01  
  • KR-KISTI-GSDC-01
  • KR-KNU-T3    
  • KR-UOS-SSCC
  • MY-UM-CRYSTAL 
  • NCP-LCG2  
  • TH-NECTEC-LSR  

ROC_LA
  • 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;