Graph module

feedparakeet

@PointPubMedia Thanks! It worked!
Final setup is: php scripts which grab info from fixer.io (eur + usd) and btc-e.com (bitcoin), put them to InfluxDB and display with Grafana. Works like a charm!
Here is a screenshot from my MM. Looks beautiful in general. But still, few minor things to work on.

feedparakeet

@qistoph, thank you, I really appreciate your response. It took me few weeks to understand how do graphs work and get what I need. Finally I did it with Grafana + InfluxDB + PHP scripts. Now I understand that each graph is very special and you need quite a few options to get it work like you want. So, Grafana is the solution for what I was looking for. Don’t think it will be easy to create a universal graph module to satisfy all my needs, like I thought it before. Thanks anyway!

feedparakeet

@d3r It is absolutely possible with Grafana + iFrame module and a bit of magic lol

jalmaas

@feedparakeet How did you get grafana to use all black background?

feedparakeet

@jalmaas I did it with a very rude way. I have changed all 141414 color to 000000 for background settings in /usr/share/grafana/public/css/grafana.dark.* files
Same way you can remove everything else, like Grafana logo.

nerakhon

@feedparakeet Have you also seen the nasty empty square on the bottom of grafana iframe exports? I’m trying to get rid of it, but so far with no success. As well if you by chance found out how to get rid of the background grey without messing up with grafana CSS, that would be a great asset :)!

feedparakeet

@nerakhon nope, I didn’t see any square really. The only thing I did is CSS change. You can select this square in Chrome browser and right click “View the source”, it will show you the certain part of the HTML, which you can later find in Grafana’s templates.
Don’t think there is any workaround to change background without changing CSS.

planet4

@feedparakeet Thanks for sharing. I have really tried to remove the Grafana header but it wont work. Were able to replace the grey with black. Would it be possible for you to share your css files. Tried every setting in Grafana but it does not seem to be any good way to remove the header. Is the css files you have modified only for the snaphots and shared graphs?

feedparakeet

@planet4 , what I did is:

cd /usr/share/grafana/public/css
find . -type f -exec sed -i.bak "s/141414/000000/g" {} \;

This command creates a .bak files with the original content of each modified file in case you would like to turn everything back.
Then, I enabled General-Dimentions-Transparent for each graph. And enabled General-Toggles-Hide controls for a dashboard.
My grafana’s header automatically goes away in few minutes if I don’t touch anything or move mouse. But even if I don’t see grafana’s grey header line, I can still see grafana’s orange-colored label.
Does your grafana’s grey header goes away if you don’t touch anything for 5 minutes? If not, then you should update to a new version. This feature is quite new.

SvenSommer

I wrote a little blog post, to describe how to use Influxdb and Grafana to build a weather chart. It’s available here.

planet4

@SvenSommer Very nice! I will try this as soon as I have reinstalled my old RPI. I have used the database to get info from home assistant so I can display graphs from my z wave sensor. However I am just wondering how it can display the graph as Grafana have a login page with password. Do I have to do something special in order to make this work.

SvenSommer

@planet4 The tutorial explaines how to enable authentication via http to access influxdb without login.

You’re changing parts 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
...

To access your Grafana graphs remotely, you can use the share option to get a public accessible link. The same url uses MMM-GrafanaChart to show the graph on the mirror.

Let me know if you ran in any problems…

feedparakeet

@planet4 if you want to see Grafana’s charts without login\password, you should turn on anonymous access.

Edit /etc/grafana/grafana.ini

[auth.anonymous]
enabled = true
org_name = FeedParakeet
org_role = Viewer

Then you should go to Grafana’s GUI - Profile settings and set the “Name” field equal to the “org_name” value.

Your graphs will be visible to anyone. But it wil be impossible to change anything without loging in.

SvenSommer

@feedparakeet
I think there is even a better way. You can share each panel individually.
http://docs.grafana.org/reference/sharing/

feedparakeet

@SvenSommer wow, it works even easier, thanks

planet4

Ok, Almost there. The gauge shows perfect on my mirror. Influx and Grafana is setup. I get the data from this sensor. http://aeotec.com/z-wave-sensor.

However I still get the grey/brown background on the mirror. Tried to set it to transperant and also modified the css files as described in a post before here. It is just not black. Any smart ideas?

SvenSommer

@planet4 I’m glad to hear, everything worked out as expected.

If you want to do me a favor. Please let others know in the module teaser thread, you were able to use the module. So maybe other lose their fear. ;)
I had a look at changing the background color by inverting the colors of the “white” theme. Didn’t worked out, cause it’s no real white neither.