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"
| Line 1: | Line 1: | ||
{{Template:Op menubar}} | |||
{{TOC_right}} | |||
'''Page contains current status of handing sites not publishing UserDN''' | '''Page contains current status of handing sites not publishing UserDN''' | ||
| Line 27: | Line 30: | ||
take care of this in the next few weeks. | take care of this in the next few weeks. | ||
| Line 39: | Line 49: | ||
BY-UIIP | BY-UIIP | ||
| Line 52: | Line 69: | ||
SZTAKI | SZTAKI | ||
| Line 71: | Line 97: | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88651 88651] | | [https://ggus.eu/ws/ticket_info.php?ticket=88651 88651] | ||
| <span class="solution">IL-TAU-HE | | <span class="solution">IL-TAU-HE | ||
| Line 85: | Line 118: | ||
RWTH-Aachen | RWTH-Aachen | ||
TUDresden-ZIH | TUDresden-ZIH | ||
UNI-FREIBURG | UNI-FREIBURG | ||
| Line 112: | Line 154: | ||
BEgrid-BELNET | BEgrid-BELNET | ||
BEgrid-ULB-VUB | BEgrid-ULB-VUB | ||
BelGrid-UCL | BelGrid-UCL | ||
NIKHEF-ELPROD| | NIKHEF-ELPROD| | ||
RUG-CIT | RUG-CIT | ||
| Line 135: | Line 190: | ||
RU-Protvino-IHEP | RU-Protvino-IHEP | ||
Ru-Troitsk-INR-LCG2 | Ru-Troitsk-INR-LCG2 | ||
| Line 150: | Line 213: | ||
BG05-SUGrid | BG05-SUGrid | ||
BG06-GPHI | BG06-GPHI | ||
| Line 172: | Line 243: | ||
KR-KNU-T3 | KR-KNU-T3 | ||
KR-UOS-SSCC | KR-UOS-SSCC | ||
MY-UM-CRYSTAL | MY-UM-CRYSTAL | ||
MY-UPM-BIRUNI-01 | MY-UPM-BIRUNI-01 | ||
MY-UTM-GRID | MY-UTM-GRID | ||
NCP-LCG2 | NCP-LCG2 | ||
TH-HAII | TH-HAII | ||
TH-NECTEC-LSR | TH-NECTEC-LSR | ||
Revision as of 15:38, 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
| 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
|
||
| 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
|
||
| ROC_Russia | 88646 | ru-Moscow-SINP-LCG2
RU-Protvino-IHEP
|
||
| NGI_BG | 88645 | BG-INRNE
BG05-SUGrid
|
||
| 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
|
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;