Home Assistant Community Add-on: InfluxDB

Installation Home Assistant OS
,
381

I am trying to get started on influxDB.

I have installed the add-on and can access the web-UI. However there is nothing there apart from the connection status.

Following this:

It says create a database:
“You will still need to create a database named home_assistant via InfluxDB’s command-line interface. For instructions on how to create a database check the InfluxDB documentation relevant to the version you have installed.”

That link doesn’t work however the documentation says to go to the influx CLI.

Can I no create a database from within HA?

382

Followed this video by @frenck . I reach the step where I connect Glances database to Grafana.
I keep getting this error.

Web capture_14-2-2023_215438_192.168.10.6
Web capture_14-2-2023_215438_192.168.10.61255×1246 119 KB

This is the error in error connecting influxDB influxQL
What am I doing wrong?

Home Assistant 2023.2.4
Supervisor 2023.01.1
Operating System 9.5
Frontend 20230202.0 - latest
Glances Current version: 0.17.2.
Influxdb Current version: 8.1.0
Grafana Current version: 8.1.0

Update: database and info proccessing options were disabled under the addon config.
** working now!!!**

384

Hi, how did you enable the options? I can’t find it.

My Grafana that was working since ever started to show no data…

385

Actually I just noticed the same thing. Is it relevant to install an add-on no longer maintained since 2021?

386

If i delete the whole integration, is there then no data left behind?

387

Where does it store the data?

388

possibly not the right place to ask, so sorry for that. i am trying to get the second (or n-th) value of the day for a certain measurement and i really can’t figure out how. first/last are quite obvious, using the built-in functions. thank you for any suggestions.

389

Like @Cococabana above, I wanted to move from the internal 1.x version to an external 2.7 on a Synology NAS (in Docker). Because v1 and v2 handle the data in different ways, there does not appear to be a beginner friendly way of transferring the data, so I just cut my losses and went for the new install and stopped collecting the data internally.

My InfluxDB database takes up more than half my backups, so I wanted to find an alternative storage.

What I would really like is a way to use the add-on, but store the data on my NAS. Is that possible?
(I’m not holding my breath - and sadly this thread is more questions than solutions these days.)

390

My InfluxDB and Grafana addons keep crashing recently. The logs show the exact same error message:

s6-rc: warning: unable to start service base-addon-timezone: command exited 2

However the base-addon-timezone seems to be working for all other addons in my installation.

Except for updates I’m not aware that I’ve changed anything recently.

Things I tried without success:

  • rebooting
  • increasing the VM’s RAM to 3 GB
  • removing the InfluxDB addon and re-installed it from scratch
  • setting logging to debug

Do you have any advice on how to access the in-contailer logging mentioned in the error message. I could not figure out how to access those for a crashing container…

The full logs are:

Add-on: InfluxDB
 Scalable datastore for metrics, events, and real-time analytics
-----------------------------------------------------------
 Add-on version: 4.7.0
 You are running the latest version of this add-on.
 System: Home Assistant OS 10.2  (amd64 / qemux86-64)
 Home Assistant Core: 2023.6.2
 Home Assistant Supervisor: 2023.06.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums or the Discord chat.
-----------------------------------------------------------
s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-timezone: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
[17:19:06] INFO: Configuring timezone (Europe/Berlin)...
s6-rc: info: service base-addon-log-level successfully started
s6-rc: warning: unable to start service base-addon-timezone: command exited 2
/run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
/run/s6/basedir/scripts/rc.init: fatal: stopping the container.
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service base-addon-log-level: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service base-addon-log-level successfully stopped
s6-rc: info: service base-addon-banner: stopping
s6-rc: info: service base-addon-banner successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped
s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service base-addon-banner: starting
391

Hi all,
I have just mounted my Synology NAS to my RPi where HA is running.
How I could change the configuration of InfluxDB to save data on NAS disk?
Many thanks for any support you could provide.

392

Hi, i cant find a way to export influxdb database. Using commands influxd from ssh terminal does not work (it give command not found error). Someone can help? Thank you

394

I managed it 2 years ago, but things may have changed. I now have my database on a separate PVE setup!

395

Hello Frenck,

I have installed and uninstalled InfluxDB several times without success.

Unfortunately, I’m now at the end of my knowledge, I only have rudimentary knowledge of programming.

But you could already incorporate a lot into your “Wonderful World of Home Assistant”.

A really great project in my opinion, thank you for your time, work and effort!

The InfluxDB doesn’t start properly, can you help me or someone from the Home Assistant group? I would be happy to find a solution, thank you!

I’ve made a few attempts with changes in the config yaml, without success.

I’ve been stuck with this problem for a few days now.

Here is the log from the start:

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service base-addon-banner: starting

Add-on: InfluxDB
Scalable datastore for metrics, events, and real-time analytics

Add-on version: 4.8.0
You are running the latest version of this add-on.
System: Home Assistant OS 11.1 (amd64 / generic-x86-64)
Home Assistant Core: 2023.10.5
Home Assistant Supervisor: 2023.10.1

