Changeset 1283


Ignore:
Timestamp:
01/12/07 16:47:58 (6 years ago)
Author:
ckb6
Message:

Got schema at a state ready for the release of rrdbot-1.0~beta1

Location:
ccsd/trunk/dbschema
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • ccsd/trunk/dbschema/ccs_graphs.exampledata

    r1269 r1283  
    77 
    88-- rrdbot Classes 
    9 INSERT INTO rrdbot_class VALUES (DEFAULT, 'interface', 'ifNumber:count', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 0); 
    10 INSERT INTO rrdbot_class VALUES (DEFAULT, 'wireless', 'lsIndex', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 1); 
    11 INSERT INTO rrdbot_class VALUES (DEFAULT, 'solar', 'battVoltage:exist', 300, 'AVERAGE', '12/hour * 2 days, 1/hour * 1 month, 12/day * 1 year', 0); 
     9INSERT INTO rrdbot_class VALUES (DEFAULT, 'interface', 'ipAdEntIfIndex:walk', 300, 'AVERAGE', '12/hour * 2 days, 2/hour * 2 weeks, 12/day * 10 weeks, 1/day * 800 days', 0, 1, 1,'ifDescr'); 
     10INSERT INTO rrdbot_class VALUES (DEFAULT, 'wireless', 'lsIndex', 300, 'AVERAGE', '12/hour * 2 days, 2/hour * 2 weeks, 12/day * 10 weeks, 1/day * 800 days', 1, 0, 0, ''); 
     11INSERT INTO rrdbot_class VALUES (DEFAULT, 'solar', 'battVoltage:exist', 300, 'AVERAGE', '12/hour * 2 days, 2/hour * 2 weeks, 12/day * 10 weeks, 1/day * 800 days', 0, 0, 0, ''); 
    1212 
    1313INSERT INTO rrdbot_class_parts VALUES (DEFAULT, 1,'ifInOctets','ifInOctets','COUNTER',0,NULL); 
    … …  
    4242INSERT INTO graph_group VALUES (DEFAULT, 'Traffic'); 
    4343INSERT INTO graph_group VALUES (DEFAULT, 'Solar'); 
    44 INSERT INTO graph_group VALUES (DEFAULT, 'SNR'); 
     44INSERT INTO graph_group VALUES (DEFAULT, 'Signal to Noise Ratio'); 
     45INSERT INTO graph_group VALUES (DEFAULT, 'Signal / Noise Levels'); 
    4546 
    46 INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'ifOctets', 'interface','Bits per second'); 
    47 INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'ifErrors', 'interface','Bits per second'); 
    48 INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Voltage', 'solar','Bits per second'); 
     47INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'Traffic Rate', 'interface','Bits per second'); 
     48INSERT INTO graph_type VALUES (DEFAULT, 1, 1, 'Error Rate', 'interface','Bits per second'); 
     49INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Battery Voltage', 'solar','Voltage'); 
     50INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Array Voltage', 'solar','Voltage'); 
     51INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Current', 'solar','Amps'); 
     52INSERT INTO graph_type VALUES (DEFAULT, 2, 3, 'Temperature', 'solar','Deg. Celcius'); 
     53INSERT INTO graph_type VALUES (DEFAULT, 3, 2, 'Signal to Noise Ratio', 'wireless','SNR'); 
     54INSERT INTO graph_type VALUES (DEFAULT, 4, 2, 'Signal / Noise', 'wireless','-dbM'); 
    4955 
    5056INSERT INTO graph_parts VALUES (DEFAULT, 1, 1, 'DEF', 0, 'ifInOctets','val1', 'AVERAGE'); 
    … …  
    5258INSERT INTO graph_parts VALUES (DEFAULT, 1, 2, 'CDEF', 0, 'val1,8,*','cval1', ''); 
    5359INSERT INTO graph_parts VALUES (DEFAULT, 1, 2, 'CDEF', 0, 'val2,8,*','cval2', ''); 
    54 INSERT INTO graph_parts VALUES (DEFAULT, 1, 3, 'LINE2', '0000FF', 'ifInOctets', 'cval1', ''); 
    55 INSERT INTO graph_parts VALUES (DEFAULT, 1, 4, 'LINE2', 'FF0000', 'ifOutOctets', 'cval2', ''); 
     60INSERT INTO graph_parts VALUES (DEFAULT, 1, 3, 'AREA', '00FF00', 'ifInOctets', 'cval1', ''); 
     61INSERT INTO graph_parts VALUES (DEFAULT, 1, 4, 'LINE2', '0000FF', 'ifOutOctets', 'cval2', ''); 
    5662 
    5763INSERT INTO graph_parts VALUES (DEFAULT, 2, 1, 'DEF', 0, 'ifInErrors','val1', 'AVERAGE'); 
    5864INSERT INTO graph_parts VALUES (DEFAULT, 2, 1, 'DEF', 0, 'ifOutErrors','val2', 'AVERAGE'); 
    59 INSERT INTO graph_parts VALUES (DEFAULT, 2, 3, 'LINE2', '0000FF', 'Errors In', 'val1', ''); 
    60 INSERT INTO graph_parts VALUES (DEFAULT, 2, 4, 'LINE2', 'FF0000', 'Errors out', 'val2', ''); 
     65INSERT INTO graph_parts VALUES (DEFAULT, 2, 3, 'AREA', '00FF00', 'Errors In', 'val1', ''); 
     66INSERT INTO graph_parts VALUES (DEFAULT, 2, 4, 'LINE2', '0000FF', 'Errors out', 'val2', ''); 
    6167 
    6268INSERT INTO graph_parts VALUES (DEFAULT, 3, 1, 'DEF', 0, 'battVoltage','val1', 'AVERAGE'); 
    … …  
    6470INSERT INTO graph_parts VALUES (DEFAULT, 3, 2, 'CDEF', 0, 'val1,1000,/','cval1', ''); 
    6571INSERT INTO graph_parts VALUES (DEFAULT, 3, 2, 'CDEF', 0, 'val2,1000,/','cval2', ''); 
    66 INSERT INTO graph_parts VALUES (DEFAULT, 3, 3, 'AREA', '0000FF', 'Batt Voltage', 'cval1', ''); 
    67 INSERT INTO graph_parts VALUES (DEFAULT, 3, 4, 'LINE2', 'FF0000', 'Sense Voltage', 'cval2', ''); 
     72INSERT INTO graph_parts VALUES (DEFAULT, 3, 3, 'AREA', '00FF00', 'Batt Voltage', 'cval1', ''); 
     73INSERT INTO graph_parts VALUES (DEFAULT, 3, 4, 'LINE2', '0000FF', 'Sense Voltage', 'cval2', ''); 
    6874 
    69 INSERT INTO graph_time VALUES ( DEFAULT, '-1h', 'now', 'Hour'); 
    70 INSERT INTO graph_time VALUES ( DEFAULT, '-1d', 'now', 'Day'); 
    71 INSERT INTO graph_time VALUES ( DEFAULT, '-1m', 'now', 'Month'); 
    72 INSERT INTO graph_time VALUES ( DEFAULT, '-1y', 'now', 'Year'); 
     75INSERT INTO graph_parts VALUES (DEFAULT, 4, 1, 'DEF', 0, 'arrayVoltage','val1', 'AVERAGE'); 
     76INSERT INTO graph_parts VALUES (DEFAULT, 4, 1, 'DEF', 0, 'refVoltage','val2', 'AVERAGE'); 
     77INSERT INTO graph_parts VALUES (DEFAULT, 4, 2, 'CDEF', 0, 'val1,1000,/','cval1', ''); 
     78INSERT INTO graph_parts VALUES (DEFAULT, 4, 2, 'CDEF', 0, 'val2,1000,/','cval2', ''); 
     79INSERT INTO graph_parts VALUES (DEFAULT, 4, 3, 'AREA', '00FF00', 'Array Voltage', 'cval1', ''); 
     80INSERT INTO graph_parts VALUES (DEFAULT, 4, 4, 'LINE2', '0000FF', 'Reference Voltage', 'cval2', ''); 
    7381 
    74 INSERT INTO snmp_state VALUES ( 0); 
     82INSERT INTO graph_parts VALUES (DEFAULT, 5, 1, 'DEF', 0, 'loadCurrent','val1', 'AVERAGE'); 
     83INSERT INTO graph_parts VALUES (DEFAULT, 5, 1, 'DEF', 0, 'chargeCurrent','val2', 'AVERAGE'); 
     84INSERT INTO graph_parts VALUES (DEFAULT, 5, 2, 'CDEF', 0, 'val1,1000,/','cval1', ''); 
     85INSERT INTO graph_parts VALUES (DEFAULT, 5, 2, 'CDEF', 0, 'val2,1000,/','cval2', ''); 
     86INSERT INTO graph_parts VALUES (DEFAULT, 5, 3, 'AREA', '00FF00', 'Load Current', 'cval1', ''); 
     87INSERT INTO graph_parts VALUES (DEFAULT, 5, 4, 'LINE2', '0000FF', 'Charge Current', 'cval2', ''); 
     88 
     89INSERT INTO graph_parts VALUES (DEFAULT, 6, 1, 'DEF', 0, 'hstemp','val1', 'AVERAGE'); 
     90INSERT INTO graph_parts VALUES (DEFAULT, 6, 1, 'DEF', 0, 'battemp','val2', 'AVERAGE'); 
     91INSERT INTO graph_parts VALUES (DEFAULT, 6, 2, 'AREA', '00FF00', 'Heatsink Temp', 'val1', ''); 
     92INSERT INTO graph_parts VALUES (DEFAULT, 6, 3, 'LINE2', '0000FF', 'Battery Temp', 'val2', ''); 
     93 
     94INSERT INTO graph_parts VALUES (DEFAULT, 7, 1, 'DEF', 0, 'linkCurrentSignal','val1', 'AVERAGE'); 
     95INSERT INTO graph_parts VALUES (DEFAULT, 7, 1, 'DEF', 0, 'linkCurrentNoise','val2', 'AVERAGE'); 
     96INSERT INTO graph_parts VALUES (DEFAULT, 7, 2, 'CDEF', 0, 'val1,val2,-','snr', ''); 
     97INSERT INTO graph_parts VALUES (DEFAULT, 7, 3, 'LINE2', '00FF00', 'SNR', 'snr', ''); 
     98 
     99INSERT INTO graph_parts VALUES (DEFAULT, 8, 1, 'DEF', 0, 'linkCurrentSignal','val1', 'AVERAGE'); 
     100INSERT INTO graph_parts VALUES (DEFAULT, 8, 1, 'DEF', 0, 'linkCurrentNoise','val2', 'AVERAGE'); 
     101INSERT INTO graph_parts VALUES (DEFAULT, 8, 2, 'CDEF', 0, 'val1,1000,/,-1,*','cval1', ''); 
     102INSERT INTO graph_parts VALUES (DEFAULT, 8, 2, 'CDEF', 0, 'val2,1000,/,-1,*','cval2', ''); 
     103INSERT INTO graph_parts VALUES (DEFAULT, 8, 3, 'AREA', '00FF00', 'Signal', 'cval1', ''); 
     104INSERT INTO graph_parts VALUES (DEFAULT, 8, 4, 'LINE2', '0000FF', 'Noise', 'cval2', ''); 
     105 
    75106-- vim: ft=sql 

  • ccsd/trunk/dbschema/ccs_graphs.schema

    r1269 r1283  
    1717    cf          varchar(8), 
    1818    archive     varchar(256), 
    19     depends     integer         DEFAULT 0 
     19    depends     integer         DEFAULT 0, 
     20    ipfromoid   integer, 
     21    skip_software_loop  integer, 
     22    key         varchar(64) 
    2023); 
    2124 
    … …  
    100103 
    101104create view rrdbotlog as select a.host_id, a.class_id, c.class_name, b.host_name, a.num, a.ip_address, a.timestamp, a.link_id, d.description from snmp_discovery a LEFT JOIN link d on a.link_id=d.link_id, host b, rrdbot_class c where b.host_id=a.host_id and c.class_id=a.class_id; 
     105 
     106-- Required values for graphs 
     107INSERT INTO graph_time VALUES ( DEFAULT, '-1h', 'now', 'Hour'); 
     108INSERT INTO graph_time VALUES ( DEFAULT, '-1d', 'now', 'Day'); 
     109INSERT INTO graph_time VALUES ( DEFAULT, '-1w', 'now', 'Week'); 
     110INSERT INTO graph_time VALUES ( DEFAULT, '-1m', 'now', 'Month'); 
     111INSERT INTO graph_time VALUES ( DEFAULT, '-1y', 'now', 'Year'); 
     112 
     113INSERT INTO graph_time VALUES ( DEFAULT, '-2h', '-1h', 'Last Hour'); 
     114INSERT INTO graph_time VALUES ( DEFAULT, '-2d', '-1d', 'Yesturday'); 
     115INSERT INTO graph_time VALUES ( DEFAULT, '-2w', '-1w', 'Last Week'); 
     116INSERT INTO graph_time VALUES ( DEFAULT, '-2m', '-1m', 'Last Month'); 
     117INSERT INTO graph_time VALUES ( DEFAULT, '-2y', '-1y', 'Last Year'); 
     118 
     119 
     120-- Set the initial state 
     121INSERT INTO snmp_state VALUES ( 0); 
    102122-- vim: ft=sql 
Note: See TracChangeset for help on using the changeset viewer.