InfluxDB+Grafana persistence and graphing

[BrutalBirdie (Elias)]

Fresh Setup.

The openHAB version with my 389 Items is not on a Pi.
I am clueless.

[Dim (Angelos)]

check something in the console…

config:list "(service.pid=org.openhab.influxdb)"

and compare the output to your /etc/openhab2/services/influxdb.cfg

check also: /var/lib/openhab2/config/org/openhab/influxdb.config

[BrutalBirdie (Elias)]

openhab> config:list "(service.pid=org.openhab.influxdb)"
----------------------------------------------------------------
Pid:            org.openhab.influxdb
BundleLocation: null
Properties:
   db = openhab_db
   password = SneekyLittleHobbits
   retentionPolicy = autogen
   service.pid = org.openhab.influxdb
   url = http://127.0.0.1:8086
   user = openhab

/var/

db="openhab_db"
password="SneekyLittleHobbits"
retentionPolicy="autogen"
service.pid="org.openhab.influxdb"
url="http://127.0.0.1:8086"
user="openhab"

[Dim (Angelos)]

looks good…

I don’t know what else to suggest…

Here is my TRACE log from my influxdb persistence service (working fine):

29-Aug-2017 18:03:41.880 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - Tried to get item from item class class org.openhab.core.library.items.NumberItem, state is 64.8
29-Aug-2017 18:03:41.881 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - found fractional part
29-Aug-2017 18:03:41.881 [DEBUG] [tence.influxdb.internal.InfluxDBPersistenceService] - got DecimalType value 64.8
29-Aug-2017 18:03:41.882 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - storing mP6_01_01_P in influxdb value 64.8, mP6_01_01_P (Type=NumberItem, State=64.8)
29-Aug-2017 18:03:41.884 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - Tried to get item from item class class org.openhab.core.library.items.NumberItem, state is 234
29-Aug-2017 18:03:41.884 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - found no fractional part
29-Aug-2017 18:03:41.885 [DEBUG] [tence.influxdb.internal.InfluxDBPersistenceService] - got DecimalType value 234
29-Aug-2017 18:03:41.886 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - storing mP6_01_01_V in influxdb value 234, mP6_01_01_V (Type=NumberItem, State=234)
29-Aug-2017 18:03:41.887 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - Tried to get item from item class class org.openhab.core.library.items.NumberItem, state is 8.3
29-Aug-2017 18:03:41.887 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - found fractional part
29-Aug-2017 18:03:41.888 [DEBUG] [tence.influxdb.internal.InfluxDBPersistenceService] - got DecimalType value 8.3
29-Aug-2017 18:03:41.897 [TRACE] [tence.influxdb.internal.InfluxDBPersistenceService] - storing mP6_01_02_P in influxdb value 8.3, mP6_01_02_P (Type=NumberItem, State=8.3)
...(aloooot of entries)...

[ThomDietrich]

Hey guys, I’m also unsure what’s going on here. As it seems like the connection is established without issues, I’d suspect the persist file to be faulty, leading to no persistence. Try to recreate the file. Here is mine.

[Dim (Angelos)]

@ThomDietrich

I’m also unsure what’s going on here

we hijacked your thread!

@ThomDietrich

I’d suspect the persist file to be faulty

seems so (but Elias fixed it)…

[rlkoshak (Rich Koshak)]

Posting this here as I think most of the people watching this thread might be interested and may miss my main posting.

Data Science Humble Bundle

Wasn’t sure where to put this. The Humble Bundle currently has a Data Science O’Reily book bundle, one of which at the $1 level is about Timeseries Databases (hello InfluxDB users). If any of you are wanting to learn what sorts of things you can learn from the information you are already capturing you won’t find a better deal. I’m not sure how available Humble Bundle is internationally. I hope most of you who want to can take advantage of this deal.

[hamwong]

HI, when use openhab cloud to access basic_ui, I aware grafana is not showing,
is there anyway that I can make it show? limit from to local setting or cloud end setting?

[rtvb (Robert)]

your local grafana server (ip address) is probably not available from the Internet.

[edgi (Eduard)]

for Grafana, you can not specify a local address, for example http://192.168.1.10:3000 or http: // localhost: 3000, you need to specify the external address of the server with the free port 3000 port.

[edgi (Eduard)]

@ThomDietrich

…as ‘Image’ Element

not work Android app, works only ‘Webview’ Element

[rlkoshak (Rich Koshak)]

@edgi

not work Android app, works only ‘Webview’ Element

I’ve found the opposite. Image works just fine and Webview doesn’t work in the Android app.

