InfluxDB+Grafana persistence and graphing

[YogiBB (Yogi)]

I already used htop to find which process cause this issue. It was grafana. I’m not sure if both CPU was on 100%, but it looks like it completely freeze whole openhab for a while. PaperUI and Habpanel wasn’t accesible during this peaks. When I removed graphs from Habpanel, CPU is fine and there is no peak for last week.

for habpanel I tried two aproaches

One was:
Rule:

rule "Store Graph Outside temp"
when
    Item Balcony_Temperature received update
then
    executeCommandLine("curl -L 'http://ip:3000/render/d-solo/v9xT1ZRgz/temoutside?panelId=2&orgId=1&tab=general&refresh=30m&width=500&height=250&tz=UTC%2B02%3A00' -o /etc/openhab2/html/grafana/graph_temp_outside.jpg", 5000)
end

Habpanel:

<object width="500" height="250" data="/static/grafana/graph_temp_outside.jpg" type="image/jpeg"></object>

And second one was access to graph right from the habpanel in object

Both with same result

[rlkoshak (Rich Koshak)]

Well, at this point I think you will need to go to a Grafana forum to get help. We use Grafana but none of us are experts here.

[adtwomey]

Hi guys I about to go tho the steps that was posyed Sep “2016” I runing a Raspberry Ip with openhabian that runing openhab 2.4.

I use VS Coda also with doing some files

On do I just run tho the post in Sep “16” or is there an updated posted.

[rlkoshak (Rich Koshak)]

@adtwomey

On do I just run tho the post in Sep “16” or is there an updated posted.

The original post was updated as improvements and other ideas were discovered so everything in the first post should be complete and up to date.

[adtwomey]

@rlkoshak

The original post was updated as improvements and other ideas were discovered so everything in the first post should be complete and up to date.

ok time to start is it hard to do?

[adtwomey]

@ThomDietrich

After successful installation you should be able to reach the Grafana dashboard at http://monitoring-host:3000 with the default login admin:admin - be sure to change the password now!

I already useing port :3000 with an MQTT Broadlink Bridge

[Dim (Angelos)]

@adtwomey

I already useing port :3000 with an MQTT Broadlink Bridge

so… either change the port on the bridge or change the default port of Grafana…

[adtwomey]

I trying MQTT but hoping I don’t stuff it up. Can’t find out how to do it with Grafana that why I trying with MQTT 1st

[adtwomey]

Fixed

[Dim (Angelos)]

@adtwomey

Can’t find out how to do it with Grafana

Technical documentation | Grafana Labs

Summary

[adtwomey]

thanks will check before asking sorry for posting but lol getting close to finshed in

[adtwomey]

@ThomDietrich

You may skip the extra security steps for Authentication and Authorization , depending on the reachability of your monitoring-host . In this case, you only need to create the database.

Is @ThomDietrich saying I can skip

@ThomDietrich

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

Because I did and now in data Source when adding openhab_db I get

InfluxDB Error: error authorizing query: create admin user first or disable authentication

[adtwomey]

@ThomDietrich

Enable authentication in the [http] section of the configuration file /etc/influxdb/influxdb.conf :

[http]  
enabled = true  
bind-address = ":8086"      # change to a specific interface if needed 
auth-enabled = true         # will enforce authentication

Ok fixed if you

auth-enabled = false         # will enforce authentication

If anyone as “not smart” like me

[iksiksiks (Marino)]

Hi! If anyone is in the need of processing large amounts of data from OH1 rrd to OH2 influx maybe can be interested in this: rrdToInflux
I was in the need today and just dodged some manual work with this
HTH

[Marcin_J]

Has anyone problem with the recent update of android OpenHAB application?
Grafana in WebView returns error (after tap on exclamation mark):

Invalid dimensions for plot, width = 384, height = 0

In previous OpenHAB android app I saw grafana chart without problems.

[Dim (Angelos)]

@Marcin_J

Has anyone problem with the recent update of android OpenHAB application?

https://community.openhab.org/search?q=grafana%20category%3A18

Webview Graphs not showing in Android App

Working again with Version 2.4.1. Thanks for the effort!

[HolgiHab (Holgi)]

Hello,

I followed this nice tutorial to set up Influxdb and Grafana, but I get stuck while adding a datasource:

Openhab can write to the InfluxDB, according the service status:

● influxdb.service - InfluxDB is an open-source, distributed, time series database
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2018-11-19 22:59:38 CET; 10min ago
     Docs: https://docs.influxdata.com/influxdb/
 Main PID: 406 (influxd)
   CGroup: /system.slice/influxdb.service
           └─406 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Nov 19 23:05:24 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:05:24 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 36e449b3$
Nov 19 23:05:54 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:05:54 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 48b70f43$
Nov 19 23:06:24 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:06:24 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 5a98c234$
Nov 19 23:06:54 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:06:54 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 6c7a5eb2$
Nov 19 23:07:24 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:07:24 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 7e5b8809$
Nov 19 23:07:54 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:07:54 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" 903d9099$
Nov 19 23:08:24 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:08:24 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" a21f3831$
Nov 19 23:08:54 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:08:54 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" b400dafa$
Nov 19 23:09:24 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:09:24 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" c5e28e36$
Nov 19 23:09:54 openHABianPi influxd[406]: [httpd] 127.0.0.1 - openhab [19/Nov/2018:23:09:54 +0100] "POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=openhab HTTP/1.1" 204 0 "-" "okhttp/2.4.0" d7c42e49$

Excerpt from

/etc/influxdb/influxdb.conf

[http]
  # Determines whether HTTP endpoint is enabled.
   enabled = true

  # Determines whether the Flux query endpoint is enabled.
  # flux-enabled = false

  # The bind address used by the HTTP service.
   bind-address = ":8086"

  # Determines whether user authentication is enabled over HTTP/HTTPS.
   auth-enabled = true

My influxdb.cfg:

# The database URL, e.g. http://127.0.0.1:8086 or https://127.0.0.1:8084 .
# Defaults to: http://127.0.0.1:8086
url=http://127.0.0.1:8086

# The name of the database user, e.g. openhab.
# Defaults to: openhab
user=openhab

# The password of the database user.
password=supersecret

# The name of the database, e.g. openhab.
# Defaults to: openhab
db=openhab_db

# The retention policy to be used, needs to configured in InfluxDB
# Till v0.13: 'default', since v1.0: 'autogen'
retentionPolicy=autogen

Any idea why Grafana is not able to connect to the DB?

[Dim (Angelos)]

@HolgiHab

Any idea why Grafana is not able to connect to the DB?

change the Data Source type from Graphite to InfluxDB

[HolgiHab (Holgi)]

@Dim

Shame on me, the only setting I did not transfer carefully.

I remember one of my profs saying “90% of all problems can be solved by looking carefully!”

He was right, thank you!

[Guillermo_Schimmel]

Try this in grafana.ini

[auth.basic]
enabled = false