Maybe, but these are very dangerous positions : you'll be surrounded
with very active volcanoes, *and* water there contains arsenic (yes, I
swear !).
;)
Jeff Templon wrote:
> 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
>>>
>>>
>>>
>>>
>
|