Puuhhhh das erschläft mich etwas
Hier was für die die einen digitalen haben:
https://www.instructables.com/id/Read-Your-M…er-ESP8266-WiF/
Puuhhhh das erschläft mich etwas
Hier was für die die einen digitalen haben:
https://www.instructables.com/id/Read-Your-M…er-ESP8266-WiF/
Da bin ich auch schon ne weile feuer und flamme für
Hi,
es geht um folgendes : Stromzähler auslesen und saubere Darstellung in OpenHab+Grafana
Ich habe einen Ferraris Zähler und bin auf der suche nach Möglichkeiten diesen auszulesen. Am besten eine günstige Lösung mit ESP oder dergleichen da mir eine fertige Lösung von HM oder so zu teuer ist für sowas.
Was gibt es ?
Grüzi
Ich hab auch schon nen ganze Zeit vor meinen Stromzähler auszulesen, hat auch ne IR Schnittstelle will dafür aber keinen ganzen rPi dafür "verschwenden".
Mir schwebt da eher was auf ESP8266 Basis vor.
Dann machen wir doch glatt mal nen Thread dafür auf !
EDIT:
bestimmt aber hab mich noch nie mit beschäftigt - gibt sicherlich irgendeine Lösung - gibt ja fertiges von HM oder so aber bastel gerne - wie gesagt hab mich aber noch nicht damit auseinander gestezt
Bin auch noch auf der suche nach einem Stromzähler - Setup hab aber nen Ferraris
Wie meinst du hast nen Raspi am Stromzähler ?!
die austecher hab ich letztes jahr auch gemacht kamen sehr gut an
Ich habs vorbestellt als ich die Liste gesehen habe - dann hab ich mit wehmut die news von der Telekom gesehen ! Egal wir werden dennoch spaß damit haben
denn genug für die Quaratäne ist drin ;D
Übrigens die Abfrage in der Rule ist nicht (true, mysql)sondern (true, jdbc)
Wenn du ein NAS hast installier doch da den EmbyServer und auf deinen Clients das EmbyAddon und et voila das was du willst
Emby muss nicht gekauft werden nach 30 Tagen auch nicht in der TV App. Ich glaube da kommt nur ein Wartebalken.
Der Vorteil mit Emby ist eine Zentrale Datenbank für alle Clients - viel verwaltungsschnickschnack etc...
Ich wollte dir damit nur sagen das wenn du eine DB mit mehr als lass es ~100+ hast für die meisten TVs mit der App einfach Scoll und Anzeigetechnisch ruckler gibt im Menü ! Nicht aber beim Filmschauen perse das wird er ohne Probleme machen können. Teste es einfach.
Kids nen FireTV Stick geben mit Emby und ab 24.3 Disney+ ist auch eine sauber Lösung :))
Ja sorry hab mich wieder verleiten lassen nicht ganz so detailiert darauf einzugehen und zu viel vorauszusetzen - sorry
alles was @Justray2k sagt !
HI,
das geht - aber die Smart TV App bzw dein TV wird je nach größer deiner Datenbank etwas Probleme haben in punkto performance.
So hier sind nun mal die ersten 10 min wenn er startet:
2020-03-09 10:30:23.657 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 230
2020-03-09 10:31:23.661 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 230 to 229
2020-03-09 10:33:23.670 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.675 to 300.678
2020-03-09 10:33:23.670 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 0 to 1997
2020-03-09 10:33:23.671 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 226
2020-03-09 10:33:23.671 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.0 to 8.842
2020-03-09 10:33:23.672 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 0 to 3
2020-03-09 10:33:23.675 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:33:23.676 [vent.ItemStateChangedEvent] - WK_Trockner_OpState changed from 0 to 2
2020-03-09 10:33:23.677 [vent.ItemStateChangedEvent] - trockner_dummy_status changed from OFF to ON
2020-03-09 10:34:23.649 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.678 to 300.709
2020-03-09 10:34:23.649 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1997 to 1958
2020-03-09 10:34:23.649 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 226 to 225
2020-03-09 10:34:23.650 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 8.842 to 8.687
2020-03-09 10:34:23.650 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 3 to 32
2020-03-09 10:34:23.651 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:35:23.672 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.709 to 300.744
2020-03-09 10:35:23.672 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1958 to 490
2020-03-09 10:35:23.672 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 225 to 226
2020-03-09 10:35:23.672 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:35:23.673 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 8.687 to 2.168
2020-03-09 10:35:23.674 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 32 to 35
2020-03-09 10:36:23.670 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.744 to 300.784
2020-03-09 10:36:23.671 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 490 to 2611
2020-03-09 10:36:23.671 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 226 to 224
2020-03-09 10:36:23.671 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 2.168 to 11.645
2020-03-09 10:36:23.675 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 35 to 39
2020-03-09 10:36:23.676 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:37:23.665 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.784 to 300.83
2020-03-09 10:37:23.665 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 2611 to 2632
2020-03-09 10:37:23.665 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 11.645 to 11.739
2020-03-09 10:37:23.666 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:37:23.666 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 39 to 46
2020-03-09 10:38:23.681 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.83 to 300.876
2020-03-09 10:38:23.682 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 2632 to 2634
2020-03-09 10:38:23.682 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 224 to 225
2020-03-09 10:38:23.682 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 11.739 to 11.705
2020-03-09 10:38:23.683 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:39:23.708 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.876 to 300.923
2020-03-09 10:39:23.710 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 2634 to 2608
2020-03-09 10:39:23.710 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 11.705 to 11.611
2020-03-09 10:39:23.710 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:40:23.692 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.923 to 300.969
2020-03-09 10:40:23.692 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 2608 to 2629
2020-03-09 10:40:23.693 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:40:23.693 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 11.611 to 11.705
2020-03-09 10:41:23.676 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 300.969 to 301.015
2020-03-09 10:41:23.676 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 2629 to 1966
2020-03-09 10:41:23.676 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 225 to 226
2020-03-09 10:41:23.677 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 11.705 to 8.687
2020-03-09 10:41:23.677 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:42:23.685 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 301.015 to 301.054
2020-03-09 10:42:23.686 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1966 to 2628
2020-03-09 10:42:23.686 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 226 to 225
2020-03-09 10:42:23.686 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 8.687 to 11.679
2020-03-09 10:42:23.687 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 10:42:23.688 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 46 to 40
Alles anzeigen
und hier die letzten 10min - hab dann direkt ausgeschalten wo er REAL fertig war (also kein nachdrehen)
2020-03-09 11:19:40.939 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 11:20:40.898 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.385 to 302.4
2020-03-09 11:20:40.899 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1939 to 865
2020-03-09 11:20:40.899 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 225 to 227
2020-03-09 11:20:40.899 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 8.603 to 3.81
2020-03-09 11:20:40.900 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 34 to 15
2020-03-09 11:20:40.900 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 11:21:40.975 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.4 to 302.431
2020-03-09 11:21:40.975 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 865 to 1928
2020-03-09 11:21:40.975 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 227 to 225
2020-03-09 11:21:40.976 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 3.81 to 8.57
2020-03-09 11:21:40.976 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 15 to 31
2020-03-09 11:21:40.977 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 11:22:40.927 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.431 to 302.458
2020-03-09 11:22:40.928 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1928 to 862
2020-03-09 11:22:40.931 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 225 to 227
2020-03-09 11:22:40.932 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 8.57 to 3.797
2020-03-09 11:22:40.933 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 31 to 27
2020-03-09 11:22:40.933 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command ON
2020-03-09 11:27:06.340 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.458 to 302.567
2020-03-09 11:27:06.340 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 862 to 144
2020-03-09 11:27:06.342 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 227 to 228
2020-03-09 11:27:06.368 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 3.797 to 0.631
2020-03-09 11:27:06.368 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 27 to 3
2020-03-09 11:27:36.397 [vent.ItemStateChangedEvent] - WK_Trockner_OpState changed from 2 to 3
2020-03-09 11:27:37.285 [ome.event.ItemCommandEvent] - Item 'trockner_dummy_status' received command OFF
2020-03-09 11:27:37.287 [vent.ItemStateChangedEvent] - trockner_dummy_status changed from ON to OFF
2020-03-09 11:28:06.307 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.567 to 302.57
2020-03-09 11:28:06.307 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 144 to 141
2020-03-09 11:28:06.308 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-09 11:28:06.309 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.631 to 0.618
2020-03-09 11:28:06.309 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 3 to 2
2020-03-09 11:29:06.316 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.57 to 302.572
2020-03-09 11:29:06.316 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 228
2020-03-09 11:29:06.316 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.618 to 0.623
2020-03-09 11:29:06.317 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 2 to 3
2020-03-09 11:30:06.380 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.572 to 302.575
2020-03-09 11:30:06.381 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-09 11:30:06.381 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.623 to 0.619
2020-03-09 11:30:06.382 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 3 to 2
2020-03-09 11:31:06.314 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.575 to 302.578
2020-03-09 11:31:06.315 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 141 to 142
2020-03-09 11:31:06.315 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 228
2020-03-09 11:31:06.316 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.619 to 0.622
2020-03-09 11:31:06.316 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 2 to 3
2020-03-09 11:35:42.768 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 302.578 to 302.587
2020-03-09 11:35:42.768 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 142 to 0
2020-03-09 11:35:42.768 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-09 11:35:42.769 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.622 to 0.0
2020-03-09 11:35:42.770 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 3 to 0
2020-03-09 11:35:42.770 [vent.ItemStateChangedEvent] - WK_Trockner_OpState changed from 3 to 0
2020-03-09 11:36:42.761 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 0 to 1
2020-03-09 11:36:42.762 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.0 to 0.066
2020-03-09 11:37:42.755 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 1 to 0
2020-03-09 11:37:42.756 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.066 to 0.0
Alles anzeigen
Hier noch ein Log wenn er nachdreht:
from 304.941 to 304.943
2020-03-11 14:13:44.235 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 166 to 144
2020-03-11 14:13:44.236 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.732 to 0.641
2020-03-11 14:14:44.228 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.943 to 304.946
2020-03-11 14:14:44.228 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 144 to 166
2020-03-11 14:14:44.228 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 227 to 228
2020-03-11 14:14:44.229 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.641 to 0.728
2020-03-11 14:15:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.946 to 304.947
2020-03-11 14:15:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 166 to 3
2020-03-11 14:15:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.728 to 0.049
2020-03-11 14:15:44.264 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 3 to 1
2020-03-11 14:16:44.275 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.947 to 304.948
2020-03-11 14:16:44.276 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.049 to 0.055
2020-03-11 14:17:44.244 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.055 to 0.051
2020-03-11 14:18:44.231 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.948 to 304.949
2020-03-11 14:18:44.232 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.051 to 0.058
2020-03-11 14:19:44.250 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.058 to 0.064
2020-03-11 14:20:44.246 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.949 to 304.95
2020-03-11 14:20:44.246 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.064 to 0.053
2020-03-11 14:21:44.273 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.053 to 0.055
2020-03-11 14:22:44.239 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.95 to 304.951
2020-03-11 14:22:44.240 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.055 to 0.083
2020-03-11 14:23:44.274 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-11 14:23:44.275 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.083 to 0.059
2020-03-11 14:24:44.256 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.951 to 304.952
2020-03-11 14:24:44.257 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 228
2020-03-11 14:24:44.257 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.059 to 0.054
2020-03-11 14:25:44.282 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 3 to 4
2020-03-11 14:25:44.282 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-11 14:25:44.282 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.054 to 0.068
2020-03-11 14:26:44.262 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.952 to 304.953
2020-03-11 14:26:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 4 to 168
2020-03-11 14:26:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 228
2020-03-11 14:26:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.068 to 0.737
2020-03-11 14:26:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 1 to 0
2020-03-11 14:27:44.272 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 168 to 3
2020-03-11 14:27:44.272 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.737 to 0.061
2020-03-11 14:28:44.282 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.953 to 304.954
2020-03-11 14:28:44.283 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 3 to 5
2020-03-11 14:28:44.283 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 228 to 229
2020-03-11 14:28:44.283 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.061 to 0.07
2020-03-11 14:28:44.283 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 0 to 1
2020-03-11 14:29:44.247 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 5 to 163
2020-03-11 14:29:44.248 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.07 to 0.715
2020-03-11 14:29:44.248 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 1 to 0
2020-03-11 14:30:44.251 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 163 to 3
2020-03-11 14:30:44.252 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.715 to 0.059
2020-03-11 14:31:44.265 [vent.ItemStateChangedEvent] - WK_Trockner_EnergyCount changed from 304.954 to 304.955
2020-03-11 14:31:44.266 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 3 to 4
2020-03-11 14:31:44.266 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 0 to 1
2020-03-11 14:32:44.262 [vent.ItemStateChangedEvent] - WK_Trockner_Power changed from 4 to 167
2020-03-11 14:32:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Voltage changed from 229 to 228
2020-03-11 14:32:44.263 [vent.ItemStateChangedEvent] - WK_Trockner_Current changed from 0.059 to 0.732
2020-03-11 14:32:44.264 [vent.ItemStateChangedEvent] - WK_Trockner_PowerAverage changed from 1 to 0
Alles anzeigen
geht mit CFW - und der CFW status ist recht aktuell in Punkto FW
EDIT ! Endlich ! Es tut was es soll !!! Vielen dank für die Unterstützung Jungs !
ALso hab die DB nochmal gedroppt und dann mit dem Zeichencode angelegt aus deinem Link.
Ging leider nicht:
2020-03-04 21:06:32.470 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: Column length too big for column 'value' (max = 21844); use BLOB or TEXT instead Query: CREATE TABLE IF NOT EXISTS item0001 (time TIMESTAMP(3) NOT NULL, value VARCHAR(65500), PRIMARY KEY(time)) Parameters: []
http://wiki.r1soft.com/display/kb3/Co…+(max+%3D+21845)
Habs nun mit latin1_german1_ci angelegt - mit dem Zeichencode aus deinem Link ging es leider nicht.
Nun scheint er alles sauber angelegt zu haben. Kann leider erst wieder morgen testen.
Hier das ganze [definition='1','0']log[/definition]:
er meldet nen sql Fehler das ist wohl das Problem:
==> /logs/openhab.[definition='1','0']log[/definition] <==
2020-03-03 18:41:34.881 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: Error preparing query: Table 'openhab.item0002' doesn't exist Query: INSERT INTO item0002 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [alexa, alexa]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:457) ~[commons-dbutils-1.6.jar:1.6]
at org.knowm.yank.Yank.execute(Yank.java:194) [yank-3.2.0.jar:?]
at org.knowm.yank.Yank.execute(Yank.java:177) [yank-3.2.0.jar:?]
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doStoreItemValue(JdbcBaseDAO.java:337) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcMapper.storeItemValue(JdbcMapper.java:145) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.store(JdbcPersistenceService.java:137) [bundleFile:?]
at org.openhab.core.persistence.internal.PersistenceServiceDelegate.store(PersistenceServiceDelegate.java:59) [bundleFile:?]
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.handleStateEvent(PersistenceManagerImpl.java:137) [bundleFile:?]
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.stateChanged(PersistenceManagerImpl.java:437) [bundleFile:?]
at org.eclipse.smarthome.core.items.GenericItem$1.run(GenericItem.java:261) [bundleFile:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
==> /logs/events.[definition='1','0']log[/definition] <==
2020-03-03 18:41:34.879 [vent.ItemStateChangedEvent] - Echo_Kitchen_LastVoiceCommand changed from sind noch fenster offen to alexa
==> /logs/openhab.[definition='1','0']log[/definition] <==
2020-03-03 18:41:37.164 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: Error preparing query: Table 'openhab.item0002' doesn't exist Query: INSERT INTO item0002 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [sind noch fenster offen, sind noch fenster offen]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491) ~[commons-dbutils-1.6.jar:1.6]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:457) ~[commons-dbutils-1.6.jar:1.6]
at org.knowm.yank.Yank.execute(Yank.java:194) [yank-3.2.0.jar:?]
at org.knowm.yank.Yank.execute(Yank.java:177) [yank-3.2.0.jar:?]
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doStoreItemValue(JdbcBaseDAO.java:337) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcMapper.storeItemValue(JdbcMapper.java:145) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.store(JdbcPersistenceService.java:137) [bundleFile:?]
at org.openhab.core.persistence.internal.PersistenceServiceDelegate.store(PersistenceServiceDelegate.java:59) [bundleFile:?]
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.handleStateEvent(PersistenceManagerImpl.java:137) [bundleFile:?]
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.stateChanged(PersistenceManagerImpl.java:437) [bundleFile:?]
at org.eclipse.smarthome.core.items.GenericItem$1.run(GenericItem.java:261) [bundleFile:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
2020-03-03 18:41:37.164 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: Error preparing query: Table 'openhab.item0001' doesn't exist Query: SELECT time, value FROM item0001 ORDER BY time DESC LIMIT 0,1 Parameters: []
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[?:?]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351) ~[?:?]
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289) ~[?:?]
at org.knowm.yank.Yank.queryObjectArrays(Yank.java:578) ~[?:?]
at org.knowm.yank.Yank.queryObjectArrays(Yank.java:560) ~[?:?]
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doGetHistItemFilterQuery(JdbcBaseDAO.java:344) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcMapper.getHistItemFilterQuery(JdbcMapper.java:158) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.query(JdbcPersistenceService.java:205) ~[?:?]
at org.openhab.core.persistence.internal.QueryablePersistenceServiceDelegate.query(QueryablePersistenceServiceDelegate.java:52) ~[?:?]
at org.eclipse.smarthome.model.persistence.extensions.PersistenceExtensions.lastUpdate(PersistenceExtensions.java:558) ~[?:?]
at org.eclipse.smarthome.model.persistence.extensions.PersistenceExtensions.lastUpdate(PersistenceExtensions.java:538) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeOperation(XbaseInterpreter.java:1175) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeOperation(XbaseInterpreter.java:1150) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._invokeFeature(XbaseInterpreter.java:1136) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeFeature(XbaseInterpreter.java:1081) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.invokeFeature(ScriptInterpreter.java:151) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:991) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:954) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:235) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:458) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:239) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.evaluate(XbaseInterpreter.java:201) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.ClosureInvocationHandler.doInvoke(ClosureInvocationHandler.java:46) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.AbstractClosureInvocationHandler.invoke(AbstractClosureInvocationHandler.java:29) ~[?:?]
at com.sun.proxy.$Proxy204.apply(Unknown Source) ~[?:?]
at org.eclipse.xtext.xbase.lib.internal.KeyComparator.compare(KeyComparator.java:41) ~[?:?]
at java.util.TimSort.countRunAndMakeAscending(TimSort.java:355) ~[?:1.8.0_232]
at java.util.TimSort.sort(TimSort.java:220) ~[?:1.8.0_232]
at java.util.Arrays.sort(Arrays.java:1512) ~[?:1.8.0_232]
at java.util.ArrayList.sort(ArrayList.java:1462) ~[?:1.8.0_232]
at java.util.Collections.sort(Collections.java:177) ~[?:1.8.0_232]
at org.eclipse.xtext.xbase.lib.ListExtensions.sortInplaceBy(ListExtensions.java:82) ~[?:?]
at org.eclipse.xtext.xbase.lib.IterableExtensions.sortBy(IterableExtensions.java:792) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeOperation(XbaseInterpreter.java:1175) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeOperation(XbaseInterpreter.java:1150) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._invokeFeature(XbaseInterpreter.java:1136) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeFeature(XbaseInterpreter.java:1081) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.invokeFeature(ScriptInterpreter.java:151) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:861) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:231) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.evaluateArgumentExpressions(XbaseInterpreter.java:1205) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._invokeFeature(XbaseInterpreter.java:1135) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.invokeFeature(XbaseInterpreter.java:1081) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.invokeFeature(ScriptInterpreter.java:151) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:861) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:231) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:916) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:275) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter._doEvaluate(XbaseInterpreter.java:458) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.doEvaluate(XbaseInterpreter.java:239) ~[?:?]
at org.eclipse.smarthome.model.script.interpreter.ScriptInterpreter.doEvaluate(ScriptInterpreter.java:226) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.internalEvaluate(XbaseInterpreter.java:215) ~[?:?]
at org.eclipse.xtext.xbase.interpreter.impl.XbaseInterpreter.evaluate(XbaseInterpreter.java:201) ~[?:?]
at org.eclipse.smarthome.model.script.runtime.internal.engine.ScriptImpl.execute(ScriptImpl.java:81) ~[?:?]
at org.eclipse.smarthome.model.rule.runtime.internal.engine.RuleEngineImpl.lambda$2(RuleEngineImpl.java:313) ~[?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_232]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_232]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_232]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
2020-03-03 18:41:37.186 [ERROR] [ntime.internal.engine.RuleEngineImpl] - Rule 'Alexa - Fenster offen': null
==> /logs/events.[definition='1','0']log[/definition] <==
2020-03-03 18:41:37.160 [vent.ItemStateChangedEvent] - Echo_Kitchen_LastVoiceCommand changed from alexa to sind noch fenster offen
Alles anzeigen