Please, share the above information when looking for help
or support in, e.g., GitHub, forums or the Discord chat.

s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-timezone: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
[19:00:14] INFO: Configuring timezone (Europe/Berlin)…
s6-rc: info: service base-addon-log-level successfully started
s6-rc: info: service base-addon-timezone successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/create-users.sh
[19:00:18] INFO: InfluxDB init process in progress…
[tcp] 2023/11/01 19:00:23 tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
cont-init: info: /etc/cont-init.d/create-users.sh exited 0
cont-init: info: running /etc/cont-init.d/influxdb.sh
cont-init: info: /etc/cont-init.d/influxdb.sh exited 0
cont-init: info: running /etc/cont-init.d/kapacitor.sh
cont-init: info: /etc/cont-init.d/kapacitor.sh exited 0
cont-init: info: running /etc/cont-init.d/nginx.sh
cont-init: info: /etc/cont-init.d/nginx.sh exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun chronograf (no readiness notification)
services-up: info: copying legacy longrun influxdb (no readiness notification)
services-up: info: copying legacy longrun kapacitor (no readiness notification)
services-up: info: copying legacy longrun nginx (no readiness notification)
[19:00:24] INFO: Chronograf is waiting until InfluxDB is available…
[19:00:24] INFO: Kapacitor is waiting until InfluxDB is available…
s6-rc: info: service legacy-services successfully started
[19:00:24] INFO: Starting the InfluxDB…
[19:00:29] INFO: Starting Chronograf…
[19:00:29] INFO: Starting the Kapacitor

‘##:::’##::::’###::::’########:::::’###:::::’######::’####:’########::’#######::’########::
##::’##::::’## ##::: ##… ##:::’## ##:::’##… ##:. ##::… ##…::’##… ##: ##… ##:
##:’##::::’##:. ##:: ##:::: ##::’##:. ##:: ##:::…::: ##::::: ##:::: ##:::: ##: ##:::: ##:
#####::::’##:::. ##: ########::’##:::. ##: ##:::::::: ##::::: ##:::: ##:::: ##: ########::
##. ##::: #########: ##…::: #########: ##:::::::: ##::::: ##:::: ##:::: ##: ##… ##:::
##:. ##:: ##… ##: ##:::::::: ##… ##: ##::: ##:: ##::::: ##:::: ##:::: ##: ##::. ##::
##::. ##: ##:::: ##: ##:::::::: ##:::: ##:. ######::’####:::: ##::::. #######:: ##:::. ##:
…::::…::…:::::…::…:::::::::…:::::…:::…:::…:::::…::::::…:::…:::::…::

2023/11/01 19:00:29 Using configuration at: /etc/kapacitor/kapacitor.conf
time=“2023-11-01T19:00:32+01:00” level=info msg=“Serving chronograf at http://127.0.0.1:8889” component=server
time=“2023-11-01T19:00:32+01:00” level=info msg=“Reporting usage stats” component=usage freq=24h reporting_addr=“https://usage.influxdata.com” stats=“os,arch,version,cluster_id,uptime”
[19:00:33] INFO: Starting NGINX…

396

I’m getting the exact same logs, stuck at Starting NGINX…

I had to uninstall the add-on completely since it would prevent HA from starting correctly on reboot (time out errors everywhere in my logs, CPU running very high).

I’m sure it’s just a temporary snag. I’ll be waiting for a fix since this looks like the perfect solution for the custom component I’m working on.

If there is any info I can provide I’ll be happy to help.

UPDATE: Managed to get it started after updating to latest version of supervisor (2023.11.2, from 2023.10.1). However CPU usage remains high and my host (R-pi 3) keeps crashing.

397

I’m too is stuck at Starting NGINX… Running latest HAOS and core.

398

Any update? I too have the same problem

399

Do you see the Open WEB UI button on the first page of the Addon?

400

Hello since 2 weeks my InfluxDB doesn’t work anymore. InfluxDB crasches al the time.

If uninstalled influxDB. En installed it again. Now everything works fine again. But now i want to restore data back to de InfluxDB. Becourse i have 3 years data.

I have a full backup of the influxDB.Tar.gz file. (800MB data) But i don’t no how i restore the data back to the new influxDB. I can only import a *.CSV file

Please can someone help me to restore my InfluxDB.

Regards,

Dolby

401

Problem solved with HA update

403

Franck
I appreciate all you do here, thanks.
I wonder if you could help me with a problem regarding my InfluxDB size?
After 4 years it’s over 15Gb because I never set a retention policy nor did I exclude anything. My backups are 18Gb and take 2 days to upload to Google Drive cloud.
I’ve now set a retention and have added Includes for just the stuff I want and have also set about deleting entirely all the stuff already in the database I don’t want.
But - How can I force the database file to re-size itself. I’ve done lots of searching but come up with nothing apart from others asking (no answers) and something on an Influx site talking about ‘Compacting’ that requires Unix like commands, but I don’t know how this translates to Influx as an Add-On in HA.

Grateful if you could help