I have a Homematic temperature sensor and use HABPanel to show the temperature in my living room.
Now I want to use persistence (mysql) to get a history.
I created y mysql.persist file:
// persistence strategies have a name and a definition and are referred to in the "Items" section
Strategies {
everyMinute : "0 * * * * ?"
every5Minutes : "0 */5 * * * ?"
every15Minutes : "0 */15 * * * ?"
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
default = everyChange
}
Items {
CCU2_Livingroom_Temperature : strategy = every15Minutes, restoreOnStartup
}
CCU2_Livingroom_Temperature is the name I used in PaperUI to create this item.
Unfortunately neither the ‘items’ table nor the ‘itemx’ tables are created in the mysql databse
If I use an *.items file and configure the sensor inside this file then it works. This means databse is working correctly.
Does that mean I can use persistence only if I use *.items files instead of configuring items using Paper UI?
I want to use PaperUI to comfortably create/edit things/items and the persistence file (mysql.persist) to get my history working.
Did you install the JDBC Persistence MySQL persistence service in paperUI?
Did you configure the mysql.cfg properly?
Do you have a running mysql server?
The easiest way I can think of to configure persistence via Paper UI is to use the Group based persistence design pattern. Idea is to use a group in your persistence strategy. Adding or removing items to/from a group is possible in Paper UI while editing the item.
Please note that we currently seem to have a little problem with JDBC persistence.
