How to view only yesterday rrd4j graph?

rrd4j
graphs
Tags: #<Tag:0x00007fae070ebb38> #<Tag:0x00007fae070eb9d0>

(Rich Koshak) #8

Has anyone posted a tutorial on how to do this anywhere (wiki, forum posting I’ve missed, blog, anything) I can point people to? If I had a nickle for every time I’ve waved my hands and said “use something else, InfluxDB looks cool…” I could quit my job and actually spend some time on the OH 2 docs (life has sucked the past couple of months).


( ) #9

Hey @rlkoshak,
having a tutorial to point to was exactly what I was missing too when composing this answer. I have a working installation on my side and now that you mention it, yes I’ll write a tutorial soon. The time is right, as I will integrate InfluxDB+Grafana into openHABian as an optional component in the next few weeks. @martiniman if you are interested, let me know for a quick unpolished guide :wink:

@rlkoshak Longer answer, off topic:
I decided on three goals for myself: 1. push the OH2 docs forward (I am now one of the repo maintainers), 2. make starting off with openHAB as easy as possible (openHABian is receiving a good amount of attention) and 3. provide users with more guidance and inspiration.
I talked to Kai the other day and we agreed, that the “Tutorials & Examples” category should be made more relevant. I am now the unofficial moderator of this category and will soon start by creating a pinned article, giving some recommendations and a style guide on how to post tutorials or examples. openHAB heavily depends on other tools, on binding specific settings, on device specific items and on use-case specific rules. For everyone, not only new users, I think it will be incredibly helpful to find dozens of tutorials, examples and snippets to build upon. I agree, that it would be great to at some point have a big set of articles we can point to in threads like this.

On a side note, “life has sucked the past couple of months”, I hope you are doing okay and wish you all the best!


(p0lar) #10

I would gladly test and unpolished docs you have for installs. for OH1 or OH2


(Rich Koshak) #11

I LOVE the openHABian idea. What can be easier than writing an SD image for a Pi and you are ready to go. I know there is already a Docker image as well (official?) and I’d be shocked if there were not VMs of various flavors. All of which I think are good ideas for getting up and running quickly (when the time comes I’m going to migrate to a Docker instance).

I could also see an installation ISO that installs a minimal OS with openHAB.

Sigh, so many ideas, so little time.

I like the idea of standardized format as well. I’ve been trying to follow the same format for my Rules DSL Design Patterns see:

(see the bottom of the thread for my most recent patterns). Of course these are a more limited use case (just rules, no external stuff) but they might provide a starting point for a comprehensive format and style guide.

Do you think these will live here on the Forum or become incorporated into the HTML Docs?

The sticky should also include links to some of the older repositories for tutorials like the wiki, at least until we can rework them into the new format.

Thanks. It is nothing major, just a bunch of little things hit all at once which combine to major stress. After the 23rd things should calm down and I can spend some time on the docs again.


openHABian hassle-free openHAB Setup
(martiniman) #12

Yes i interested, but i use mysql (mariadb). Is Grafana works with mysql?


(Kjetil Asdal) #13

So, you’re saying there is an ARM version of InfluxDB+Grafana now? I’d love to have that into openHABian!!!

I used to run this combo for my “Historical data”-persistence needs before I moved to an ARM platform (Raspberry then ODROID and now back to Raspberry again). When I switched, I was looking for InfluxDB and Grafana but one or the other (I don’t remember which) was not available for ARM at that point.


( ) #14

Hey @KjetilA,
I have the combo running on another more powerful server of mine and am actually not sure about wether or not it’s possible. It was on my personal agenda to figure this out. Sorry for maybe spoiling your hopes…


( ) #15

http://docs.grafana.org/datasources/overview - not directly but seems like you could use Prometheus as a catalyzer.


(Kjetil Asdal) #16

I am glad to hear that you are thinking about this at least. Crossing my fingers!

No worries! I am sure it will eventually be supported.


(Kjetil Asdal) #17

Hmm…

Apparently something have indeed happened with InfluxDB since I last looked:

https://influxdata.com/downloads/#influxdb

And there seems to be some unofficial builds of Grafana here:

https://github.com/fg2it/grafana-on-raspberry

I have not tried any of this, but it seems there is hope at least…


( ) #18

Just made the same findings. Yay! :blush: I’ll try getting it integrated in openHABian as soon as possible.


( ) #19

@martiniman @rlkoshak I got an unfinished version ready, including installing, configuring and connecting everything. What’s still missing are a few recommendations on how to best configure diagrams and how to get them back into your sitemap. I hope it’s useful.


(Rich Koshak) #20

I don’t use my sitemap except for debugging but I’m still going to do this. Thanks!


( ) #21

I actually use Grafana for graphing all kinds of data, including countless server statistics like CPU utilization, mail query size or HDD temperature. By installing the whole “TICK” stack, you can collect, visualize and notify status data.


( ) #22

I want to maintain snippets and examples here in the forum. There is never one RIGHT solution and problems might occur on other systems. Users should be allowed to ask questions or propose improvements. The tagging and sorting/filtering system of discourse will ensure some management.

Regarding tutorials, they should also for now be posted in the forum, I might like to adopt some to the docs as soon as they hit a certain amount of maturity.

Good point. I’ll open a new thread to organize the transition when the time is right. Time is the limiting factor :slight_smile:


(Csongor Varga) #23

Just a random thought: can you create a rule that runs each midnight, generates the graph and saves it as a static image? Just add that image to the sitemap. I am guessing it does not need to be interactive.


(martiniman) #24

May be its will work. But how using rules copy image?


(Csongor Varga) #25

Sorry, I am also just a beginner in OH. The answer is most probably in a pyhton script. You just use the rule to execute it once a day (actually it can also be a simple cron job).

Something like this: http://stackoverflow.com/questions/13137817/how-to-download-image-using-requests


( ) #26

Good idea. This should be possible by creating a cron job (linux cron, not openhab rule) at midnight with the following content:

wget -O /etc/openhab2/html/daily-graph.png http://myopenhabsystem:8080/path-to/graph-to-download.png

This should save the graph at midnight to the static content folder which in return is available at http://myopenhabsystem:8080/static/daily-graph.png hence can be displayed with a sitemap image element.


(Rich Koshak) #27

Thanks to @ThomDietrich’s great write-up:

InfluxDB+Grafana persistence and graphing

You could switch to InfluxDB + Grafana. It lets you surviving a relative begin and end date in the graph URL.

begin=now-2d&end=now-1