InfluxDB - no retentionpolicy showing up

[dakkerd (Dirk Dorme)]

I followed, or try to, video of frenck on adding an influxDB and monitoring state changes of Home assistant.

• So I added a db, with a user and permissions all to the influxDB
• I modified the config yaml using the instructions as follows:

influxdb:
  host: a0d7b954-influxdb
  port: 8086
  database: homeassistant
  username: homeassistant
  password: <yourpassword>
  max_retries: 3
  default_measurement: state

That should do it to show some retentionpolicy on the explore tab of influxdb. But there is no db.retentionpolicy to be found anywhere.

Any pointers?

[Mikefila]

Go to influx -->admin(crown icon), highlight the DB and edit. There you can then change the retention policy.

[dakkerd (Dirk Dorme)]

The retention policy is infinite. I mean that there is nothing showing up on the explore tab.

[Mikefila]

On that page top left, there is a drop down. Is your instance selected?

[dakkerd (Dirk Dorme)]

It might not, but equally no idea what exactly you are referring to. Full screenshot:

Dropdown gives me this:

[Mikefila]

Where it says dynamic sources, but It should show with that selection. There should be another option for localhost.

[dakkerd (Dirk Dorme)]

Indeed, modified previous post. Allow me to add the dropdown again:

[Mikefila]

That’s it, it’s set right. Is there anything in the addon log in the supervisor?

[dakkerd (Dirk Dorme)]

I get this:

time="2021-12-27T17:19:42+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:50136" response_time=2.546317ms status=200
time="2021-12-27T17:19:44+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:50154" url=/Roboto-Medium.7030d125.ttf
time="2021-12-27T17:19:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:50154" response_time=129.095454ms status=200
time="2021-12-27T17:19:45+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:50158" response_time=1.340306ms status=204
time="2021-12-27T17:19:45+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:50160" url=/RobotoMono-Medium.ed4bd09b.ttf
time="2021-12-27T17:19:45+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:50162" response_time=2.223115ms status=200
time="2021-12-27T17:19:45+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:50160" response_time=76.389242ms status=200
time="2021-12-27T17:19:51+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:50198" response_time="97.944µs" status=200

Seems ok to me, but nothing shows up anyway.

[dakkerd (Dirk Dorme)]

If relevant: running the metaquery SHOW DATABASES it does not show anything either. So something is wrong with the DB’s (I’m guessing). Tripple checked db, user and pass. Dead end.

[Mikefila]

Is this a new install or is this something that was working and stopped? Do you have grafana installed, is there data there?

Just to be sure it’s not a browser/machine error, have you tried accessing it from the app or another machine/browser?

[dakkerd (Dirk Dorme)]

This is a new installation, a previous one did not work for me either. I indeed hoped with a new install…

When submitting the metaquery it keeps on ‘spinning’, aka it does not give any results. Would the PI not be powerfull enough to run influxdb?

There is no data in grafana.

[dakkerd (Dirk Dorme)]

Thanks!

Indeed, a browser issue. Safari works just fine, FF does not.

Waw, I’ve should have tried that before. I do apologize!