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 1: Line 1:
[[Category:Grid Operations Meetings]]
'''Page contains current status of handing sites not publishing UserDN'''  
'''Page contains current status of handing sites not publishing UserDN'''


'''Last update:''' 5.12.2012
'''Last update:''' 5.12.2012  


=List of sites=
= List of sites =


[https://ggus.eu/ws/ticket_info.php?ticket=88641 Master ticket]


{|
|-
! '''NGI'''
! '''Ticket'''
! '''Site'''
! '''Comment'''
!
|-
| NGI_IBERGRID
| [https://ggus.eu/ws/ticket_info.php?ticket=88662 88662]
| <span class="solution">ESA-ESAC</span>
|
|
|-
| ROC CERN
| [https://ggus.eu/ws/ticket_info.php?ticket=88660 88660]
| CERN-PROD
| <span class="solution">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.</span>
|
|-
| NGI_BY
| [https://ggus.eu/ws/ticket_info.php?ticket=88658 88658]
| <span class="solution">BY-NCPHEP
BY-UIIP</span>
|
|
|-
| NGI_HU
| [https://ggus.eu/ws/ticket_info.php?ticket=88657 88657]
| <span class="solution">BMEGrid


=How the list is gathered=
SZTAKI
The data in the following tables have been generated by the Accounting Portal staff, on June 5th, 2012.
</span>
* 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.
|-
| ROC_CANADA
| [https://ggus.eu/ws/ticket_info.php?ticket=88654 88654]
| <span class="solution">CA-ALBERTA-WESTGRID-T2</span>
|
|
|-
| NGI_IL
| [https://ggus.eu/ws/ticket_info.php?ticket=88651 88651]
| <span class="solution">IL-TAU-HEP
</span>
|
|
|-
| NGI_DE
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649]
| <span class="solution">BMRZ-FRANKFURT


<code>
RWTH-Aachen
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;
 
</code>
TUDresden-ZIH
 
UNI-FREIBURG</span>
|
https://helpdesk.ngi-de.eu/?mode=ticket_info&amp;ticket_id=2802
 
https://helpdesk.ngi-de.eu/?mode=ticket_info&amp;ticket_id=2801
 
|
|-
| NGI_RO
| [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648]
| NIHAM&nbsp; <br>RO-01-ICI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>RO-02-NIPNE&nbsp; <br>RO-07-NIPNE&nbsp; <br>RO-11-NIPNE&#124; <br>RO-13-ISS <br>RO-14-ITIM<br>RO-15-NIPNE <br>
| <span class="internal">NIHAM will not publish user DNs as long as this is not mandatory.</span>
|
|-
| NGI_NL
| [https://ggus.eu/ws/ticket_info.php?ticket=88647 88647]
| <span class="solution">BCBR
 
BEgrid-BELNET
 
BEgrid-ULB-VUB
 
BelGrid-UCL
 
NIKHEF-ELPROD&#124;
 
RUG-CIT
</span>
|
|
|-
| ROC_Russia
| [https://ggus.eu/ws/ticket_info.php?ticket=88646 88646]
| <span class="solution">ru-Moscow-SINP-LCG2
 
RU-Protvino-IHEP
 
Ru-Troitsk-INR-LCG2</span>
|
|
|-
| NGI_BG
| [https://ggus.eu/ws/ticket_info.php?ticket=88645 88645]
| <span class="solution">BG-INRNE
 
BG05-SUGrid
 
BG06-GPHI</span>
|
|
|-
| NGI_AEGIS
| [https://ggus.eu/ws/ticket_info.php?ticket=88644 88644]
| AEGIS01-IPB-SCL <br>AEGIS02-RCUB <br>AEGIS03-ELEF-LEDA <br>AEGIS04-KG <br>AEGIS11-MISANU
| <span class="solution">Due to privacy protection laws, we are not permitted to publish User DNs</span>
|
|-
| ROC_AP
| [https://ggus.eu/ws/ticket_info.php?ticket=88643 88643]
| <span class="solution">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</span>
|
|
|}
 
<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>  
 
[[Category:Grid_Operations_Meetings]]

Revision as of 15:34, 5 December 2012

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-HEP

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

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