search

chpro / fronius-grafana-dashboard

Setting up and visualizing data from your Fronius Symo GEN24 10.0 inverter and Smart Meter TS 65A-3 using InfluxDB and Grafana.
MIT License
34 stars 2 forks source link

Database not found Error #7

Closed Peddaahh closed 3 months ago

Peddaahh commented 3 months ago

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

chpro commented 3 months ago

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.

Peddaahh commented 3 months ago

So token should be fine Screenshot_20240305_174046_Brave Screenshot_20240305_174021_Brave

Peddaahh commented 3 months ago

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

chpro commented 3 months ago

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.

Peddaahh commented 3 months ago

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```