Mercurial > templog
annotate web/log.py @ 367:3db118498b97
sort out voltage logging
author | Matt Johnston <matt@ucc.asn.au> |
---|---|
date | Tue, 26 Jun 2012 08:08:48 +0800 |
parents | 8fea6144951b |
children | 43ec670f1b75 |
rev | line source |
---|---|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
1 #:vim:et:ts=4:sts=4:sw=4: |
333 | 2 import rrdtool |
3 import os | |
335 | 4 import os.path |
333 | 5 import sys |
335 | 6 import glob |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
7 import hashlib |
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
8 import tempfile |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
9 import time |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
10 import syslog |
349 | 11 import sqlite3 |
355
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
12 import traceback |
335 | 13 from colorsys import hls_to_rgb |
333 | 14 |
334 | 15 import config |
333 | 16 |
17 def sensor_rrd_path(s): | |
334 | 18 return '%s/sensor_%s.rrd' % (config.DATA_PATH, s) |
333 | 19 |
335 | 20 # returns (path, sensor_name) tuples |
21 def all_sensors(): | |
22 return [(r, os.path.basename(r[:-4])) | |
23 for r in glob.glob('%s/*.rrd' % config.DATA_PATH)] | |
24 | |
333 | 25 def create_rrd(sensor_id): |
350
03322c38b4a9
Create with a start date so that it works
Matt Johnston <matt@ucc.asn.au>
parents:
346
diff
changeset
|
26 # start date of 10 seconds into 1970 is used so that we can |
03322c38b4a9
Create with a start date so that it works
Matt Johnston <matt@ucc.asn.au>
parents:
346
diff
changeset
|
27 # update with prior values straight away. |
367 | 28 if 'voltage' in sensor_id: |
29 args = [ 'DS:temp:GAUGE:7200:-1:10', | |
30 'RRA:AVERAGE:0.9999:1:1051200'] | |
31 else: | |
32 args = [ 'DS:temp:GAUGE:600:-10:100', | |
33 'RRA:AVERAGE:0.5:1:1051200'] | |
333 | 34 |
367 | 35 rrdtool.create(sensor_rrd_path(sensor_id), |
36 '--start', '10', | |
37 '--step', '300', | |
38 *args) | |
335 | 39 |
40 # stolen from viewmtn, stolen from monotone-viz | |
41 def colour_from_string(str): | |
42 def f(off): | |
43 return ord(hashval[off]) / 256.0 | |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
44 hashval = hashlib.sha1(str).digest() |
335 | 45 hue = f(5) |
46 li = f(1) * 0.15 + 0.55 | |
47 sat = f(2) * 0.5 + .5 | |
48 return ''.join(["%.2x" % int(x * 256) for x in hls_to_rgb(hue, li, sat)]) | |
49 | |
50 def graph_png(start, length): | |
51 rrds = all_sensors() | |
52 | |
53 graph_args = [] | |
367 | 54 have_volts = False |
335 | 55 for n, (rrdfile, sensor) in enumerate(rrds): |
367 | 56 if 'avrtemp' in sensor: |
57 continue | |
58 if 'voltage' in sensor: | |
59 have_volts = True | |
60 vname = 'scalevolts' | |
61 graph_args = ['DEF:rawvolts=%(rrdfile)s:temp:AVERAGE:step=3600' % locals(), | |
62 'CDEF:scalevolts=rawvolts,0.2,/'] + graph_args | |
63 else: | |
64 vname = 'temp%d' % n | |
65 graph_args.append('DEF:%(vname)s=%(rrdfile)s:temp:AVERAGE' % locals()) | |
335 | 66 width = config.LINE_WIDTH |
67 legend = config.SENSOR_NAMES.get(sensor, sensor) | |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
68 colour = config.SENSOR_COLOURS.get(legend, colour_from_string(sensor)) |
335 | 69 graph_args.append('LINE%(width)f:%(vname)s#%(colour)s:%(legend)s' % locals()) |
70 | |
71 tempf = tempfile.NamedTemporaryFile() | |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
72 args = [tempf.name, '-s', str(int(start)), |
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
73 '-e', str(int(start+length)), |
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
74 '-w', str(config.GRAPH_WIDTH), |
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
75 '-h', str(config.GRAPH_HEIGHT), |
335 | 76 '--slope-mode', |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
77 '--border', '0', |
367 | 78 '--vertical-label', 'Temperature', |
362 | 79 '--y-grid', '1:1', |
80 '--grid-dash', '1:0', | |
81 '--color', 'GRID#00000000', | |
82 '--color', 'MGRID#aaaaaa', | |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
83 '--color', 'BACK#ffffff', |
367 | 84 'VRULE:%d#ee0000' % time.time(), |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
85 '--imgformat', 'PNG'] \ |
335 | 86 + graph_args |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
87 if config.GRAPH_FONT: |
362 | 88 args += ['--font', 'DEFAULT:11:%s' % config.GRAPH_FONT] |
367 | 89 if have_volts: |
90 args += ['--right-axis', '0.2:0', # matches the scalevolts CDEF above | |
91 '--right-axis-format', '%.2lf', | |
92 '--right-axis-label', 'Voltage'] | |
93 | |
335 | 94 rrdtool.graph(*args) |
95 return tempf.read() | |
96 | |
333 | 97 def sensor_update(sensor_id, measurements, first_real_time, time_step): |
98 try: | |
99 open(sensor_rrd_path(sensor_id)) | |
100 except IOError, e: | |
101 create_rrd(sensor_id) | |
102 | |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
103 if measurements: |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
104 values = ['%d:%f' % p for p in |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
105 zip((first_real_time + time_step*t for t in xrange(len(measurements))), |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
106 measurements)] |
333 | 107 |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
108 rrdfile = sensor_rrd_path(sensor_id) |
346 | 109 # XXX what to do here when it fails... |
355
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
110 for v in values: |
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
111 try: |
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
112 rrdtool.update(rrdfile, v) |
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
113 except Exception, e: |
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
114 print>>sys.stderr, "Bad rrdtool update '%s'" % v |
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
115 traceback.print_exc(file=sys.stderr) |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
116 |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
117 # be paranoid |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
118 f = file(rrdfile) |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
119 os.fsync(f.fileno()) |
333 | 120 |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
121 def record_debug(lines): |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
122 f = open('%s/debug.log' % config.DATA_PATH, 'a+') |
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
123 f.write('===== %s =====\n' % time.strftime('%a, %d %b %Y %H:%M:%S')) |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
124 f.writelines(('%s\n' % s for s in lines)) |
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
125 f.flush() |
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
126 return f |
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
127 |
333 | 128 def parse(lines): |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
129 |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
130 debugf = record_debug(lines) |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
131 |
333 | 132 entries = dict(l.split('=', 1) for l in lines) |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
133 if len(entries) != len(lines): |
333 | 134 raise Exception("Keys are not unique") |
135 | |
136 num_sensors = int(entries['sensors']) | |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
137 num_measurements = int(entries['measurements']) |
333 | 138 |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
139 sensors = [entries['sensor_id%d' % n] for n in xrange(num_sensors)] |
333 | 140 |
141 meas = [] | |
142 for s in sensors: | |
143 meas.append([]) | |
144 | |
334 | 145 def val_scale(v): |
146 # convert decidegrees to degrees | |
147 return 0.1 * v | |
148 | |
333 | 149 for n in xrange(num_measurements): |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
150 vals = [val_scale(int(x)) for x in entries["meas%d" % n].strip().split()] |
333 | 151 if len(vals) != num_sensors: |
152 raise Exception("Wrong number of sensors for measurement %d" % n) | |
153 # we make an array of values for each sensor | |
154 for s in xrange(num_sensors): | |
155 meas[s].append(vals[s]) | |
156 | |
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
157 avr_now = float(entries['now']) |
333 | 158 avr_first_time = float(entries['first_time']) |
159 time_step = float(entries['time_step']) | |
160 | |
367 | 161 if 'avrtemp' in entries: |
162 avrtemp = val_scale(int(entries['avrtemp'])) | |
163 sensor_update('avrtemp', [avrtemp], time.time(), 1) | |
164 | |
165 if 'voltage' in entries: | |
166 voltage = 0.001 * int(entries['voltage']) | |
167 sensor_update('voltage', [voltage], time.time(), 1) | |
168 | |
346 | 169 #sqlite |
170 # - time | |
171 # - voltage | |
172 # - boot time | |
173 | |
333 | 174 first_real_time = time.time() - (avr_now - avr_first_time) |
175 | |
176 for sensor_id, measurements in zip(sensors, meas): | |
346 | 177 # XXX sqlite add |
333 | 178 sensor_update(sensor_id, measurements, first_real_time, time_step) |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
179 |
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
180 debugf.write("Updated %d sensors\n" % len(sensors)) |
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
181 debugf.flush() |