Stromwaechter - Integration into OpenHAB

current and voltage monitor and power distribution

Introduction

Thsi document describes how to integrate the Stromwaechter pcb into OpenHab to get a screen as shown above. Therefore the following files have to be modified as described.

/etc/openhab2/things/mqtt.things

Bridge mqtt:broker:WorkBroker "Work Broker" [ host="localhost", port="1883", secure=false, username="openhabian", password="ohmqtt", clientID="WORKOPENHAB24" ] {
	Thing topic sensoren {
	Channels:
		Type number : mqtt_stromwaechter_vbus "VBUS [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/vbus" ]
		Type number : mqtt_stromwaechter_temperature "Temperature [%f] C" [ stateTopic="b4-e6-2d-3f-62-05/temperature" ]
		Type number : mqtt_stromwaechter_1_voltage "Voltage 1 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/1/voltage" ]
		Type number : mqtt_stromwaechter_1_current "Current 1 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/1/current" ]
		Type switch : mqtt_stromwaechter_1_state "State 1" [ stateTopic="b4-e6-2d-3f-62-05/1/state" ]
		Type number : mqtt_stromwaechter_2_voltage "Voltage 2 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/2/voltage" ]
		Type number : mqtt_stromwaechter_2_current "Current 2 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/2/current" ]
		Type switch : mqtt_stromwaechter_2_state "State 2" [ stateTopic="b4-e6-2d-3f-62-05/2/state" ]
		Type number : mqtt_stromwaechter_3_voltage "Voltage 3 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/3/voltage" ]
		Type number : mqtt_stromwaechter_3_current "Current 3 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/3/current" ]
		Type switch : mqtt_stromwaechter_3_state "State 3" [ stateTopic="b4-e6-2d-3f-62-05/3/state" ]
		Type number : mqtt_stromwaechter_4_voltage "Voltage 4 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/4/voltage" ]
		Type number : mqtt_stromwaechter_4_current "Current 4 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/4/current" ]
		Type switch : mqtt_stromwaechter_4_state "State 4" [ stateTopic="b4-e6-2d-3f-62-05/4/state" ]
		Type number : mqtt_stromwaechter_5_voltage "Voltage 5 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/5/voltage" ]
		Type number : mqtt_stromwaechter_5_current "Current 5 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/5/current" ]
		Type switch : mqtt_stromwaechter_5_state "State 5" [ stateTopic="b4-e6-2d-3f-62-05/5/state" ]
		Type number : mqtt_stromwaechter_6_voltage "Voltage 6 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/6/voltage" ]
		Type number : mqtt_stromwaechter_6_current "Current 6 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/6/current" ]
		Type switch : mqtt_stromwaechter_6_state "State 6" [ stateTopic="b4-e6-2d-3f-62-05/6/state" ]
		Type number : mqtt_stromwaechter_7_voltage "Voltage 7 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/7/voltage" ]
		Type number : mqtt_stromwaechter_7_current "Current 7 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/7/current" ]
		Type switch : mqtt_stromwaechter_7_state "State 7" [ stateTopic="b4-e6-2d-3f-62-05/7/state" ]
		Type number : mqtt_stromwaechter_8_voltage "Voltage 8 [%f] V" [ stateTopic="b4-e6-2d-3f-62-05/8/voltage" ]
		Type number : mqtt_stromwaechter_8_current "Current 8 [%f] A" [ stateTopic="b4-e6-2d-3f-62-05/8/current" ]
		Type switch : mqtt_stromwaechter_8_state "State 8" [ stateTopic="b4-e6-2d-3f-62-05/8/state" ]
		Type string : mqtt_stromwaechter_version [ stateTopic="b4-e6-2d-3f-62-05/version" ]
		Type string : mqtt_stromwaechter_mac [ stateTopic="b4-e6-2d-3f-62-05/mac" ]
		Type string : mqtt_stromwaechter_ip [ stateTopic="b4-e6-2d-3f-62-05/ip" ]
		Type string : mqtt_stromwaechter_wlan [ stateTopic="b4-e6-2d-3f-62-05/wlan" ]
	}
}

/etc/openhab2/items/default.items

