Home Assistant Community Add-on: InfluxDB

I do not see why that should not work…

Is this a common string for all installations or should it be ‘localhost’ or the IP address (if fixed) of the server?

A restart is taking an absolute age once this is enabled.

this is the docker reference, should be common.
I dont have any issues with restarting.

@Rusty_nl, Ok, thanks. Did not want to work for me but I have Hassio on the HASSOS VM so maybe there is a difference there (for the host entry). It has worked now with the IP Address.

No idea why, but this addon has made my system virtually unusable. Chewing up a massive amount of VM resources and, for instance, loading the Hassio page in HA takes about 90s. Disabled, and everything back to normal. A restart of HA took about 10 minutes with it running about 2 with it off.

Influx DB not updating the database after a reboot ,
this happens to me all time that i have to update hass , and need a reboot , so i loose all data everytime .

the message i see on the idb logs is

error msg=“failed to connect to InfluxDB, retrying…” service=influxdb cluster=default err=“Get http://localhost:8086/ping: dial tcp 127.0.0.1:8086: connect: connection refused”

i would like to know if others are experiencing the same issue , and in that case , if found a workaround .
thanks

I had the same issue after installing. None of my screens would load. Ended up rebooting and uninstalling the add-on. Now I see two additional database log files with different extensions. History and Logbook will not show anything now.

The additional ones are temp files - you will see them come and go if you refresh…

Right,
but I pretty sure I didn’t have the 2 files .db-shm and .db-wal prior to installing this add-on. And if so, after removing the add-on, should they still be there?

Those files have nothing to do with this add-on, it doesn’t store anything in config/.

Awesome, just wanted to make sure I didn’t mess anything up.

Thanks

As I said, those 2 files come and go all the time. If you open up Winscp and browse to your config folder and refresh a few times you will see this.

:tada: Release v1.2.0

This release upgrades a lot (including InfluxDB), fixes a couple of issues with timing between starting all the services and adds authentication against Home Assistant!

From this point on, you can log in, into the web interface, using your Home Assistant frontend username and password.

Full Changelog

Changed

  • Upgrades InfluxDB to v1.7.0
  • Upgrades Chronograf to v1.7.1
  • Give InfluxDB more time to start, before init script
  • Makes Chronograf wait until InfluxDB is started
  • Makes Kapacitor wait until InfluxDB is started
  • Removes ipv6 configuration option
  • Upgrades nginx to 1.14.0-0ubuntu1.2
  • Adds support for the authentication against Home Assistant
  • Limit supported machines (#12) (@HoppingMonk)
  • Updates documentation for HA Auth

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

1 Like

HI @frenck , is very good to see the password management improved , and the addon loading improvements too !, thank you !

on the influx webui , i see that now the explorer is not working couldnt add a single meassure , not internal, not external , flux, i dont know what its functionallity is, but it shows a message , that is not available for the type of database ( probably both issues are connected?) .

so with the current version , the influx web UI , has no functionallity on any of its tools , it is usefull to make fast test , would be good to know how to have it back .

the DB is working fine .

Hello, just upgraded the component to version 1.2. I have a new error on startup:

Here the log:

[s6-init] making user provided files available at /var/run/s6/etc…exited 0.
[s6-init] ensuring user provided files have correct perms…exited 0.
[fix-attrs.d] applying ownership & permissions fixes…
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts…
[cont-init.d] 00-banner.sh: executing…

Hass.io Add-on: InfluxDB v1.2.0
Scalable datastore for metrics, events, and real-time analytics
From: Community Hass.io Add-ons
By: Franck Nijhof [email protected]

armhf / HassOS 1.12 / HA 0.81.6 / SU 139 / stable

[cont-init.d] 00-banner.sh: exited 0.
[cont-init.d] 01-log-level.sh: executing…
Log level is set to INFO
[cont-init.d] 01-log-level.sh: exited 0.
[cont-init.d] 02-updates.sh: executing…
INFO: You are running the latest version of this add-on
[cont-init.d] 02-updates.sh: exited 0.
[cont-init.d] 10-requirements.sh: executing…
[cont-init.d] 10-requirements.sh: exited 0.
[cont-init.d] 11-nginx.sh: executing…
[cont-init.d] 11-nginx.sh: exited 0.
[cont-init.d] 20-system-users.sh: executing…
[cont-init.d] 20-system-users.sh: exited 0.
[cont-init.d] 21-auth.sh: executing…
[cont-init.d] 21-auth.sh: exited 0.
[cont-init.d] 30-kapacitor.sh: executing…
[cont-init.d] 30-kapacitor.sh: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
INFO: Starting the InfluxDB
INFO: Kapacitor is waiting until InfluxDB is available…
INFO: Chronograf is waiting until InfluxDB is available…
2018/11/10 12:09:54 [error] 705#705: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.30.32.1, server: hassio.local, request: “GET /chronograf/v1/me HTTP/1.1”, upstream: “http://127.0.0.1:8889/chronograf/v1/me”, host: “hassio.local:8888”, referrer: “http://hassio.local:8888/sources/0/hosts
INFO: Starting Chronograf

Here the config file:
{
“log_level”: “info”,
“auth”: true,
“ssl”: false,
“certfile”: “fullchain.pem”,
“keyfile”: “privkey.pem”
}

What am I missing ?
Thanks

@monster Euh nothing? Since the above logs look fine.

@frenck , Well in the influxdb web pages (status, host list) the blu whinning circle keeps running , the db seems empty, the alerting page says “The current source does not have an associated kapacitor istance” the previous release didn’t show. My HA configuration:

immagine

Thanks

I just installed the latest version (1.2) and no matter what I do or enter a username/password pop-up prevents me from reaching the setup page.

My configuration looks like this:

{
  "log_level": "info",
  "auth": true,
  "ssl": false,
  "certfile": "fullchain.pem",
  "keyfile": "privkey.pem"
}

and the log looks like this:

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] 00-banner.sh: executing... 