Sample of my current setup:

                                Switch item=aChart_Period label="" mappings=[0="Hour", 1="Day", 2="Week", 3="Month"]
                                Image label="Temperatures" refresh=60000 visibility=[aChart_Period==0] url="http://argus.koshak.net:3000/render/dashboard-solo/db/home-automation?orgId=1&from=now-1h&to=now&panelId=1&theme=light&width=1000&height=500&tz=UTC-06%3A00"
                                Image label="Temperatures" refresh=60000 visibility=[aChart_Period==1] url="http://argus.koshak.net:3000/render/dashboard-solo/db/home-automation?orgId=1&from=now-1d&to=now&panelId=1&theme=light&width=1000&height=500&tz=UTC-06%3A00"
                                Image label="Temperatures" refresh=60000 visibility=[aChart_Period==2] url="http://argus.koshak.net:3000/render/dashboard-solo/db/home-automation?orgId=1&from=now-1w&to=now&panelId=1&theme=light&width=1000&height=500&tz=UTC-06%3A00"
                                Image label="Temperatures" refresh=60000 visibility=[aChart_Period==3] url="http://argus.koshak.net:3000/render/dashboard-solo/db/home-automation?orgId=1&from=now-1M&to=now&panelId=1&theme=light&width=1000&height=500&tz=UTC-06%3A00"

Note that argus.koshak.net:3000 is my local DNS path to Grafana and not accessible on the internet. It isn’t terribly fast but it works just fine through myopenhab.org.

[hamwong]

Thanks for your reply
do you mean change in grafana.ini domain = xxx? and it have to be a public domain and can’t be private ip?
so I also need to change basic UI URL from private to public?
like DDNS?

[edgi (Eduard)]

@rlkoshak

I’ve found the opposite. Image works just fine and Webview doesn’t work in the Android app.

I do not understand. Your examples do not work for me. Only Webview works.

Summary

Android app ver: 1.8.0.8

Webview works:

your examples:

your examples (I tried different versions of altered experiments. nothing succeeded):

Image label="SpeedTest" refresh=60000 url="http://192.168.1.25:3000/render/dashboard-solo/db/openhab?from=now-1h&to=now&panelId=1&theme=light&width=490&height=351&tz=UTC-06%3A00"
Image label="SpeedTest" refresh=60000 url="http://192.168.1.25:3000/render/dashboard-solo/db/openhab?panelId=1&theme=light&width=490&height=351"
Image label="SpeedTest" refresh=60000 url="http://edgi-server:3000/render/dashboard-solo/db/openhab?orgId=1&from=now-1w&to=now&panelId=1&theme=light&$
Image label="SpeedTest" refresh=60000 url="http://edgi-server:3000/render/dashboard-solo/db/openhab?orgId=1&from=now-1M&to=now&panelId=1&theme=light&$

Webview work:

Webview url="http://192.168.1.25:3000/render/dashboard-solo/db/openhab?panelId=1&width=490&height=351&from=now-12h&to=now"

`

[rlkoshak (Rich Koshak)]

I don’t know what to tell you.

I’ve tried webviews and I’ve never been able to get any webview to work in the Android App when I’m connected remotely through myopenhab.org.

The only way I’ve ever been able to get charts in the Android app when connected remotely through myopenhab.org is to have Grafan prerender the graphs and put them on my sitemap using the Image tag.

When you go into Grafana and click on “Share” for one of your charts, there is a little link at the bottom that says “Direct link rendered image”. That is the URL you need to put on your sitemap with the Image element.

This code is actively working for my right now running an oldish OH 2.2 Snapshot (around built 1000, just before the log4j2 change) and the latest Android app from the Play Store.

[hamwong]

HI Rich,

How are you, do you mind advise how to set local DNS and not accessible on the inetrnet?
does local DNS path should set as (192.xxx.xxx.xxx)?

Thanks in advance.
Ham

[rlkoshak (Rich Koshak)]

It’s a feature I can set up in my router. If your router doesn’t d support it you will have to look it up on Google.

[TommySharp]

Is anyone able to help me decipher why my grafana chart is showing the incorrect amount on the chart for total memory? I must have set something up wrong? It seems to be showing as the total of both total memory and used memory…

[ThomDietrich]

@TommySharp

It seems to be showing as the total of both total memory and used memory…

And that is exactly what you’ve configured I suspect It’s pretty clear because of these little bumps. Go to “Display” and disable “Stack”

[Josar]

@hamwong have a look here

Openhab2+Grafana HABdroid Webview

I followed the instruction from here and here on how to install and configure InfluxDB and Grafana for my RPI3, consulting grafana-on-raspberry for up do date install instructions and had some further reading on influxDB or Grafana . I run InfluxDB, Grafana and OpenHAB on the RPI3. As the webview element in Android App did not log in and showed the loggin credentials i thought of setting up the webview url with user credentials. Calling the url from the browser got me a warning that the pag…