Number mqtt_stromwaechter_vbus "VBUS [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_vbus"}
Number mqtt_stromwaechter_temperature "Temperature [%f] C" <temperature> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_temperature"}
Number mqtt_stromwaechter_1_voltage "Voltage 1 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_1_voltage"}
Number mqtt_stromwaechter_1_current "Current 1 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_1_current"}
Switch mqtt_stromwaechter_1_state "State 1" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_1_state"}
Number mqtt_stromwaechter_2_voltage "Voltage 2 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_2_voltage"}
Number mqtt_stromwaechter_2_current "Current 2 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_2_current"}
Switch mqtt_stromwaechter_2_state "State 2" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_2_state"}
Number mqtt_stromwaechter_3_voltage "Voltage 3 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_3_voltage"}
Number mqtt_stromwaechter_3_current "Current 3 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_3_current"}
Switch mqtt_stromwaechter_3_state "State 3" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_3_state"}
Number mqtt_stromwaechter_4_voltage "Voltage 4 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_4_voltage"}
Number mqtt_stromwaechter_4_current "Current 4 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_4_current"}
Switch mqtt_stromwaechter_4_state "State 4" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_4_state"}
Number mqtt_stromwaechter_5_voltage "Voltage 5 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_5_voltage"}
Number mqtt_stromwaechter_5_current "Current 5 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_5_current"}
Switch mqtt_stromwaechter_5_state "State 5" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_5_state"}
Number mqtt_stromwaechter_6_voltage "Voltage 6 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_6_voltage"}
Number mqtt_stromwaechter_6_current "Current 6 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_6_current"}
Switch mqtt_stromwaechter_6_state "State 6" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_6_state"}
Number mqtt_stromwaechter_7_voltage "Voltage 7 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_7_voltage"}
Number mqtt_stromwaechter_7_current "Current 7 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_7_current"}
Switch mqtt_stromwaechter_7_state "State 7" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_7_state"}
Number mqtt_stromwaechter_8_voltage "Voltage 8 [%f] V" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_8_voltage"}
Number mqtt_stromwaechter_8_current "Current 8 [%f] A" <batterylevel> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_8_current"}
Switch mqtt_stromwaechter_8_state "State 8" <switch> {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_8_state"}
String mqtt_stromwaechter_version "Version" {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_version"}
String mqtt_stromwaechter_mac "MAC" {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_mac"}
String mqtt_stromwaechter_ip "IP" {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_ip"}
String mqtt_stromwaechter_wlan "WLAN" {channel="mqtt:topic:WorkBroker:sensoren:mqtt_stromwaechter_wlan"}
Number	Chart_Intervall				"Chart Intervall"

/etc/openhab2/sitemaps/default.sitemap

sitemap default label="Test-Relais DB0XXX"
{
    Text item=mqtt_stromwaechter_vbus {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_vbus service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_vbus service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_vbus service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_vbus service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_vbus service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_temperature {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_temperature service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_temperature service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_temperature service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_temperature service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_temperature service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_1_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_1_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_1_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_1_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_1_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_1_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_1_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_1_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_1_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_1_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_1_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_1_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_2_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_2_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_2_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_2_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_2_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_2_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_2_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_2_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_2_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_2_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_2_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_2_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_3_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_3_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_3_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_3_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_3_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_3_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_3_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_3_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_3_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_3_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_3_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_3_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_4_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_4_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_4_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_4_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_4_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_4_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_4_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_4_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_4_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_4_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_4_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_4_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_5_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_5_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_5_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_5_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_5_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_5_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_5_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_5_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_5_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_5_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_5_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_5_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_6_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_6_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_6_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_6_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_6_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_6_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_6_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_6_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_6_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_6_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_6_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_6_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_7_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_7_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_7_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_7_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_7_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_7_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_7_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_7_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_7_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_7_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_7_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_7_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_8_voltage {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_8_voltage service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_8_voltage service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_8_voltage service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_8_voltage service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_8_voltage service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_8_current {
	Switch item=Chart_Intervall label="Zeitraum" icon="clock" mappings=[0="Stunde", 1="Tag", 2="Woche", 3="Monat", 4="Jahr"]
    	Chart item=mqtt_stromwaechter_8_current service="mysql" period=h refresh=30000 visibility=[Chart_Intervall==0, Chart_Intervall=="Uninitialized"]
    	Chart item=mqtt_stromwaechter_8_current service="mysql" period=D refresh=30000 visibility=[Chart_Intervall==1]
    	Chart item=mqtt_stromwaechter_8_current service="mysql" period=W refresh=30000 visibility=[Chart_Intervall==2]
    	Chart item=mqtt_stromwaechter_8_current service="mysql" period=M refresh=30000 visibility=[Chart_Intervall==3]
    	Chart item=mqtt_stromwaechter_8_current service="mysql" period=Y refresh=30000 visibility=[Chart_Intervall==4]
    }
    Text item=mqtt_stromwaechter_1_state
    Text item=mqtt_stromwaechter_2_state
    Text item=mqtt_stromwaechter_3_state
    Text item=mqtt_stromwaechter_4_state
    Text item=mqtt_stromwaechter_5_state
    Text item=mqtt_stromwaechter_6_state
    Text item=mqtt_stromwaechter_7_state
    Text item=mqtt_stromwaechter_8_state
    Text item=mqtt_stromwaechter_version
    Text item=mqtt_stromwaechter_mac
    Text item=mqtt_stromwaechter_ip
    Text item=mqtt_stromwaechter_wlan

}

/etc/openhab2/persistence/mysql.persist

// persistence strategies have a name and a definition and are referred to in the "Items" section
Strategies {
	// if no strategy is specified for an item entry below, the default list will be used
	everyMinute	: "0 * * * * ?"
	every5Minutes : "0 */5 * * * ?"
   	everyHour   : "0 0 * * * ?"
   	everyDay    : "0 0 0 * * ?"
   	default = everyChange
}

/* 
 * Each line in this section defines for which item(s) which strategy(ies) should be applied.
 * You can list single items, use "*" for all items or "groupitem*" for all members of a group
 * item (excl. the group item itself).
 */

Items {
    // persist all items once a day and on every change and restore them from the db at startup
 //   * : strategy = everyChange, everyMinute, restoreOnStartup
    * : strategy = every5Minutes, restoreOnStartup
}

/etc/openhab2/services/mysql.cfg

# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)
url=jdbc:mysql://127.0.0.1:3306/OpenHAB?serverTimezone=Europe/Berlin

# the database user
user=openhab

# the database password
password=openhab

# the reconnection counter
#reconnectCnt=

# the connection timeout (in seconds)
#waitTimeout=

# Use MySQL Server time to store item values (=false) or use openHAB Server time (=true).
# For new installations, its recommend to set "localtime=true".
# (optional, defaults to false)
#localtime=true

If you have any questions contact me via email at bernhard@generationmake.de, make an issue at github or send me a message at twitter (https://twitter.com/generation_make).

Last update: 3. june 2019