# NR+influxdb+grafana

**URL:** <https://discourse.nodered.org/t/nr-influxdb-grafana/31667>\
**Category:** General\
**Created:** [17 August 2020 16:43 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667 "2020-08-17T16:43:23Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 13:48 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/21 "2020-08-23T13:48:52Z")

</div>

Show us the datasource settings

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [23 August 2020 13:56 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/22 "2020-08-23T13:56:28Z")

</div>

![Grafana Set up](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/a/2a04ab964bbfd499c0444feb5fe42475ffcd01e0.jpeg)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 14:36 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/23 "2020-08-23T14:36:21Z")

</div>

Are influx and grafana running on the same computer?

How did you install influx and grafana?

What application are you running where you show the database contents?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [23 August 2020 15:06 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/24 "2020-08-23T15:06:31Z")

</div>

Yes, they running on the same computer

I install influxdb and grafana by this:

> **[Installing InfluxDB & Grafana on Raspberry Pi](https://simonhearne.com/2020/pi-influx-grafana/)**
>
> I recently treated myself to a RaspberryPi 4 Model B to use as a(nother) home server. This is a brief guide on getting InfluxDB and Grafana set up to store and graph timeseries data.

I use NR for app (or you mean something else?)

What do you mean by:where you show the database contents?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 15:38 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/25 "2020-08-23T15:38:40Z")

</div>

