Changes between Version 3 and Version 4 of Software/eAM/aInventory/fScheduler


Ignore:
Timestamp:
Jun 24, 2013, 2:26:03 PM (11 years ago)
Author:
Olivera Tosic
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Software/eAM/aInventory/fScheduler

    v3 v4  
    3232 * Make domain active in scheduler database i.e set status to 'a':
    3333{{{
    34 Update newScheduler.resources set status='a' where name = '<old_testbed_name>';
     34Update newScheduler.resources set status='a' where name = '<old_name>';
    3535}}}
    3636* Change name and description:
    37 
    3837{{{
    39 Update newScheduler.resources set name='<new_testbed_name>', notes='node3-3 i node4-10' where name = '<old_testbed_name>';
     38Update newScheduler.resources set name='<new_name>', notes='node3-3 i node4-10' where name = '<old_name>';
    4039}}}
    4140
    4241or with one statement
    4342{{{
    44 Update newScheduler.resources set status='a', name='<new_testbed_name>', notes='node3-3 i node4-10' where name ='<old_testbed_name>';
     43Update newScheduler.resources set status='a', name='<new_name>', notes='node3-3 i node4-10' where name ='<old_name>';
    4544}}}
    4645
    4746==== Inventory database ====
     47* Change name
     48It's not possible to change resource name using inventory service. This can be done directly into database. Anytime you can delete resource with <old_name> and create new one. To change resource name run flowing script:
     49{{{
     50UPDATE inventory54.resource SET name='<new_name>' where name='<old_name>';
     51}}}
    4852
     53* Make it active, i.e set INF_status to 1
     54{{{
     55 wget -qO- 'http://new.orbit-lab.org:5054/attribute_modify?name=<new_name&attribute=INF_status&value=1
     56}}}
     57* Change description
     58{{{
     59 wget -qO- 'http://new.orbit-lab.org:5054/attribute_modify?name=<new_name>&attribute=INF_description&value=<new_description>
     60}}}
     61
     62==== Define list of nodes ====
     63
     64* Delete old list of nodes  - currently, there is no possibility to do it trough service, it has to be done into database directly
     65{{{
     66DELETE FROM inventory54.relations WHERE subject_id=(SELECT id FROM inventory54.resources where name='<new_name>');
     67}}}
     68Pay attention, <new_name> is used because name is already changed. If you this before changing the name, than use <old_name>.
     69* Add nodes  - do the flowing for each node that belongs to resource i.e. testbed
     70{{{
     71 wget -qO- 'http://new.orbit-lab.org:5054/relation_add?parent=<new_name>&child=<node_name>
     72}}}