Hey people,
Today I get my SQL DB up and running. Unfortunately, the data are not displayed correctly in the Sitemap.
This time code and screenshots:
Config file:
> **##### General configurations #####**
> **persistence:default=mysql**
> ######### SQL Persistence Service ############
> **# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)**
> **mysql:url=jdbc:mysql://localhost:3306/openhab**
> **# the database user**
> **mysql:user=Dennis**
> **# the database password**
> **mysql:password=Dennis**
> **# the reconnection counter**
> **mysql:reconnectCnt=1**
> **# the connection timeout (in seconds)**
> **#mysql:waitTimeout=**
Sitemap:
Frame label="Charts"
{
Chart item=FSD_1_Power period=h refresh=10000
Chart item=Wassertemp period=h refresh=10000
Chart item=Lichtwert period=h refresh=10000
}
mysql.persist:
Strategies {
everyDay : "0 0 0 * * ?"
everyHour : "0 0 * * * ?"
everyMinute : "0 * * * * ?"
default = everyChange
}
Items {
//* : strategy = everyChange, restoreOnStartup // Hier werden alle Daten gespeichert und beim neustart in die Variablen geschrieben
FSD_1_Power : strategy = everyMinute
FSD_2_Power : strategy = everyMinute
Lichtwert : strategy = everyChange
Wassertemp : strategy = everyMinute
}
The data are stored in the database. I get in the site map only displays a value and the Y axis is not scaled.
Does anyone know this problem?
Thank-you