[SOLVED] No measurements in Influx DB on 2.4 Stable OH2

Add-ons Persistence Services
1

Hi Guys

Installed as per the instructions like i have in the past

Influx Persistance installed, with this file:


Strategies {
    everyHour   : "0 0 * * * ?"
    everyDay    : "0 0 0 * * ?"

    default = everyChange
}

Items {
// persist all members of gInfluxDB Group on: everyChange, everyHour, everyDay
    Thermo1_Room1         : strategy = everyHour, everyDay
    Thermo2_Room2         : strategy = everyHour, everyDay
}

influx.cfg file as below:


# The database URL, e.g. http://127.0.0.1:8086 or https://127.0.0.1:8084 .
# Defaults to: http://127.0.0.1:8086
url=http://127.0.0.1:8086

# The name of the database user, e.g. openhab.
# Defaults to: openhab
user=admin

# The password of the database user.
password=password13

# The name of the database, e.g. openhab.
# Defaults to: openhab
db=ihp_db
retentionPolicy=autogen

I can login to Influx and see the db

Connected to http://localhost:8086 version 1.7.8
InfluxDB shell version: 1.7.8
> settings
Setting           Value
--------          --------
Host              localhost:8086
Username          admin
Database
RetentionPolicy
Pretty            false
Format            column
Write Consistency all
Chunked           true
Chunk Size        0

ANy thought as to why no measurements? ive restarted OH2 and removed the everyHour that Vincent’s mentioned in the past.

Cheers

2

Where is the everyChange parameter?

3

Shouldnt need it? I dont want every single change, just the value per hour

4

You wrote:

// persist all members of gInfluxDB Group on: everyChange, everyHour, everyDay
5

Thats commented out…

6

Yes, it’s a comment :wink:

7

Also, you mention:

What does your influxdb.persist look like now?
What does the log say when you start OH about the connection to influx?
Try adding everyChange, and change the value of one one the items, what does the log say?

8

Same as the post above…

Nothing shows in the log when I restart influx

Will do!

9

Nothing shows in the syslog when making a manual change

Persist file as below:


Strategies {
    everyHour   : "0 0 * * * ?"
    everyDay    : "0 0 0 * * ?"

    default = everyChange
}

Items {
// persist all members of gInfluxDB Group on: everyChange, everyHour, everyDay
    Thermo1_Room1         : strategy = everyChange, everyHour, everyDay
    Thermo2_Room2         : strategy = everyChange, everyHour, everyDay
}
10

No error means that the values should be persisted… Hmmm…

11

Did you restart OH after modifying the persist file?

12

Yes sir, certainly did.

if i look into influx, theres no measurements, so I doubt persistance is working. I also reinstalled the persistance binding for influx

13

If i enable


 log:set DEBUG org.openhab.persistence.influxdb

I dont get squat!

14

Silly question but did you install the service?

15

The persistance service ? yes


2019-09-05 16:52:28.994 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model 'influxdb.persist'
2019-09-05 16:52:30.024 [INFO ] [el.core.internal.ModelRepositoryImpl] - Refreshing model 'influxdb.persist'
16 

openhab> feature:info openhab-persistence-influxdb
Feature openhab-persistence-influxdb 1.13.0
Description:
  InfluxDB (v 1.0) Persistence
Feature has no configuration
Feature configuration files:
  ${openhab.conf}/services/influxdb.cfg
Feature depends on:
  openhab-runtime-base 0.0.0
  openhab-runtime-compat1x 0.0.0
Feature contains followed bundles:
  mvn:org.openhab.persistence/org.openhab.persistence.influxdb/1.13.0 start-level=80
Feature has no conditionals.
17

So it should be working
Have you chaecked the database content?

18

It is now after a reinstall, go figure :smiley:

purged/removed influx and started again. All good now!

1 Like
19

Really? You did not install Influx Persistance, but influxdb persistence

Further, it’s not influx.cfg but influxdb.cfg
and for sure it’s influxdb.persist for configuring the persistence.

Please always use the correct terms, as openHAB won’t forgive any misspelling.

1 Like
20

Sure. I had all the correct filenames…