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 15: Line 15:
! '''Site'''  
! '''Site'''  
! '''Comment'''  
! '''Comment'''  
!
|-
|-
| NGI_IBERGRID  
| NGI_IBERGRID  
Line 22: Line 21:
*ESA-ESAC
*ESA-ESAC


|
|  
|  
|-
|-
Line 31: Line 29:


| 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_BY  
| NGI_BY  
| [https://ggus.eu/ws/ticket_info.php?ticket=88658 88658]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88658 88658]  
|  
|  
*BY-NCPHEP
*BY-NCPHEP  
*BY-UIIP
*BY-UIIP


|
|  
|  
|-
|-
Line 45: Line 41:
| [https://ggus.eu/ws/ticket_info.php?ticket=88657 88657]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88657 88657]  
|  
|  
*BMEGrid
*BMEGrid  
*SZTAKI
*SZTAKI


|
|  
|  
|-
|-
Line 56: Line 51:
*CA-ALBERTA-WESTGRID-T2
*CA-ALBERTA-WESTGRID-T2


|
|  
|  
|-
|-
Line 64: Line 58:
*IL-TAU-HE
*IL-TAU-HE


|
|  
|  
|-
|-
Line 70: Line 63:
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649]  
|  
|  
*BMRZ-FRANKFURT
*BMRZ-FRANKFURT  
*RWTH-Aachen  
*RWTH-Aachen  
*TUDresden-ZIH  
*TUDresden-ZIH  
Line 80: Line 73:
https://helpdesk.ngi-de.eu/?mode=ticket_info&ticket_id=2801  
https://helpdesk.ngi-de.eu/?mode=ticket_info&ticket_id=2801  


|
|-
|-
| NGI_RO  
| NGI_RO  
Line 91: Line 83:
*RO-11-NIPNE|  
*RO-11-NIPNE|  
*RO-13-ISS  
*RO-13-ISS  
*RO-14-ITIM
*RO-14-ITIM  
*RO-15-NIPNE
*RO-15-NIPNE


| NIHAM will not publish user DNs as long as this is not mandatory.  
| NIHAM will not publish user DNs as long as this is not mandatory.  
|
|-
|-
| NGI_NL  
| NGI_NL  
| [https://ggus.eu/ws/ticket_info.php?ticket=88647 88647]  
| [https://ggus.eu/ws/ticket_info.php?ticket=88647 88647]  
|  
|  
*BCBR
*BCBR  
*BEgrid-BELNET  
*BEgrid-BELNET  
*BEgrid-ULB-VUB  
*BEgrid-ULB-VUB  
*BelGrid-UCL  
*BelGrid-UCL  
*NIKHEF-ELPROD
*NIKHEF-ELPROD  
*RUG-CIT
*RUG-CIT


|  
|  
|
*
|-
|-
|  
|  
Line 119: Line 107:


|  
|  
*ru-Moscow-SINP-LCG2
*ru-Moscow-SINP-LCG2  
*RU-Protvino-IHEP  
*RU-Protvino-IHEP  
*Ru-Troitsk-INR-LCG2
*Ru-Troitsk-INR-LCG2


|  
|  
|
*
|-
|-
|  
|  
Line 135: Line 120:


|  
|  
*BG-INRNE
*BG-INRNE  
*BG05-SUGrid  
*BG05-SUGrid  
*BG06-GPHI
*BG06-GPHI


|  
|  
|
*
|-
|-
|  
|  
Line 159: Line 141:
|  
|  
*Due to privacy protection laws, we are not permitted to publish User DNs
*Due to privacy protection laws, we are not permitted to publish User DNs
|
*


|-
|-
Line 171: Line 150:


|  
|  
*INDIACMS-TIFR
*INDIACMS-TIFR  
*KR-KNU-T3  
*KR-KNU-T3  
*KR-UOS-SSCC  
*KR-UOS-SSCC  
Line 182: Line 161:


|  
|  
|  
|}
*
 
<br>
 
= 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.


|}
<code>mysql&gt; 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&gt;'2012-01-01' group by sitename, rocname order by rocname, published_perc; </code>


*<br>
[[Category:Grid_Operations_Meetings]]
*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.
*<code>mysql&gt; 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&gt;'2012-01-01' group by sitename, rocname order by rocname, published_perc; </code>
*[[Category:Grid_Operations_Meetings]]
*

Revision as of 15:43, 5 December 2012

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
  • ru-Moscow-SINP-LCG2
  • RU-Protvino-IHEP
  • Ru-Troitsk-INR-LCG2
  • NGI_BG
  • BG-INRNE
  • BG05-SUGrid
  • BG06-GPHI
  • NGI_AEGIS
  • 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
  • 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;

Retrieved from "https://wiki.egi.eu/w/index.php?title=List_of_sites_not_publishing_userDN&oldid=47005"