Changes between Version 20 and Version 21 of Internal/InventoryV3

Timestamp:

Nov 24, 2009, 4:37:13 AM (15 years ago)

Author:

ssugrim

Comment:

—

Internal/InventoryV3

@@ -1 +1 @@
 James is working on a second generation inventory script.
 
-Currently on: reorganising code
+Currently on: integrate lshw fully, verify data, tweak writer
 
 Versions:
 
-Gather:0.87
-Writer:0.9
+* Gather:0.87
+* Writer:0.97
 
 It's plan is to be simpler and less ambitious than it's predecessor, but still respect the sql table structure ("as much as possible.") 
@@ -14 +14 @@
  1. executer: runs either wget or apt-get install and copies the latest version of the other parts of the scripts then 
     executes them
- 1. gatherer: collects information using only  operating system based facilities (dmesg, lsusb, lspci, ifconfig, /sys).  
+    '''DEPRECIATED''' - In lieu of image updates. 
+ 1. gatherer: collects information using only  operating system based facilities (dmesg, lsusb, lspci, ifconfig, /sys, lshw).  
  1. Writer: checks the mysql repository for changes from the current state. If different changes them.
 
-'''NOTE''' Gatherer and Writer are being merged into a single file which I will call inventory2_client.rb
 
 The sql structure is a bit of a bit mess, the major tables of interest are:
@@ -23 +23 @@
  1. devices - List of deviced "connected" to mother boards 
  1. device_kinds - type identifier for connected devices (an attribute of a device). 
- 1. locations - Converts x,y coordinates to a single integer that maps directly to a mother board.
+ 1. locations - Converts x,y,testbed_id coordinates to a single integer
+ 1. nodes - maps motherboard to locations, also has an id for said mapping
  1. inventories - records the start and stop time of the inventory pass.
  1. testbeds - gives a testbed id for the specific domain, thus disambiguating node1-1
@@ -29 +30 @@
 A lot of the tables are full of unused colums. I guess we'll just ignore them for now. 
 The basic crux of an update should be the following:
- 1. examine our IP to determine our current location
+ 1. examine our IP (and hostname) to determine our current location
  1. We gather information about the mother board:
  1. '''Gatherer:'''
@@ -35 +36 @@
   1. Memory Size (dmesg)
   1. Cpu number (dmesg)
+  1. motherboard serial number (lshw)
   1. Gather information about attached devices:
    1. 2 wired Ethernet addresses (ifconfig, /sys)
    1. 2 wireless Ethernet addresses (ifconfig, /sys)
    1. any usb devices (lsusb, /sys)
+ 1. export to xml
+
  1. '''Writer:'''
-  1. get the mother board id from the location table
-  1. update mother board information if diffrent, and stamp with current inventory number
+  1. import xml output from gatherer
+  1. collect identifiers from mysql based on gathered infromation (domain => testbed_id ;x,y,testbed_id => loc_id;
+     mb_ser => mb_id ; loc_id => node_id ; )
+  1. update mother board information if different, and stamp with current inventory number
   1. add kinds if they don't exist already
   1. update devices if diffrent and stamp with inventory number
+  1. update node mb_id if loc, mb pair don't match
  1. profit.
 
@@ -245 +252 @@
    pretty close to this, but needs a little work.
 
+=== 11/23/09 ===
+
+The previous was completed. There was a two bugs that needed tweaking
+ * Update node did not update the inventory when it updated a node info. 
+ * Had to add a hack to prevent unknown dev_ids from getting double entered in update_adds when the id is unknown. If the device has 
+   multiple instances of a pice of unknown hardware (like 2 new Ethernet cards), the current routine will double add them. 
+  * this hack should be re-visited for efficiency, currently it double checks for a kind (in case one was added after the adds_array 
+    was populated). This is very wasteful as the missing kinds should be a rare event. I should probably switch to a different function
+    or something if I've entered the rare "never seen it before" scenario.