chpro/fronius-grafana-dashboard

Database not found Error

Closed this issue · 5 comments

I've setup everything according to the readme.. however it is not working for me
image
image
image

Hi, hard to say whats the problem. Please try the following got to the data source and select your configured datasource (/connections/datasources). Click in the upper right corner on Explore Data and try to configure it like

image

The dropdowns will only show available fields in the database. After configuration you can click on pencil
image then you see the query. Then you can adapt the query to the available field. If no fields are available there is either the wrong token configured, the token has no access to database or no data in database. Don't forget the the http header needs to have the word Token as prefix in the value field.

Custom HTTP details:
Authorization: Active token in Token yourAuthToken form. Token can be created in load-data/tokens that has access to the specified bucket.

So token should be fine
Screenshot_20240305_174046_Brave
Screenshot_20240305_174021_Brave

Just for clarification: Is there a difference between database and bucket?

It seems there is a difference between database and bucket. Here you can find a description about it https://ivanahuckova.medium.com/setting-up-influxdb-v2-flux-with-influxql-in-grafana-926599a19eeb please try to follow the instructions about Map InfluxDB v2 buckets to InfluxDB v1 databases. If it works I will add it to the README

I did not have the problem because I have migrated from InfluxDB v1 to InfluxDB v2.

Yes it works, should be added to README. Buckets aren't DBs in V2. So I assume they are migrated when upgrading from V1. It is important that the rentention policy name (rp) is autogen! With influx bucket list you can retrieve the IDs needed for the following command.

influx v1 dbrp create \
  --id 00oxo0X0xx0XXoX0 \
  --rp autogen \
  --default\
  -o organisation \
  -t abcTOKENxyz```