-----------------------------------------------------------
 Hass.io Add-on: InfluxDB v1.2.0

 Scalable datastore for metrics, events, and real-time analytics

 From: Community Hass.io Add-ons
 By: Franck Nijhof <[email protected]>
-----------------------------------------------------------
 armhf / Debian GNU/Linux 9 (stretch) / HA 0.82.1 / SU 139 / stable
-----------------------------------------------------------
[cont-init.d] 00-banner.sh: exited 0.
[cont-init.d] 01-log-level.sh: executing... 
Log level is set to INFO
[cont-init.d] 01-log-level.sh: exited 0.
[cont-init.d] 02-updates.sh: executing... 

INFO: You are running the latest version of this add-on
[cont-init.d] 02-updates.sh: exited 0.
[cont-init.d] 10-requirements.sh: executing... 
[cont-init.d] 10-requirements.sh: exited 0.
[cont-init.d] 11-nginx.sh: executing... 
[cont-init.d] 11-nginx.sh: exited 0.
[cont-init.d] 20-system-users.sh: executing... 
[cont-init.d] 20-system-users.sh: exited 0.
[cont-init.d] 21-auth.sh: executing... 
[cont-init.d] 21-auth.sh: exited 0.
[cont-init.d] 30-kapacitor.sh: executing... 
[cont-init.d] 30-kapacitor.sh: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
INFO: Starting the InfluxDB
INFO: Kapacitor is waiting until InfluxDB is available...
INFO: Chronograf is waiting until InfluxDB is available...
INFO: Starting Chronograf
INFO: Starting the Kapacitor

'##:::'##::::'###::::'########:::::'###:::::'######::'####:'########::'#######::'########::
 ##::'##::::'## ##::: ##.... ##:::'## ##:::'##... ##:. ##::... ##..::'##.... ##: ##.... ##:
 ##:'##::::'##:. ##:: ##:::: ##::'##:. ##:: ##:::..::: ##::::: ##:::: ##:::: ##: ##:::: ##:
 #####::::'##:::. ##: ########::'##:::. ##: ##:::::::: ##::::: ##:::: ##:::: ##: ########::
 ##. ##::: #########: ##.....::: #########: ##:::::::: ##::::: ##:::: ##:::: ##: ##.. ##:::
 ##:. ##:: ##.... ##: ##:::::::: ##.... ##: ##::: ##:: ##::::: ##:::: ##:::: ##: ##::. ##::
 ##::. ##: ##:::: ##: ##:::::::: ##:::: ##:. ######::'####:::: ##::::. #######:: ##:::. ##:
..::::..::..:::::..::..:::::::::..:::::..:::......:::....:::::..::::::.......:::..:::::..::

2018/11/17 01:39:40 Using configuration at: /etc/kapacitor/kapacitor.conf
time="2018-11-17T01:39:41-05:00" level=info msg="Serving chronograf at http://127.0.0.1:8889" component=server 
time="2018-11-17T01:39:41-05:00" level=info msg="Reporting usage stats" component=usage freq=24h reporting_addr="https://usage.influxdata.com" stats="os,arch,version,cluster_id,uptime" 

So, as you can see no errors. I even tried the debug log level but no errors as well.

Any idea why it keeps asking for username and password anytime I try to access it using port 8888?

Any tips about how to troubleshoot this issue?

did anybody found a way to make , the web UI to connect to the data base ?

i still have influx config on the config.yaml , should i delete that part ?

> influxdb:
>   host: a0d7b954-influxdb
>   port: 8086
>   database: homeassistant
>   username: myuser
>   password: mypassword
>   default_measurement: state

I have the same problem, it’s impossible to login in the web gui, please @frenck can you help us? thanks