> [@Martin10](#):
>
> What do you mean by:where you show the database contents?

A couple of posts back you showed the database contents. How did you access the database to show that data? Normally one would use the `influx` command to check the contents of the database.

I note that in the tutorial linked he has the user name grafana, but you have specified admin, did you create a user (in influx) called admin or did you follow the tutorial?

What does this command show  
`sudo systemctl status influxdb`

**[Edit]**  
A further thing to try to help diagnose the problem, run in a terminal,  
`sudo tail -f /var/log/syslog`  
and leave it running (hit enter a couple of times and it will put some blank lines in). Then go to the grafana window and try and save again. See if anything is added to syslog. If yes then copy/paste it here please (preferably copy/paste if you can rather than a screen shot). Use the `</>` button when pasting it here.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [23 August 2020 16:50 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/26 "2020-08-23T16:50:50Z")

</div>

I access the database to show that data, with this:

```auto
influx
show databases
>use TEMPERATURES
>show MEASUREMENTS
>SELECT * FROM temp

```

Yes, i created a user (in influx) called admin.

The command sudo systemctl status influxdb show :

```auto
pi@raspberrypi:~ $ sudo systemctl status influxdb
● influxdb.service - InfluxDB is an open-source, distributed, time series databa
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset:
   Active: active (running) since Sat 2020-08-22 21:29:55 EEST; 22h ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 548 (influxd)
    Tasks: 15 (limit: 4915)
   CGroup: /system.slice/influxdb.service
           └─548 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Aug 23 17:57:20 raspberrypi influxd[548]: ts=2020-08-23T14:57:20.751873Z lvl=inf
Aug 23 17:57:20 raspberrypi influxd[548]: [httpd] 192.168.1.8 - - [23/Aug/2020:1
Aug 23 17:59:29 raspberrypi influxd[548]: ts=2020-08-23T14:59:29.968134Z lvl=inf
Aug 23 17:59:29 raspberrypi influxd[548]: ts=2020-08-23T14:59:29.968379Z lvl=inf
Aug 23 18:29:29 raspberrypi influxd[548]: ts=2020-08-23T15:29:29.968159Z lvl=inf
Aug 23 18:29:29 raspberrypi influxd[548]: ts=2020-08-23T15:29:29.968419Z lvl=inf
Aug 23 18:59:29 raspberrypi influxd[548]: ts=2020-08-23T15:59:29.968208Z lvl=inf
Aug 23 18:59:29 raspberrypi influxd[548]: ts=2020-08-23T15:59:29.968464Z lvl=inf
Aug 23 19:29:29 raspberrypi influxd[548]: ts=2020-08-23T16:29:29.968204Z lvl=inf
Aug 23 19:29:29 raspberrypi influxd[548]: ts=2020-08-23T16:29:29.968455Z lvl=inf
lines 1-19/19 (END)

```

After run:  
`sudo tail -f /var/log/syslog`  
This is added to syslog:

```auto
Aug 23 19:42:46 raspberrypi grafana-server[1642]: t=2020-08-23T19:42:46+0300 lvl=eror msg="Failed to update last_seen_at" logger=context userId=1 orgId=1 uname=admin error="attempt to write a readonly database"
Aug 23 19:42:46 raspberrypi grafana-server[1642]: t=2020-08-23T19:42:46+0300 lvl=eror msg="Failed to update datasource" logger=context userId=1 orgId=1 uname=admin error="attempt to write a readonly database" remote_addr=[::1]
Aug 23 19:42:46 raspberrypi grafana-server[1642]: t=2020-08-23T19:42:46+0300 lvl=eror msg="Failed to rotate token" logger=context userId=1 orgId=1 uname=admin error="attempt to write a readonly database"
Aug 23 19:42:46 raspberrypi grafana-server[1642]: t=2020-08-23T19:42:46+0300 lvl=eror msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=PUT path=/api/datasources/1 status=500 remote_addr=[::1] time_ms=4 size=41 referer=http://localhost:3000/datasources/edit/1/
Aug 23 19:45:10 raspberrypi grafana-server[1642]: t=2020-08-23T19:45:10+0300 lvl=eror msg="failed to run garbage collect" logger=remotecache.database error="attempt to write a readonly database"
Aug 23 19:45:10 raspberrypi grafana-server[1642]: t=2020-08-23T19:45:10+0300 lvl=eror msg="failed to lock and execute cleanup of expired auth token" logger=auth error="attempt to write a readonly database"
Aug 23 19:45:10 raspberrypi grafana-server[1642]: t=2020-08-23T19:45:10+0300 lvl=eror msg="Problem reading image dir" logger=cleanup error="open /var/lib/grafana/png: permission denied"
Aug 23 19:45:10 raspberrypi grafana-server[1642]: t=2020-08-23T19:45:10+0300 lvl=eror msg="Failed to delete expired snapshots" logger=cleanup error="attempt to write a readonly database"
Aug 23 19:45:10 raspberrypi grafana-server[1642]: t=2020-08-23T19:45:10+0300 lvl=eror msg="failed to lock and execute cleanup of old login attempts" logger=cleanup error="attempt to write a readonly database"

```

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [23 August 2020 17:38 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/27 "2020-08-23T17:38:13Z")

</div>

Did you notice this?

> [@Martin10](#):
>
> `uname=admin error="attempt to write a readonly database"`

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 18:14 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/28 "2020-08-23T18:14:44Z")

</div>

I believe that is referring to the grafana config database, I don't know why it would be read only. I am not at my computer at the moment, have a Google for that error message with grafana see if anything appears.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [23 August 2020 18:15 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/29 "2020-08-23T18:15:28Z")

</div>

So i don't created user correctly?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 19:15 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/30 "2020-08-23T19:15:38Z")

</div>

The error is from grafana, it is not an influxdb issue.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [23 August 2020 20:18 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/31 "2020-08-23T20:18:07Z")

</div>

But Martin has stated:

> [@Martin10](#):
>
> I can see my DB, i just can't do the connection with grafana

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 August 2020 20:47 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/32 "2020-08-23T20:47:06Z")

</div>

The reason it won't connect, I believe, is because Grafana can't write to its configuration database (which is sqlite), so it isn't even getting as far as trying to connect to the influx db.

@martin10 what does this show?  
`ls -l /var/lib/grafana`  
Mine shows

```auto
-rw-r----- 1 grafana grafana 507904 Jun 29 22:01 grafana.db
drwxr-x--- 2 grafana grafana 4096 Mar 12 2019 plugins
drwx------ 2 grafana grafana 4096 Mar 12 2019 png
drwxr-x--- 6 grafana grafana 4096 Mar 4 2017 sessions

```

though mine isn't a standard install so that may not be relevant. grafana.db is the config database I believe.  
Also what about  
`ps -aux|grep grafana`  
That will tell us which user is running grafana

And finally  
`sudo systemctl status grafana-service`

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [24 August 2020 11:52 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/33 "2020-08-24T11:52:07Z")

</div>

```auto
pi@raspberrypi:~ $ ls -l /var/lib/grafana
total 488
-rw-r----- 1 pi grafana 487424 Aug 18 16:05 grafana.db
drwxr-x--- 2 pi grafana 4096 Aug 16 14:11 plugins
drwx------ 2 pi grafana 4096 Aug 16 14:11 png

pi@raspberrypi:~ $ ps -aux|grep grafana
grafana 1231 0.4 1.0 926912 40364 ? Ssl 14:39 0:02 /usr/sbin/grafana-server --config=/etc/grafana/grafana.ini --pidfile=/var/run/grafana/grafana-server.pid --packaging=deb cfg:default.paths.logs=/var/log/grafana cfg:default.paths.data=/var/lib/grafana cfg:default.paths.plugins=/var/lib/grafana/plugins cfg:default.paths.provisioning=/etc/grafana/provisioning
pi 1891 0.0 0.0 7348 524 pts/1 S+ 14:50 0:00 grep --color=auto grafana

pi@raspberrypi:~ $ sudo systemctl status grafana-service
Unit grafana-service.service could not be found.

```

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [24 August 2020 12:02 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/34 "2020-08-24T12:02:21Z")

</div>

> [@Colin](#):
>
> And finally  
> `sudo systemctl status grafana-service`

Maybe that last command can be

```auto
sudo systemctl status grafana-server

```

[Graphana docs](https://grafana.com/docs/grafana/latest/installation/debian/#2-start-the-server)

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [24 August 2020 12:06 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/35 "2020-08-24T12:06:49Z")

</div>

```auto
pi@raspberrypi:~ $ sudo systemctl status grafana-server
● grafana-server.service - Grafana instance
   Loaded: loaded (/usr/lib/systemd/system/grafana-server.service; disabled; vendor preset: enable
   Active: active (running) since Mon 2020-08-24 14:39:48 EEST; 26min ago
     Docs: http://docs.grafana.org
 Main PID: 1231 (grafana-server)
    Tasks: 11 (limit: 4915)
   CGroup: /system.slice/grafana-server.service
           └─1231 /usr/sbin/grafana-server --config=/etc/grafana/grafana.ini --pidfile=/var/run/gr

Aug 24 14:45:31 raspberrypi grafana-server[1231]: t=2020-08-24T14:45:31+0300 lvl=eror msg="Failed 
Aug 24 14:45:31 raspberrypi grafana-server[1231]: t=2020-08-24T14:45:31+0300 lvl=eror msg="Request
Aug 24 14:49:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:49:50+0300 lvl=eror msg="failed 
Aug 24 14:49:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:49:50+0300 lvl=eror msg="Problem
Aug 24 14:49:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:49:50+0300 lvl=eror msg="Failed 
Aug 24 14:49:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:49:50+0300 lvl=eror msg="failed 
Aug 24 14:59:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:59:50+0300 lvl=eror msg="failed 
Aug 24 14:59:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:59:50+0300 lvl=eror msg="Problem
Aug 24 14:59:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:59:50+0300 lvl=eror msg="Failed 
Aug 24 14:59:50 raspberrypi grafana-server[1231]: t=2020-08-24T14:59:50+0300 lvl=eror msg="failed 
lines 1-19/19 (END)

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [24 August 2020 12:36 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/36 "2020-08-24T12:36:30Z")

</div>

> [@Martin10](#):
>
> `-rw-r----- 1 pi grafana 487424 Aug 18 16:05 grafana.db`

How did you manage to get those files owned by pi instead of grafana? Perhaps you tried various methods of installing, for example, so you somehow got to that situation. They should all be owned by grafana. The solution is to fix the ownership  
`sudo chown -R grafana:grafana /var/lib/grafana`  
Then try again. Probably worth restarting grafana, or rebooting, after changing the ownership.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [24 August 2020 15:41 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/37 "2020-08-24T15:41:39Z")

</div>

I made it! Thank you!

But i still got this problem:

 ![2020-08-17-194153_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/6/56a74ad90631dabbec6689b1d471aa10fff51985.png)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [24 August 2020 16:10 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/38 "2020-08-24T16:10:41Z")

</div>

Show us the query you have entered.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [24 August 2020 16:24 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/39 "2020-08-24T16:24:57Z")

</div>

![2020-08-18-135049_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/f/cfc38859c63031c7e1178e10b0efda864a7e6fc8.png)  
 ![2020-08-18-135054_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/9/d996129a975cfe172f436d8677a1bd29d5e87267.png)  
 ![2020-08-18-135100_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0f0e1f1a27ce034241018dfd7543b10235cc32ca.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [24 August 2020 16:30 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/40 "2020-08-24T16:30:47Z")

</div>

Is `defauld` really the name or should it be `default`?  
 ![Screen Shot 2020-08-24 at 12.29.34 PM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/0/90e4e48f1511657e5ec6bb8f5fa1fa23632ffa91.png)

[Previous page](https://discourse.nodered.org/t/nr-influxdb-grafana/31667.md?page=1)

[Next page](https://discourse.nodered.org/t/nr-influxdb-grafana/31667.md?page=3)
