Differences

This shows you the differences between two versions of the page.

--- devel:database [2010/06/18 13:34] – faltin
+++ devel:database [2012/05/07 11:22] (current) – fix url morten
@@ Line 243: / Line 243: @@
 This [[http://domen.uninett.no/~faltin/nav/navdb/netbox_related.png|diagram]] shows OID database (and more).
+The role of the OID database has changed with NAV 3.6. ipdevpoll (that replaces getDeviceData) does not depend
+on the OID database. Cricket still does and getBoksMacs still uses the oid database to figure out device
+capabilities.
 ==== snmpoid ====
@@ Line 334: / Line 338: @@
 rrd_fileid       the rrd file the data source is within
 name             name of the source (ds0,ds1,RESPONSE TIME etc)
-descr            further description
+descr            type of datasource, i.e. ifInOctets, ifInErrors, cpu5min, etc
 dstype           type (DERIVE / GAUGE)
 units            units used on y-axis (seconds, bytes, etc)
@@ Line 546: / Line 550: @@
 vlanid          vlan id (foreign key ref to vlan table, not an actual vlan number)
 direction       Direction of the link, seen from the root of the topology (the vlan's router).
-                'o' = 'Up', 'n' = 'Down', 'x' = ???
+                'o' = 'Up', 'n' = 'Down', 'b' = 'Blocked', 'x' = Unknown
 </code>
@@ Line 647: / Line 651: @@
 <code>
 patchid         primary key
-swportid        reference to the swport the cross connect is connected to
+interfaceid     reference to the swport the cross connect is connected to (foreign key to interface table)
 cablingid       reference to the jakc the cross connect is connected to
 split           If a split cable is used in the jack end, specify type and leaf.
@@ Line 665: / Line 669: @@
 Different subsystem (specified in source) post events on the event queue.
 Normally event engine is the target and will take the event off the event
-queue and process it. getDeviceData are in some cases the target.
+queue and process it (getDeviceData was in some cases the target, not anymore).
 <code>
@@ Line 754: / Line 758: @@
 </code>
-==== alertmsg ====
+==== alertqmsg ====
 Event engine will, based on alertmsg.conf, preformat the alarm messages,
 one message for each configured alert channel (email, sms), one message for
-each configured language. The data are stored in the alertmsg table.
+each configured language. The data are stored in the alertqmsg table.
 <code>
@@ Line 824: / Line 828: @@
 </code>
-==== alertengine ====
-Used by alert engine to keep track of processed alerts.
-<code>
-lastalertqid    value of the last alertqid that alert engine has processed.
-</code>
 ===== Messages =====
@@ Line 923: / Line 921: @@
-===== Traffic map =====
-The traffic map (vlanplot) uses three tables to store values on positioning of
-routers in the graph and on the use of containers.
-This [[http://domen.uninett.no/~faltin/nav/navdb/trafficmap.png|diagram]] shows the releations between the
-traffic map tables.
-Also, see more documentation on the TrafficMap.
-==== vp_netbox_xy ====
-The table is used for positioning nodes (routers) on the traffic map.
-A netbox may be positioned in more than one container (because we show the
-other side of the link, the netboxes themself always only belong to one container).
-<code>
-vp_netbox_xyid        primary key
-pnetboxid             the netboxid of this box (router)
-x                     the X coordinate
-y                     the Y coordinate
-vp_netbox_grp_infoid  reference to the container this node belongs to.
-</code>
-==== vp_netbox_grp_info ====
-The table keeps information on all containers used by the traffic map.
-Editing containers is done in Edit Database.
-<code>
-vp_netbox_grp_infoid  primary key
-name                  name of the container. The top container is named _Top.
-hideicons             boolean. The value has different meanings, see the TrafficMap wiki page.
-iconname              if a name is given and an equivalent icon is placed in the vlanPlot/icons
-                      directory this will be used.
-x                     the X coordinate of the container placement on _Top.
-y                     the Y coordinate of the container placement on _Top.
-</code>
-==== vp_netbox_grp ====
-The table maps netboxes to containers. This information is maintained by Edit Database.
-<code>
-vp_netbox_grp_infoid  the container
-pnetboxid             the netboxid of this box (router)
-</code>
@@ Line 1011: / Line 963: @@
 ==== identity ====
+:!: Not up to date!
 <code>
@@ Line 1017: / Line 971: @@
 blocked_status        boolean
 blocked_reasonid      reason of the block, reference to the blocked_reason table
-swportid              reference to the switch port found in the manage.swport table.
+swportid              reference to the switch port found in the interface table.
                       We find sysname,ip,module and port from this
 swsysname             current sysname of switch, kept for consistency check
@@ Line 1088: / Line 1042: @@
 version...).
-See [[http://metanav.uninett.no/static/reports/NAVMore.pdf|NAVMore report ch 2.4]] (in Norwegian) for a further explaination of
+See [[http://nav.uninett.no/static/reports/NAVMore.pdf|NAVMore report ch 2.4]] (in Norwegian) for a further explaination of
 the NAV Cisco syslog analyzer tool. The chapter also includes a database figure, almost uptodate; the system table no longer exists and there is a newpriority reference from message to priority. For an explanation of the front-end tool, see [[..sysloganalyzer|here]].