Home Assistant Community Add-on: InfluxDB

steadi · February 5, 2020, 6:52am

Trying to set up a file size sensor to my InfluxDB database, but having trouble finding the file location + I’d like to occasionally download my database, so the RPI doesn’t fill up.

What’s the file path for the influxdb database?

(Running Hassio on an rpi 3+).

povlhp · February 14, 2020, 7:03am

The arm64 / aarch64 target fails on modern hardware with no ARM32 emulation. Got influxdata to accept my pull request chronograph yesterday, now waiting for them to commit my change to kapacitor. There is a backlog there though.

Now, how do I add my own binaries to the container ?
I tried to clone https://github.com/hassio-addons/addon-influxdb and put in my /usr/share/hassio/addons/local - but it fails to install. Why ? What am I missing ?
I can not find anything in logs.

If I can get the local addon to install, then I can easily drop the 4 modded binaries into the rootfs folder for the time being.

dakkerd · February 22, 2020, 12:29pm

Hi there,

Running Home Assistant 0.105.5.

Tried to pull in data from entity of Shelly H&T.

Created db
created user, with permissions all
added following config in of the webui
3.1 adding the following

auth: false
reporting: true
ssl: false
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_HTTP_LOG_ENABLED
    value: 'true'
database: homeassistant_influx
username: homeassistant_influx
password: pass
log_level: debug

3.2. I also tried

auth: false
reporting: true
ssl: false
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_HTTP_LOG_ENABLED
    value: 'true'
log_level: debug

3.3 also tried

auth: true
reporting: true
ssl: false
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_HTTP_LOG_ENABLED
    value: 'true'
database: homeassistant_influx
username: homeassistant_influx
password: 123456
log_level: debug

added the config to the configuration.yalm

influxdb:
  host: my.ip
  port: 8086
  database: homeassistant_influx
  username: homeassistant_influx
  password: password
  ssl: false
  verify_ssl: false
  max_retries: 3
  default_measurement: state
  include:
      entities:
       - sensor.shelly_h_t_e00a33_humidity
       - sensor.shelly_h_t_e0113f_humidity

no error in de log on hassio nor on influxdb

I created DB as seen here above. Yet, when going to explore it says “no database is selected”. I’m getting desperate on what to do.

Is there a step that I’m missing?

frenck · February 23, 2020, 3:41pm

Release v3.6.0

Full Changelog

This is a general maintenance release.

Changes

Fix Patreon link
Update add-on documentation to use new YAML configuration format
Update add-on config with new password & list features
Re-branding
Updates for upstream Supervisor changes
Upgrades nginx to 1.14.0-0ubuntu1.7
Upgrades libnginx-mod-http-lua to 1.14.0-0ubuntu1.7
Upgrades Chronograf to 1.8.0
Upgrades add-on base image to v5.0.1
Update community forum links

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

e-krebs · March 12, 2020, 5:50pm

Thanks so much for this add-on !
I just installed it and it works

I was wondering how I can import existing data from home assistant to influxDb ?
(from before Influx is installed, or by overwriting everything)

filiplaznicka · March 18, 2020, 10:05pm

Hi guys
Anyone able to use InfluxDB running as hassio addon to store Proxmox performance data.
I have my HA runing on Intel NUC in Proxmox VM. In HA I have installed the InfluxDB addon. Proxmox has ability to store the performance data in external InfluxDB database but it can do so only over UDP. I’m no expert but it seems the Hassio addon for InfluxDB has open only TCP on port 8086, correct? So I won’t be able to forward the Proxmox data into my HA InfluxDB instance?
Thanks

pex81 · March 21, 2020, 10:09pm

Hi, I have the same configuration as you, I tried to configure so influxdb but it doesn’t work, I opened an issue.
Not bind on :8089 port

While I have tried influxdb on raspberry without docker and it works

auth: true
reporting: true
ssl: true
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_UDP_ENABLED
    value: 'true'
  - name: INFLUXDB_UDP_BIND_ADDRESS
    value: ':8089'
  - name: INFLUXDB_UDP_DATABASE
    value: proxmox
  - name: INFLUXDB_UDP_0_BATCH_SIZE
    value: '1000'
  - name: INFLUXDB_UDP_BATCH_TIMEOUT
    value: 1s
log_level: info

olijouve · March 22, 2020, 9:50am

Remove this or set ssl to false

pex81 · March 22, 2020, 10:13am

thanks for the answer, I had already tried.
If I try to remove the parameters I get an error, if I disable ssl it doesn’t work the same.

