Grids in the Auvergne???? Do they have any sysadmin positions open??
J "hmmm, causse noir anyone?" T
Frederic Schaer wrote:
> Hi,
>
> If I'm not mistaken, part of the GOC DB data is exported to R-GMA.
> clrlcgce02 is an CE, and is shown as such in a browser on the GOC DB
> (site is IN2P3-LPC) ...
>
> For Auvergrid, the only nodes I can see are :
> CE obsauvergridce01.univ-bpclermont.fr (Y)
> SE clrauvergridse01.in2p3.fr (Y)
>
>
> Are you sure about your queries ?
> One thing to notice : this site is "candidate", and not "uncertified"
> ... so I would say your requirement
>
> status!='Certified'
>
> has to be changed.
>
> Cheers,
> Fred
>
> Rafal Lichwala wrote:
>
>>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
>>
>>
>>
>>
|