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/
Beiträge von xSaSx
-
-
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:
Code
Alles anzeigen2020-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
und hier die letzten 10min - hab dann direkt ausgeschalten wo er REAL fertig war (also kein nachdrehen)Code
Alles anzeigen2020-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.0Hier noch ein Log wenn er nachdreht:
Code
Alles anzeigenfrom 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 -
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:
Code2020-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:
Code
Alles anzeigen==> /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
