Print

---

Hi All,

I actually work on a part of SFT-2 Admin's Page which will allow to submit 
test jobs for uncertified sites.
My scripts use direct MySQL connections to GOC DB and that's the way I'm 
retrieving the newest information about EGEE sites.

On the other hand, SFT-2 developed by Piotr Nyczyk work with R-GMA as a source 
of such information.

I discovered some differences (let me say - incoherency) between these two 
"databases" when I was looking for not yet certified sites for SFT.

The follwing SQL query in GOC DB:

select n.hostname, n.domain, s.sitename as cn, s.siteID as id
from sites as s, nodes as n
where s.siteID = n.siteID and n.nodetype='CE' and s.status != 'Certified'
	and s.type='Production';

gives the result with 21 rows (21 sites).

The following SQL query in R-GMA (called from our local CE):

SELECT s.siteID,hostname,sitename,region,inMaintenance 
from GocSite_v0_4 as s, GocNode_v0_4 as n 
where s.siteID=n.siteID and n.nodetype='CE' and status!='Certified'
	and type='Production'

gives the result with 22 (!) rows.

This additional one is the site with ID=241, name='AUVERGRID' and 
host='clrlcgce02.in2p3.fr'.

And what is the reason?
The GOC DB says that 'clrlcgce02.in2p3.fr' is SE (so the query doesn't show 
this site) and R-GMA says that 'clrlcgce02.in2p3.fr' is CE....

My question is: what is the reason of this incoherency?
Is there any "direct" connection/relation between GOC DB and R-GMA?

Regards

Rafal


-- 

* * *
*    R a f a l    L i c h w a l a
*    Poznan Supercomputing and Networking Center
*    EGEE Project Participant
*
*    Address :   Poznan Supercomputing and Networking Center
*                      60-814 Poznan, Zwierzyniecka 20
*    Phone   :   (+48 61) 858 21 82
*    E-mail  :   mailto:[log in to unmask]
*
* * *