Sat, 27 Apr 2019 13:08:53 +0200
Inverted door open led
0 | 1 | Centrale daemon 'bmsd' regelt de dagelijkse berichten tussen MQTT en de |
2 | database. Om deze berichten betrouwbaar af te handelen is MQTT er tussen | |
3 | gezet. | |
4 | Alle sensoren en controllers communiceren uitsluitend via MQTT. | |
5 | ||
6 | Sensoren en controllers: | |
7 | ||
8 | 1. Vergisting controllers. | |
9 | 2. Temperatuur loggen. | |
10 | 3. Hergisting drukmeters. (druk + temp). | |
11 | 4. Brouw controllers. | |
12 | 5. Ispindel. | |
13 | ||
14 | ||
15 | Stappen: | |
16 | ||
17 | 1. Importeren oude vergisting en brouw logs. DONE. | |
18 | 2. Thermferm moet DLOG berichten gaan sturen, per wijziging en per 5 minuten. DONE. | |
19 | 3. bmsd moet deze DLOG berichten verwerken. Versie 0.0.2. Bier producten in database. DONE. | |
20 | 4. Versie 0.0.2 handmatig installeren op productie. DONE. | |
21 | 5. Thermferm uitbreiden met vergisting stage. DONE. | |
104 | 22 | 6. Brouw controller uitbreiden met MQTT. Niet, ESP32 wordt onstabiel. |
23 | 7. bmsd uitbreiden met brouw controller berichten. Niet, zie hierboven. | |
24 | 8. bmsd productie platform upgraden, versie 0.0.3 DONE. | |
268 | 25 | 9. bmsd recepten editor implementeren. DONE. |
26 | 10. bmsd uitbreiden met productie (brews) stappen, met hierin recepten. DONE. | |
325
9a8c650972ca
Update some documentation. Thermometer gauges animate easing
Michiel Broek <mbroek@mbse.eu>
parents:
314
diff
changeset
|
27 | 11. bmsd koppelen logs aan productie. DONE. |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
20
diff
changeset
|
28 | |
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
0
diff
changeset
|
29 | |
0 | 30 | |
31 | ||
32 | MQTT structuur volgens Sparkplug model. | |
33 | ||
34 | mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/ | |
35 | mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/ | |
36 | ||
37 | --------------------------------------------------------------------------- | |
38 | ||
39 | namespace/group_id/message_type/edge_node_id/{device_id} | |
40 | ||
41 | namespace is de root, "mbv1.0" | |
42 | ||
43 | group_id oa: fermenters, brewcontrol, env_sensor | |
44 | ||
45 | message_type: NBIRTH - Birth certificate for MQTT EoN nodes. | |
46 | NDEATH - Death certificate for MQTT EoN nodes. | |
47 | NCMD - Node command message. | |
48 | DBIRTH - Birth certificate for devices. | |
49 | DDEATH - Death certificate for devices. | |
50 | NDATA - Node data message. | |
51 | DDATA - Device data message. | |
52 | DLOG - Device data logging. | |
53 | DCMD - Device command message. | |
54 | STATE - Critical application state message. | |
55 | ||
56 | NCMD: reboot (application restart) | |
57 | rebirth | |
58 | ||
59 | DCMD: fermenter state change + temperature settings. | |
60 | fermenter profile install. | |
61 | fermenter load product. | |
62 | fermenter set stage | |
63 | ||
64 | ||
109
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
65 | Product: code, uuid en naam. |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
66 | Stage: Plan Wait Brew Primary Secondary Tertiary Package Carbonation Mature Taste Ready Closed |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
67 | | | | | | | |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
68 | | | | | | +------------- Log/rapport |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
69 | | | | | +------------------------ rapport/etiketten |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
70 | | +-------+---------+--------------------------------- Log/rapport |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
71 | +--------------------------------------------------------- Log/rapport |
0 | 72 | |
174 | 73 | Main table: products. |
74 | In progress: overview. | |
180
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
75 | In Progress: view charts. DONE fermenters, todo brewlogs. |
174 | 76 | In Progress: view logs. |
77 | In Progress: update state. | |
78 | In Progress: Tabbed screens. DONE. | |
79 | Start new: some sort of wizzard like a new recipe. DONE. | |
109
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
80 | Archive: select via name/code/date. |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
81 | Calendar: shows upcoming events. |
174 | 82 | Recipes can be copied to 'recipes' or 'brews', imported from 'recipes'/'products' or created manual. |
180
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
83 | Products recipes Beerxml import. |
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
84 | Recipes Beerxml import. |
106
c64d979613ab
Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents:
104
diff
changeset
|
85 | |
194
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
86 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
87 | ----------------------------------------------------------------------------- |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
88 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
89 | Formaat csv vergisting logs. |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
90 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
91 | Directory: www/logs/fermentation |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
92 | Filenaam: product_code\ product_name.log |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
93 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
94 | 2014-11-15 18:39,BEER,PRIMARY,20.312,19.750,-1.500,20.5,18.6,18.8,35,12345,0,67890,Whatsup,Fermenter |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
95 | | | | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
96 | 0 datetime + | | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
97 | 1 mode --------------+ | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
98 | 2 stage -------------------+ | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
99 | 3 temp air -----------------------+ | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
100 | 4 temp beer -----------------------------+ | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
101 | 5 temp chiller ---------------------------------+ | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
102 | 6 temp room -------------------------------------------+ | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
103 | 7 setpoint low ---------------------------------------------+ | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
104 | 8 setpoint high -------------------------------------------------+ | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
105 | 9 heater power ------------------------------------------------------+ | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
106 | 10 heater usage ----------------------------------------------------------+ | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
107 | 11 cooler power --------------------------------------------------------------+ | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
108 | 12 cooler usage ------------------------------------------------------------------+ | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
109 | 13 event --------------------------------------------------------------------------------+ | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
110 | 14 fermenter uuid --------------------------------------------------------------------------------+ |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
111 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
112 | De oude logs zijn geimporteerd en geconverteerd. Nieuwe worden geschreven |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
113 | door bmsd welke de log gegevens ontvangt via MQTT DLOG berichten. |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
114 | Vanwege de snelheid van verwerken staan de logs niet in de database. |
239 | 115 | Kunnen we de loggegevens versturen in gzip formaat om bandbreedte te sparen? |
194
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
116 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
117 | ----------------------------------------------------------------------------- |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
118 | |
290 | 119 | TODO: |
120 | ||
121 | Export ingredienten naar xml. | |
122 | ||
313
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
123 | Extra: |
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
124 | |
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
125 | Gisten alcohol_tolerance veld toevoegen. |
314
f943efa07d9f
Added yeast duplicate button
Michiel Broek <mbroek@mbse.eu>
parents:
313
diff
changeset
|
126 | Gisten diastaticus bit toevoegen. |
325
9a8c650972ca
Update some documentation. Thermometer gauges animate easing
Michiel Broek <mbroek@mbse.eu>
parents:
314
diff
changeset
|
127 | Waarschuwing voor te zwaar voor de gist. |
9a8c650972ca
Update some documentation. Thermometer gauges animate easing
Michiel Broek <mbroek@mbse.eu>
parents:
314
diff
changeset
|
128 | Waarschuwing voor overschrijden moutstort. |
313
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
129 | Gist typen: kveik en brett? Apart of niet. |
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
130 | |
9f45d09c2071
Added alcohol tolerance field in the yeasts database.
Michiel Broek <mbroek@mbse.eu>
parents:
312
diff
changeset
|
131 |