You should bisect your problem. See if data is being written into influx. Try using the command line and select the measurements after opening the database. See this InfluxDB getting started guide. Also, you should see the writes happening in your /var/log/syslog file (assuming you haven’t turned off the write logging). If this is good, proceed to debug Grafana. If you don’t see data, nothing you do in Grafana will help.
That will pull out all the Influx entries in the syslog. You can also use nano or any other text editor to examine the syslog. You will always see some activity assuming InfluxDB is running. What you are looking for are http writes to the database.
For #1, see the InfluxDB documentation. This getting started guide is very good. Basically something like this:
> show databases (will show databases)
> use openhab_db (or whatever you named it)
> show measurements (should see your Item here in the list)
> select * from Temperature_GF_Living
You should see a list of values for your measurement with their timestamp. You may need to use the user/password when starting up if you set that up. This will use the default retention policy. I’m guessing you haven’t changed that.
If you see the measurements, then you know the data is getting written, and your issue is only with setting up Grafana. If you can’t see the measurements, then we need to figure out why they are not written out.
Did you follow the instructions on this post originally? If so, that’s where you set the password for your database. Or did you follow some other guide? It seems like you didn’t grant the openhab user access to the openhab_db. Probably you did create an admin password?
Connected to http://localhost:8086 version 0.13
InfluxDB shell version: 0.13
> CREATE DATABASE openhab_db
> CREATE USER admin WITH PASSWORD 'SuperSecretPassword123+' WITH ALL PRIVILEGES
> CREATE USER openhab WITH PASSWORD 'AnotherSuperbPassword456-'
> CREATE USER grafana WITH PASSWORD 'PleaseLetMeRead789?'
> GRANT ALL ON openhab_db TO openhab
> GRANT READ ON openhab_db TO grafana
In case you don’t remember what you did, you can stop influxdb, turn off authentication, start it up and enable it with a new password. See this for more information.
OK, sorry about that …
I just noticed that you are running Raspbian and looks like you where using the Ubuntu install instructions. The install commands should look like this,(because Raspbian is a distribution based on Debian):
Thanks to another post I figured out how to get access to the files via Filezilla, I now edited the files are per above however when I take the influxdb.conf file from my the PI to PC for editing via visual code studio and try to place it back Filezilla comes up with an error…
How can I get around this ?
Disregard please, I edited the file via sudo nano /etc/influxdb/influxdb.conf and the changes seemed to stick