Hello All, i’m in need of a tiny bit of help…
I’m sure the issue will be obvious to someone, i can’t seem to put my finger on it.
I confess i ventured into installing InfluxDB and Grafana from the openhabian-config>optional components installation ( i thought: “it’s been 2 years ever since Thomas Dietrich wrote this tutorial, let’s be brave!” - btw the tutorial is definitely still relevant, so TY).
The automated setup process sets up most of the things for you, basically all there is left is to install the addon in paperui and schedule a persistence job.
I now have the follwoing situation:
Grafana says it has no issues in connecting to opehab_db from influx as datasource
Influx receives data from OH, as per the scheduled job, (with precision rfc3339)
…But when i go creating a graph in my first dashboard
i don’t get any result, except for a “no data points” written in the middle of the graph.
I’m sure i missed something silly (as usual for any first timer the amount of info can be overwhelming).
EDIT: do i need to write SELECT * FROM … so influxdb CLI commands in the grafana query for it to work??
EDIT 2: i’ve tried logging into influx’s CLI with grafana’s credentials and reading the measurements, but got this error:
so i guess the automated process doesn’t do
EDIT for anybody who might face the same issue
if you install Grafana and InfluxDB from the automated procedure in the openhabian-config, you need to log into influx’s CLI as ‘admin’ with the ‘SuperSecretPassword123+’ you’ve set up during the process, and do the 2 GRANT commands above. otherwise it’s not going ot work XD
took me hours (-.-) XD