# InfluxDB+Grafana persistence and graphing

**URL:** <https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761>\
**Category:** Tutorials & Examples\
**Tags:** influxdb, graphs, grafana\
**Created:** [September 1, 2016, 5:56pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761 "2016-09-01T17:56:35Z")\
**Posts on this page:** 20\
**Page:** 23

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [December 27, 2017, 7:43pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/447 "2017-12-27T19:43:48Z")

</div>

> [@BenderCy](#):
>
> Maybe the iCloud plugin is not ready for persist and a method needs to be created?

I do not have any recommendations but I can say this is not the case. Persistence works with Items completely independently of the bindings those Items may be linked to.

---

<div class="post-metadata">

**Author:** ![Cyborg](https://community.openhab.org/user_avatar/community.openhab.org/cyborg/32/72963_2.png) [@Cyborg](https://community.openhab.org/u/Cyborg)\
**Post date:** [December 27, 2017, 8:03pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/448 "2017-12-27T20:03:32Z")

</div>

Good to know @rlkoshak and thanks for the information.

I don’t know where to look then. The influxdb.persist works with every other item, it logs without issues and displays in graphana, but no trace of any attempt or try of the icloud binding to persist the changes.

I am quite new to this world, so could anyone let me know how could I report such issue and where?

---

<div class="post-metadata">

**Author:** ![rlkoshak](https://community.openhab.org/user_avatar/community.openhab.org/rlkoshak/32/75251_2.png) [@rlkoshak](https://community.openhab.org/u/rlkoshak)\
**Post date:** [December 27, 2017, 8:05pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/449 "2017-12-27T20:05:31Z")

</div>

> [@BenderCy](#):
>
> but no trace of any attempt or try of the icloud binding to persist the changes.

I recommend posting a new thread to address this specific issue. Post your relevant Item definitions and .persit file.

Look in your logs for errors.

Look in your events.log to verify that your Items are in fact being updated.

---

<div class="post-metadata">

**Author:** ![Cyborg](https://community.openhab.org/user_avatar/community.openhab.org/cyborg/32/72963_2.png) [@Cyborg](https://community.openhab.org/u/Cyborg)\
**Post date:** [December 27, 2017, 8:21pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/450 "2017-12-27T20:21:53Z")

</div>

Yes, that’s all checked. No errors or warnings in the logs (after enabling those via cli). No trace of any error or attempt to persist that item, while everything else does get its way to Influx without issues.

---

<div class="post-metadata">

**Author:** ![Multisaft7](https://community.openhab.org/user_avatar/community.openhab.org/multisaft7/32/6952_2.png) [@Multisaft7](https://community.openhab.org/u/Multisaft7)\
**Post date:** [December 28, 2017, 8:29am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/451 "2017-12-28T08:29:08Z")

</div>

@ThomDietrich any idea where Tiere find this ini?

---

<div class="post-metadata">

**Author:** ![Udo\_Hartmann](https://community.openhab.org/user_avatar/community.openhab.org/udo_hartmann/32/70871_2.png) [@Udo\_Hartmann](https://community.openhab.org/u/Udo_Hartmann)\
**Post date:** [December 28, 2017, 9:37am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/452 "2017-12-28T09:37:38Z")

</div>

I’m not sure, but in recent Grafana there should be the option to deactivate login via UI (not sitting at home now, so I can’t chack)

---

<div class="post-metadata">

**Author:** ![wborn](https://community.openhab.org/user_avatar/community.openhab.org/wborn/32/55946_2.png) [@wborn](https://community.openhab.org/u/wborn)\
**Post date:** [December 28, 2017, 9:44am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/453 "2017-12-28T09:44:51Z")

</div>

> [@juelicher](#):
>
> In the javascript console I see a “same origin error”, probably because grafana listens on port 3000 and my openhab on port 9080, so these don’t match. I wonder, if this might the reason for not updating the panel and what to do to fix it.

If you haven’t fixed it yet @juelicher, recently [some documentation about this issue](https://github.com/wborn/smarthome-grafana#reverse-proxy-configuration) got added.

---

<div class="post-metadata">

**Author:** ![Chris\_Reid](https://community.openhab.org/user_avatar/community.openhab.org/chris_reid/32/47669_2.png) [@Chris\_Reid](https://community.openhab.org/u/Chris_Reid)\
**Post date:** [December 28, 2017, 11:25am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/454 "2017-12-28T11:25:57Z")

</div>

I’ve just clean installed Openhab 2.2 and used the install tool within openhabian-config to add influxDB and Grafana, but I too cannot find the .ini file to edit to enable anonymous login so the charts work in Basic UI.

I’ve got the data logging and persisting, but just can’t get the graphs to display in Basic UI.

I had this working in 2.1 but just can’t get it to in 2.2

---

<div class="post-metadata">

**Author:** ![Udo\_Hartmann](https://community.openhab.org/user_avatar/community.openhab.org/udo_hartmann/32/70871_2.png) [@Udo\_Hartmann](https://community.openhab.org/u/Udo_Hartmann)\
**Post date:** [December 28, 2017, 11:44am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/455 "2017-12-28T11:44:12Z")

</div>

did you try to find it yet?

```auto
sudo find / -name grafana.ini

```

would do the trick.

If there is none: Did you already start grafana once? Maybe the file is generated while first startup.

---

<div class="post-metadata">

**Author:** ![Chris\_Reid](https://community.openhab.org/user_avatar/community.openhab.org/chris_reid/32/47669_2.png) [@Chris\_Reid](https://community.openhab.org/u/Chris_Reid)\
**Post date:** [December 28, 2017, 12:05pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/456 "2017-12-28T12:05:32Z")

</div>

Got it 🙂 I should have known to do that!  
Thanks

---

<div class="post-metadata">

**Author:** ![Cyborg](https://community.openhab.org/user_avatar/community.openhab.org/cyborg/32/72963_2.png) [@Cyborg](https://community.openhab.org/u/Cyborg)\
**Post date:** [December 28, 2017, 1:34pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/457 "2017-12-28T13:34:04Z")

</div>

> [@rlkoshak](#):
>
> I recommend posting a new thread to address this specific issue. Post your relevant Item definitions and .persit file.

Done that now, here: [Persistence not working for GPS location formatted XX.XXX75788937955,-X.XXXX170208076405](https://community.openhab.org/t/icloud-binding-persistance-not-working-for-gps-location/37883)

---

<div class="post-metadata">

**Author:** ![Boogieman](https://community.openhab.org/letter_avatar_proxy/v4/letter/b/7ea924/32.png) [@Boogieman](https://community.openhab.org/u/Boogieman)\
**Post date:** [December 28, 2017, 6:26pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/458 "2017-12-28T18:26:14Z")

</div>

thx, now everything is fine

---

<div class="post-metadata">

**Author:** ![DennisVonDerBey](https://community.openhab.org/user_avatar/community.openhab.org/dennisvonderbey/32/72037_2.png) [@DennisVonDerBey](https://community.openhab.org/u/DennisVonDerBey)\
**Post date:** [January 3, 2018, 7:52pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/459 "2018-01-03T19:52:02Z")

</div>

> [@ThomDietrich](#):
>
> DELETE FROM my\_measurement WHERE value = 0

Sadly this doesn’t work anymore for me. Does anybody know why they would disable this?

Now I have to manually delete all entries by doing a SELECT before and getting the timestamps…

---

<div class="post-metadata">

**Author:** ![juelicher](https://community.openhab.org/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@juelicher](https://community.openhab.org/u/juelicher)\
**Post date:** [January 3, 2018, 10:24pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/460 "2018-01-03T22:24:01Z")

</div>

> [@wborn](#):
>
> If you haven’t fixed it yet @juelicher, recently some documentation about this issue got added.

Thanks for pointing me to that part of the documentation, probably I have overlooked it. Installing nginx and configuring a reverse proxy, as described in the docs, solved the issue for me!

---

<div class="post-metadata">

**Author:** ![kevinshane](https://community.openhab.org/user_avatar/community.openhab.org/kevinshane/32/72620_2.png) [@kevinshane](https://community.openhab.org/u/kevinshane)\
**Post date:** [January 9, 2018, 1:18pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/461 "2018-01-09T13:18:22Z")

</div>

hey guys, I came across a small issue: In habpanel, when I use the image that created by grafana’s direct link rendered image, the image can not auto refresh unless I hit F5 to refesh the page, I am not sure if this is even can call a bug… but how could u guys deal with this situation? Do we have a rules that can “trigger auto refresh(re-generate) the image” or do I somehow, I don’t know how, make grafana auto generate the image by a period of time say 5min? or should I deal with the “auto F5 refresh” thing to the browser side(chrome in this case)?

---

<div class="post-metadata">

**Author:** ![noxx](https://community.openhab.org/letter_avatar_proxy/v4/letter/n/f6c823/32.png) [@noxx](https://community.openhab.org/u/noxx)\
**Post date:** [January 21, 2018, 6:43pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/462 "2018-01-21T18:43:37Z")

</div>

sorry, grafana works, inluxdb also. i see a my graph in grafana and also with

```auto
Direct link rendered image

```

in my browser  
URL:

```auto
http://192.168.1.208:3000/render/dashboard-solo/db/gaszaehler?orgId=1&panelId=1&from=1516538410937&to=1516560010937&theme=light&width=1000&height=500&tz=UTC%2B01%3A00

```

OH:

```auto
Image refresh=60000 url="http://192.168.1.208:3000/render/dashboard-solo/db/new-dashboard-copy?orgId=1&panelId=1&from=1516535365910&to=1516556965911&width=1000&height=500&tz=UTC%2B01%3A00"

```

i had edit the /etc/grafana/grafana.ini file

```auto
[users]
# disable user signup / registration
allow_sign_up = false

```

```auto
[auth.anonymous]
# enable anonymous access
enabled = true

```

but no image in Openhab ☹

EDIT  
runs now

seems there is a bug in grafana. if i rename my dashboard, the URL seems wrong.  
in the url i find my old name.

---

<div class="post-metadata">

**Author:** ![Boby](https://community.openhab.org/user_avatar/community.openhab.org/boby/32/64452_2.png) [@Boby](https://community.openhab.org/u/Boby)\
**Post date:** [January 29, 2018, 12:04am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/463 "2018-01-29T00:04:57Z")

</div>

Hi,  
I’m also fighting a terrible fight against Grafana being used behind a nginx reverse proyx (openHABian image).  
My problem is:

This address in the sitemap (Image url=)…

```auto
http://<my_local_ip_address>:3000/render/dashboard-solo/db/temperaturen?orgId=1&panelId=3&width=1000&height=500

```

mutates into this when I check the address of the image in Firefox under BasicUI:

```auto
http://<my_remote_dns_url>/proxy?sitemap=home.sitemap&widgetId=030101&t=1517183948343

```

I have no idea where this transformation happened and what I have to do to make the generated PNG file available for my sitemap. Webview works well, but I also want to have the graphs on my iPhone, so they are no option for me.  
I tried it the past four hours and read more or less all tutorials and threads regarding this topic here, but maybe I missed something…

Any hint appreciated - thank you

---

<div class="post-metadata">

**Author:** ![will\_stewart1a](https://community.openhab.org/user_avatar/community.openhab.org/will_stewart1a/32/17110_2.png) [@will\_stewart1a](https://community.openhab.org/u/will_stewart1a)\
**Post date:** [January 31, 2018, 3:34am UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/464 "2018-01-31T03:34:25Z")

</div>

Is anyone here successfully running Influx 1.4? I originally installed 1.2, which seemed ok. Someone had mentioned they used 1.4, so I switched to that. About that time, the zwave events stopped being stored, though LocalWeather values still persisted. Yet those also are now no longer persisting. Any thoughts, including a retreat to 1.2?

 ![DataGapsInInflux](https://community-openhab-org.s3.dualstack.eu-central-1.amazonaws.com/original/3X/f/4/f43062b98c6c24bd0fff0e814155a4ee29f2ac18.png)

---

<div class="post-metadata">

**Author:** ![anon89326932](https://community.openhab.org/letter_avatar_proxy/v4/letter/a/71c47a/32.png) [@anon89326932](https://community.openhab.org/u/anon89326932)\
**Post date:** [February 3, 2018, 11:19pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/465 "2018-02-03T23:19:17Z")

</div>

Hi  
Is any one know how to unistal infux and grafana?  
in openHABian Configuration Tool I can see only option to install.  
Please

---

<div class="post-metadata">

**Author:** ![Dangar](https://community.openhab.org/user_avatar/community.openhab.org/dangar/32/36866_2.png) [@Dangar](https://community.openhab.org/u/Dangar)\
**Post date:** [February 9, 2018, 9:35pm UTC](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761/466 "2018-02-09T21:35:53Z")

</div>

Thank you for great tutorial.

I have created java utility for conversion rrd file to InfluxDB line protocol file. Maybe it will be helpful to someone else too

More info can be found here:

> **[GitHub - jhron/rrd2influxdb: Tool for converting Openhab rrd4j data file to...](https://github.com/jhron/rrd2influxdb)**
>
> Tool for converting Openhab rrd4j data file to InfluxDB line protocol file.

[Previous page](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761.md?page=22)

[Next page](https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761.md?page=24)
