Difference between revisions of "List of sites not publishing userDN"
Line 27: | Line 27: | ||
take care of this in the next few weeks. | take care of this in the next few weeks. | ||
Line 37: | Line 39: | ||
BY-UIIP | BY-UIIP | ||
Line 47: | Line 51: | ||
| <span class="solution">BMEGrid | | <span class="solution">BMEGrid | ||
SZTAKI | SZTAKI | ||
Line 63: | Line 70: | ||
| NGI_IL | | NGI_IL | ||
| [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- | | <span class="solution">IL-TAU-HE | ||
Line 78: | Line 86: | ||
RWTH-Aachen | RWTH-Aachen | ||
TUDresden-ZIH | |||
UNI-FREIBURG | |||
Line 105: | Line 113: | ||
BEgrid-BELNET | BEgrid-BELNET | ||
BEgrid-ULB-VUB | |||
BelGrid-UCL | |||
NIKHEF-ELPROD| | |||
RUG-CIT | |||
Line 127: | Line 134: | ||
| <span class="solution">ru-Moscow-SINP-LCG2 | | <span class="solution">ru-Moscow-SINP-LCG2 | ||
RU-Protvino-IHEP | RU-Protvino-IHEP | ||
Ru-Troitsk-INR-LCG2 | |||
Line 142: | Line 150: | ||
BG05-SUGrid | BG05-SUGrid | ||
BG06-GPHI | |||
Line 163: | Line 172: | ||
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- | TH-NECTEC-LSR | ||
Line 188: | Line 193: | ||
|} | |} | ||
<br> | <br> | ||
= How the list is gathered = | = How the list is gathered = |
Revision as of 15:36, 5 December 2012
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 TUDresden-ZIH UNI-FREIBURG
|
||
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 | 88646 | ru-Moscow-SINP-LCG2
RU-Protvino-IHEP Ru-Troitsk-INR-LCG2
|
||
NGI_BG | 88645 | BG-INRNE
BG05-SUGrid 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
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;