Mercurial > templog
annotate web/log.py @ 409:1854abee5a59
add debug url
| author | Matt Johnston <matt@ucc.asn.au> |
|---|---|
| date | Thu, 02 Aug 2012 22:11:13 +0800 |
| parents | 36a33c56c383 |
| children | 7f3fc0980df1 |
| rev | line source |
|---|---|
| 384 | 1 # -*- coding: utf-8 -*- |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
2 #:vim:et:ts=4:sts=4:sw=4: |
| 333 | 3 import rrdtool |
| 4 import os | |
| 335 | 5 import os.path |
| 333 | 6 import sys |
| 335 | 7 import glob |
|
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
8 import hashlib |
|
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
9 import tempfile |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
10 import time |
|
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
11 import syslog |
| 349 | 12 import sqlite3 |
|
355
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
13 import traceback |
| 373 | 14 import datetime |
|
381
83c83014e5e3
report raw ds18b20 values instead
Matt Johnston <matt@ucc.asn.au>
parents:
379
diff
changeset
|
15 import struct |
| 383 | 16 import binascii |
| 335 | 17 from colorsys import hls_to_rgb |
| 333 | 18 |
| 334 | 19 import config |
| 333 | 20 |
| 21 def sensor_rrd_path(s): | |
| 334 | 22 return '%s/sensor_%s.rrd' % (config.DATA_PATH, s) |
| 333 | 23 |
| 335 | 24 # returns (path, sensor_name) tuples |
| 25 def all_sensors(): | |
| 26 return [(r, os.path.basename(r[:-4])) | |
| 27 for r in glob.glob('%s/*.rrd' % config.DATA_PATH)] | |
| 28 | |
| 333 | 29 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
|
30 # 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
|
31 # update with prior values straight away. |
| 367 | 32 if 'voltage' in sensor_id: |
| 369 | 33 args = [ |
| 34 '--step', '3600', | |
| 35 'DS:temp:GAUGE:7200:1:10', | |
| 36 'RRA:AVERAGE:0.5:1:87600'] | |
| 367 | 37 else: |
| 369 | 38 args = [ |
| 39 '--step', '300', | |
|
394
2cd246ea92c6
increase temperature logging range
Matt Johnston <matt@ucc.asn.au>
parents:
384
diff
changeset
|
40 'DS:temp:GAUGE:600:-100:500', |
| 367 | 41 'RRA:AVERAGE:0.5:1:1051200'] |
| 333 | 42 |
| 367 | 43 rrdtool.create(sensor_rrd_path(sensor_id), |
| 369 | 44 '--start', 'now-60d', |
| 367 | 45 *args) |
| 335 | 46 |
| 47 # stolen from viewmtn, stolen from monotone-viz | |
| 48 def colour_from_string(str): | |
| 49 def f(off): | |
| 50 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
|
51 hashval = hashlib.sha1(str).digest() |
| 335 | 52 hue = f(5) |
| 53 li = f(1) * 0.15 + 0.55 | |
| 54 sat = f(2) * 0.5 + .5 | |
| 55 return ''.join(["%.2x" % int(x * 256) for x in hls_to_rgb(hue, li, sat)]) | |
| 56 | |
| 57 def graph_png(start, length): | |
| 58 rrds = all_sensors() | |
| 59 | |
| 60 graph_args = [] | |
| 367 | 61 have_volts = False |
| 335 | 62 for n, (rrdfile, sensor) in enumerate(rrds): |
| 367 | 63 if 'avrtemp' in sensor: |
| 64 continue | |
| 65 if 'voltage' in sensor: | |
| 66 have_volts = True | |
| 67 vname = 'scalevolts' | |
|
377
55710361804b
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
375
diff
changeset
|
68 graph_args.append('DEF:%(vname)s=%(rrdfile)s:temp:AVERAGE:step=3600' % locals()) |
| 384 | 69 unit = 'V' |
| 367 | 70 else: |
| 71 vname = 'temp%d' % n | |
|
377
55710361804b
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
375
diff
changeset
|
72 graph_args.append('DEF:raw%(vname)s=%(rrdfile)s:temp:AVERAGE' % locals()) |
|
407
36a33c56c383
limit temps to 35º on graph
Matt Johnston <matt@ucc.asn.au>
parents:
405
diff
changeset
|
73 # limit max temp to 50 |
|
36a33c56c383
limit temps to 35º on graph
Matt Johnston <matt@ucc.asn.au>
parents:
405
diff
changeset
|
74 graph_args.append('CDEF:%(vname)s=raw%(vname)s,35,GT,UNKN,raw%(vname)s,0.1,*,2,+,IF' % locals()) |
| 384 | 75 unit = '<span face="Liberation Serif">º</span>C' |
| 76 | |
| 77 last_value = float(rrdtool.info(rrdfile)['ds[temp].last_ds']) | |
| 335 | 78 width = config.LINE_WIDTH |
| 79 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
|
80 colour = config.SENSOR_COLOURS.get(legend, colour_from_string(sensor)) |
| 384 | 81 format_last_value = ('%f' % last_value).rstrip('0') + unit |
| 82 print_legend = '%s (%s)' % (legend, format_last_value) | |
| 83 graph_args.append('LINE%(width)f:%(vname)s#%(colour)s:%(print_legend)s' % locals()) | |
| 335 | 84 |
| 373 | 85 end = int(start+length) |
| 86 start = int(start) | |
| 87 | |
| 335 | 88 tempf = tempfile.NamedTemporaryFile() |
| 373 | 89 dateformat = '%H:%M:%S %Y-%m-%d' |
| 90 watermark = ("Now %s\t" | |
| 91 "Start %s\t" | |
| 92 "End %s" % ( | |
| 93 datetime.datetime.now().strftime(dateformat), | |
| 94 datetime.datetime.fromtimestamp(start).strftime(dateformat), | |
| 95 datetime.datetime.fromtimestamp(end).strftime(dateformat) )) | |
| 96 | |
| 97 args = [tempf.name, '-s', str(start), | |
| 98 '-e', str(end), | |
|
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
99 '-w', str(config.GRAPH_WIDTH), |
|
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
100 '-h', str(config.GRAPH_HEIGHT), |
| 335 | 101 '--slope-mode', |
|
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
102 '--border', '0', |
|
379
fed6738be1ab
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
377
diff
changeset
|
103 # '--vertical-label', 'Voltage', |
|
377
55710361804b
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
375
diff
changeset
|
104 '--y-grid', '0.1:1', |
|
55710361804b
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
375
diff
changeset
|
105 '--dynamic-labels', |
| 362 | 106 '--grid-dash', '1:0', |
| 383 | 107 '--zoom', str(config.ZOOM), |
| 362 | 108 '--color', 'GRID#00000000', |
| 109 '--color', 'MGRID#aaaaaa', | |
|
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
110 '--color', 'BACK#ffffff', |
| 373 | 111 '--disable-rrdtool-tag', |
| 384 | 112 '--pango-markup', |
| 373 | 113 '--watermark', watermark, |
|
337
f575ef538f5d
- Various fixes for web server, kind of works
Matt Johnston <matt@ucc.asn.au>
parents:
335
diff
changeset
|
114 '--imgformat', 'PNG'] \ |
| 335 | 115 + graph_args |
| 373 | 116 args += ['--font', 'DEFAULT:12:%s' % config.GRAPH_FONT] |
| 117 args += ['--font', 'WATERMARK:10:%s' % config.GRAPH_FONT] | |
| 367 | 118 if have_volts: |
|
377
55710361804b
swap the left and right scales, kind of clunky
Matt Johnston <matt@ucc.asn.au>
parents:
375
diff
changeset
|
119 args += ['--right-axis', '10:-20', # matches the scalevolts CDEF above |
|
379
fed6738be1ab
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
377
diff
changeset
|
120 '--right-axis-format', '%.0lf', |
|
fed6738be1ab
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
377
diff
changeset
|
121 # '--right-axis-label', 'Temperature' |
|
fed6738be1ab
Get rid of axes labels, tidy html
Matt Johnston <matt@ucc.asn.au>
parents:
377
diff
changeset
|
122 ] |
| 367 | 123 |
| 335 | 124 rrdtool.graph(*args) |
| 125 return tempf.read() | |
| 126 | |
| 333 | 127 def sensor_update(sensor_id, measurements, first_real_time, time_step): |
| 128 try: | |
| 129 open(sensor_rrd_path(sensor_id)) | |
| 130 except IOError, e: | |
| 131 create_rrd(sensor_id) | |
| 132 | |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
133 if measurements: |
|
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
134 values = ['%d:%f' % p for p in |
|
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
135 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
|
136 measurements)] |
| 333 | 137 |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
138 rrdfile = sensor_rrd_path(sensor_id) |
| 346 | 139 # 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
|
140 for v in values: |
|
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
141 try: |
|
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
142 rrdtool.update(rrdfile, v) |
| 369 | 143 except rrdtool.error, e: |
|
355
a1aa4176ca2c
update values one at a time, ignore failure
Matt Johnston <matt@ucc.asn.au>
parents:
351
diff
changeset
|
144 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
|
145 traceback.print_exc(file=sys.stderr) |
|
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
146 |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
147 # be paranoid |
|
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
148 f = file(rrdfile) |
|
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
149 os.fsync(f.fileno()) |
| 333 | 150 |
| 409 | 151 def debug_file(mode='r'): |
| 152 return open('%s/debug.log' % config.DATA_PATH, mode) | |
| 153 | |
|
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
154 def record_debug(lines): |
| 409 | 155 f = debug_file('a+') |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
156 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
|
157 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
|
158 f.flush() |
|
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
159 return f |
|
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
160 |
| 409 | 161 |
| 162 def tail_debug_log(): | |
| 163 f = debug_file() | |
| 164 f.seek(0, 2) | |
| 165 size = f.tell() | |
| 166 f.seek(max(0, size-30000)) | |
| 167 return '\n'.join(l.strip() for l in f.readlines()[-400:]) | |
| 168 | |
|
381
83c83014e5e3
report raw ds18b20 values instead
Matt Johnston <matt@ucc.asn.au>
parents:
379
diff
changeset
|
169 def convert_ds18b20_12bit(reading): |
|
83c83014e5e3
report raw ds18b20 values instead
Matt Johnston <matt@ucc.asn.au>
parents:
379
diff
changeset
|
170 value = struct.unpack('>h', binascii.unhexlify(reading))[0] |
|
83c83014e5e3
report raw ds18b20 values instead
Matt Johnston <matt@ucc.asn.au>
parents:
379
diff
changeset
|
171 return value * 0.0625 |
|
83c83014e5e3
report raw ds18b20 values instead
Matt Johnston <matt@ucc.asn.au>
parents:
379
diff
changeset
|
172 |
| 400 | 173 def time_rem(name, entries): |
| 174 val_ticks = int(entries[name]) | |
| 401 | 175 val_rem = int(entries['%s_rem' % name]) |
|
405
d9b78a1bdd1d
fix off-by-one in remainder code
Matt Johnston <matt@ucc.asn.au>
parents:
401
diff
changeset
|
176 tick_wake = int(entries['tick_wake']) + 1 |
| 400 | 177 tick_secs = int(entries['tick_secs']) |
| 178 return val_ticks + float(val_rem) * tick_secs / tick_wake | |
| 179 | |
| 333 | 180 def parse(lines): |
|
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
181 |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
182 debugf = record_debug(lines) |
|
339
449272fc63a3
- Debug log file for server
Matt Johnston <matt@ucc.asn.au>
parents:
338
diff
changeset
|
183 |
| 333 | 184 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
|
185 if len(entries) != len(lines): |
| 333 | 186 raise Exception("Keys are not unique") |
| 187 | |
| 188 num_sensors = int(entries['sensors']) | |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
189 num_measurements = int(entries['measurements']) |
| 333 | 190 |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
191 sensors = [entries['sensor_id%d' % n] for n in xrange(num_sensors)] |
| 333 | 192 |
| 193 meas = [] | |
| 194 for s in sensors: | |
| 195 meas.append([]) | |
| 196 | |
| 197 for n in xrange(num_measurements): | |
| 383 | 198 vals = [convert_ds18b20_12bit(x) for x in entries["meas%d" % n].strip().split()] |
| 333 | 199 if len(vals) != num_sensors: |
| 200 raise Exception("Wrong number of sensors for measurement %d" % n) | |
| 201 # we make an array of values for each sensor | |
| 202 for s in xrange(num_sensors): | |
| 203 meas[s].append(vals[s]) | |
| 204 | |
| 400 | 205 avr_now = time_rem('now', entries) |
| 206 avr_first_time = time_rem('first_time', entries) | |
| 207 avr_comms_time = time_rem('comms_time', entries) | |
| 333 | 208 time_step = float(entries['time_step']) |
| 209 | |
| 400 | 210 debugf.write('now %f, comms_time %f, first_time %f, delta %f\n' % |
| 211 (avr_now, avr_comms_time, avr_first_time, avr_now - avr_comms_time)) | |
| 212 | |
| 367 | 213 if 'avrtemp' in entries: |
| 214 avrtemp = val_scale(int(entries['avrtemp'])) | |
| 215 sensor_update('avrtemp', [avrtemp], time.time(), 1) | |
| 216 | |
| 217 if 'voltage' in entries: | |
| 218 voltage = 0.001 * int(entries['voltage']) | |
| 219 sensor_update('voltage', [voltage], time.time(), 1) | |
| 220 | |
| 346 | 221 #sqlite |
| 222 # - time | |
| 223 # - voltage | |
| 224 # - boot time | |
| 225 | |
| 333 | 226 first_real_time = time.time() - (avr_now - avr_first_time) |
| 227 | |
| 228 for sensor_id, measurements in zip(sensors, meas): | |
| 346 | 229 # XXX sqlite add |
| 333 | 230 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
|
231 |
|
344
ea1779d27641
- Getting there, update has problems
Matt Johnston <matt@ucc.asn.au>
parents:
339
diff
changeset
|
232 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
|
233 debugf.flush() |