MMM-GrafanaCharts and MMM-GrafanaGauges: Display you data with Charts and Gauges. Beautifully.

planet4

Tried this and it works fine. The simple way to show temperatures is this:

alt text

The more complicated but more fun way is this:
alt text

I have tried to use Grafana before but had problems with headers etc. Thanks to this module most problems are solved.

I get the data from my z Wave sensor http://aeotec.com/z-wave-sensor. This is connected to a raspberry running home assistant. On another raspberry I use influxdb and grafana. Home assistant is sending influx data to this PI. On the thirs Raspberry i run Magic mirror and the result is displayed. The only issue is that in dark light you can see the border and background in the graph even if it is set to black. Maybe this is just a feuture of the mm and the screen.

I also tried to use the same module to display if the door is locked or unlocked. I also get the data from home assistant.

planet4

Regarding the black background I think it is solved. Maybe there was some kind of cache problem. After chaning the css files it looks perfect.

SvenSommer

@planet4 good news!
Can you please share which CSS file, and what you edited?

fox

Can i also show there other temperatures?
Like temperatures from 1-wire Dallas sensor or from a http site?

SvenSommer

@fox
Short answer: No, not the direct way.

Long answer: You need to write your temperature data into a database which is connected with Grafana. Then you can use this module to display your graph created by grafana.

One possible solution: This tutorial shows an example, on how to store weather data from an external source in a local influxdb database, which is connected to grafana.
You could reuse the example code an edit it, to get your data stored in a influxdb database.

fox

@SvenSommer said in MMM-GrafanaCharts and MMM-GrafanaGauges: Display you data with Charts and Gauges. Beautifully.:

@fox
Short answer: No, not the direct way.

Long answer: You need to write your temperature data into a database which is connected with Grafana. Then you can use this module to display your graph created by grafana.

One possible solution: This tutorial shows an example, on how to store weather data from an external source in a local influxdb database, which is connected to grafana.
You could reuse the example code an edit it, to get your data stored in a influxdb database.

i will try your possible solution :) Thank you

edit:

thanks for sharing the link.
I installed influxDB and grafana as written on your page.
I also added the datasource to grafana.

You mean i have to update this script?

importForecast.js

SvenSommer

@fox Yes, this script is responsible for getting the data into the database.

If you would like to show other data with Grafana, you need to save the data you get from your sensor.

sceletus

How do you manage credential to get access to grafana?
Thanks in advance.

yours.mukul

How to install Grafana? Does that debian work fine on rpi? I am confused since the architecture is different and I think the packages should be different as well.

I know its a very stupid question, but please help

SvenSommer

@yours.mukul
Yes just follow these instructions:
http://docs.grafana.org/installation/debian/

SvenSommer

@sceletus
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

everything is described in the tutorial on http://robstechlog.com/2017/06/30/personal-weather-chart-module/

hunty1980

@planet4 Are you able to provide steps on how you managed to update the CSS file to match the black background of the MM?

planet4

@hunty1980 I used this guide https://forum.magicmirror.builders/topic/1675/graph-module/18

planet4

@SvenSommer Have not used this module for a while but have now reinstalled Grafana and would like to try it again. However I can not remember how to solve the login to Grafana. I think I opened it up as public the last time but is not an option now. At the moment the mirror just shows erroe as it can not login to the Grafana dashboard. Please advise.

planet4

I was able to solve the login issues but now its just black. Maybe this module does not work with the new version of Grafana?

SvenSommer

@planet4 Hey, I just tried it with the actual Grafana v6.0.1 (commit: 0c44a04)
It worked for me without any adjustments.

Maybe I can support you, to set it up.

planet4

@SvenSommer Thanks for replying. I was actually able to solve it but with version 6 of Grafana black background is more of a trouble. Wrote a short post about this as well.

http://www.planet4.se/grafana-in-magic-mirror/

I am now able to show my Solar production on my mirror. 0,36kW. Will post this in the show my mirror as well. Thanks.

teitlebot

@planet4 thanks
your post helped me half way
im using home assistant to host grafana so i needed to create an org called home assistant.

planet4

@teitlebot I am using Home Assistant as well but Grafana is not used as an add-in on Hassio. I have it on a separate docker container. However I gave up Grafana in the end. It was to much problems. Now I use MQTT to get all information I want from Home Assistant to my Mirror. Like this:

http://www.planet4.se/magic-mirror-info-via-mqtt/

teitlebot

@planet4 What other problems did grafana give you? I am also using the mmm hass component to pull in sensor date but maybe I will switch to mmm mqtt. I really wanted to show some nice graph though. Also how did you build the total solar energy sensor saving in hass? I build it in graphana following someones tutorial,