Changes between Version 3 and Version 4 of Software/eAM/aInventory/fScheduler
- Timestamp:
- Jun 24, 2013, 2:26:03 PM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Software/eAM/aInventory/fScheduler
v3 v4 32 32 * Make domain active in scheduler database i.e set status to 'a': 33 33 {{{ 34 Update newScheduler.resources set status='a' where name = '<old_ testbed_name>';34 Update newScheduler.resources set status='a' where name = '<old_name>'; 35 35 }}} 36 36 * Change name and description: 37 38 37 {{{ 39 Update newScheduler.resources set name='<new_ testbed_name>', notes='node3-3 i node4-10' where name = '<old_testbed_name>';38 Update newScheduler.resources set name='<new_name>', notes='node3-3 i node4-10' where name = '<old_name>'; 40 39 }}} 41 40 42 41 or with one statement 43 42 {{{ 44 Update newScheduler.resources set status='a', name='<new_ testbed_name>', notes='node3-3 i node4-10' where name ='<old_testbed_name>';43 Update newScheduler.resources set status='a', name='<new_name>', notes='node3-3 i node4-10' where name ='<old_name>'; 45 44 }}} 46 45 47 46 ==== Inventory database ==== 47 * Change name 48 It'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 {{{ 50 UPDATE inventory54.resource SET name='<new_name>' where name='<old_name>'; 51 }}} 48 52 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 {{{ 66 DELETE FROM inventory54.relations WHERE subject_id=(SELECT id FROM inventory54.resources where name='<new_name>'); 67 }}} 68 Pay 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 }}}