auth: true
reporting: true
ssl: false
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_UDP_ENABLED
    value: 'true'
  - name: INFLUXDB_UDP_BIND_ADDRESS
    value: '0.0.0.0:8089'
  - name: INFLUXDB_UDP_DATABASE
    value: proxmox
  - name: INFLUXDB_UDP_0_BATCH_SIZE
    value: '1000'
  - name: INFLUXDB_UDP_BATCH_TIMEOUT
    value: 1s
log_level: info

filiplaznicka · March 22, 2020, 6:16pm

Hi
I do not think changing ssl will work. I was looking through the container and it seems it does not exposes the UDP port 8089 as standard InfluxDB image does. So we are not able to connect that way.
May be Frenck can add the port in next version of the addon?
Thanks

frenck · March 23, 2020, 3:24pm

Release v3.6.1

Full Changelog

This is a general maintenance release.

Changes

Upgrades InfluxDB to 1.7.10
Upgrades Kapacitor to 1.5.4-1

Questions? Join our Discord server! https://discord.me/hassioaddons
Enjoying my add-ons? Consider supporting my work:
https://github.com/sponsors/frenck or https://patreon.com/frenck

WouterR · April 3, 2020, 2:37pm

I’m having an issue where I suspect InfluxDB of keeping my CPU load very high. At moments the Home Assistant becomes unresponsive and even connection losses. After stopping several Addons, CPU load returned to normal after a couple of hours! But immediately after starting InfluxDB, CPU load increases and remains high.

In the screenshot, the CPU load decreases at approximately 6:15 in the morning. I shut down a lot of addons at 23:00 the evening before. At first I concluded this was not related, so I restarted addons one at a time, keeping an eye on CPU load. InfluxDB is clearly causing an issue with CPU load going up. And it remained high for hours. Could it be an issue caused by InfluxDB?

frits1980 · April 3, 2020, 3:08pm

Everything is possible, did you check if it might as well be something generating a lot of data to write to the DB, or a very heavy query for something? Also you could try a new empty DB. Maybe it’s corrupt.

WouterR · April 10, 2020, 9:27am

Took a while, but found some spare time to have a look at it. Apparently I did not set up the ‘include’ variable in the config. As a result everything was logged to the influx database. I’ve now set up a couple of sensors and influxdb is running just fine!

badachon · April 26, 2020, 10:48pm

Hello,
I have a problem with Influxdb 3.6.2, no database created (see screenshot)
my config:
influxdb:
auth: true
reporting: true
ssl: false
certfile: fullchain.pem
keyfile: privkey.pem
envvars: []
log_level: info

config.yaml
influxdb:
host: a0d7b954-influxdb
port: 8086
database: homeassistant
username: homeassistant
password: xxxxxxxx
max_retries: 3
default_measurement: state

and the logs after start influxdb

badachon · April 26, 2020, 10:52pm

influxdb11366×863 138 KB

badachon · April 26, 2020, 10:55pm

influxdb21600×900 356 KB

MasseBanan · May 6, 2020, 9:20am

Yeah, I also would like to know if thats possible

gt4020 · May 8, 2020, 6:56am

Hi, I’m new with influx db and there is a thing that i can’t understand: i used include statement to include 2 xiaomi temperature/humidity sensor: i included only temperature sensor in statement but in influx db i noticed that also all attributes of those sensors are included (battery, signal, humidity etc.). I don’t need to store that data… There is a way to not include attributes in the db?

dakkerd · May 15, 2020, 2:16pm

Even after a couple of months looking, still no solution. I’m on ’ Home Assistant 0.109.6’ now.

I get the error:

Database host is not accessible due to ‘HTTPConnectionPool(ol(host=‘Ip-address-goes-here’, port=8086): Max retries exceeded with url: /write?db=homeassistant_influx (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0xad1672d0>: Failed to establish a new connection: [Errno 111] Connection refused’))', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds.

I use the following config in InfluxDB

auth: true
reporting: true
ssl: true
certfile: fullchain.pem
keyfile: privkey.pem
envvars:
  - name: INFLUXDB_HTTP_LOG_ENABLED
    value: 'true'
log_level: info

I’ve been banging my head on it for months. Any clues on where to start to debug this one?

When adding the db/user and pass to the config in YALM of the InfluxDB I get a different error namely

Database host is not accessible due to ‘(‘Connection aborted.’, BrokenPipeError(32, ‘Broken pipe’))’, please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE. Retrying again in 60 seconds.