Hello, I have followed various other posts about this, but I haven’t made any headway:
I ran Openhab 3 on a Pi 3 for several years with persistence using a remote MySQL database which worked perfectly.
Last week the old Pi died, so I built a new machine with a new Pi and an nvme drive. As the new machine has a signifcant amount of storage, I decided to install Influxdb and Grafana using the openhabian conifg installer.
I have restored a backup of my old OH3 configuration to the new machine, and have deleted the .persist file from the old textual config, relying instead on the configuration through the openhab UI.
I have verified Influxdb is running and can log in using the same credentials as set in the Openhab persistence configuration, which reports “connected to http://localhost:8086 version v1.11.8”
When I query the databases using SHOW DATABASES, I see
name: databases name ---- openhabian openhab
When I “SHOW MEASUREMENTS” I get a full list of all the Openhab items, but there is no data being stored and I don’t know where to go next!
For reference, I have tried several solutions, and at least one of them has worked, but alas I do not know which one and at the moment don’t have time to experiment.
Firstly I went into the main UI, and edited the settings/addons/influxdb persistence/configure_persistence_policies, removing the wildcard and manually specifying all my groups. I also added an “every minute” policy.
I also renamed my old mysql.persist file to influxdb.persist and added it back to the persistance folder.
On restarting Openhab, things seemed to start working so I returned to the Main UI Add On config and reset the “Persist all items” switch to on.
This has worked and now all item states are being persisted on change and every minute.
I hope this helps someone who has the same or a similar issue.
Edit:
After manually creating a persist file it now works.
I added a “FroniusNumericals*” strategy where the * addresses members of a group if I understand the documentation correctly.
Setting up the persistence through the UI doesn’t seem to work.
I’ve achieved what I wanted anyways.
I’m having issues with the persistence setup.
I’ve added some numerical items to a group “FroniusNumericals” but pointing to this group from the UI (“Edit influxdb persistence configuration”) stops my Influx persistence completely. It works if I pick one or several items manually or picking the * wildcard.
If it was possible to setup persistence by using groups that would make it a lot easier.
Am I the only one having this issue?
The trace logging doesn’t give me any feedback at all when trying to persist a group.
Thanks!
openHAB 4.3.1 on Raspberry 4, 4Gb
InfluxDB shell version: v1.11.8
