How to Build a Public Grafana-based Solar Monitoring Dashboard in Home Assistant

If you have a solar inverter setup, one thing you will agree with is that your solar inverter setup data is really important. Another thing that is important is that it is a way to show that your energy production, consumption, and so on is like public.

The thing is that most solar inverter brands have a form of remote data monitoring platform, Vectron’s VRM to Group’s sparkler to Dee’s cloudAmong others. But I am a fan of local control of myself and data. This is a great way to imagine and display all the beautiful data that your fellow tinkers, solar inverter users, and the general public place publicly without trusting the company’s cloud data ligament solutions.

In this article, we will use the data available in our Home Assistant Setup, sending it Influx XDB And make a Graphian Dashboard out of this. In terms of manufacturer, there are many ways to connect your inverter to the Home Assistant. I use the Grot SPFS 6000 Inverter, and I shared a guide to make a local data ligament that works with the home assistant. Here.

The table of content

Provisions

How to install and configure influx DB

We will start with the influx DB. Influx DB is an open source time series database, which is different from the database Home Assistant uses defaultSqlite. We will use influx DB V1, as it is very easy to set up.

Go to your Home Assistant Dashboard and go to Settings> Ed on and click on Ed on Store.

Inside the Ed -On Store, find “inflax DB” and click Ed on. You should see the screen below, then install.

Toggle the “Watch Dog”, as it allows Ed on to resume if it crashes. Also, Toggle the “Show in the Sidebar”, which allows you to watch Ed on the Home Assistant’s sidebar.

Start Ed and see the login to make sure it is working. “Starting NGINX” is an indicator working.

Next, go to your Home Assistant Sidebar and click on Inflactions DB. You need to create a new database to hold your data and also need to create a new user in which the admin gets the privileges of reading and writing data. Go to the inflax DB Admin tab.

Click on the Creation Database – and you can name the database you want. I will name my name Homesist.

By default, maintaining a policy for the created database is infinity (which is forever), but you can create it at any time frame you want. The retention policy refers to the database data time frame. I like to be upset with infinity because I want to keep more data and for that I have enough storage in my home assistant hardware.

Once the database is made, go to the users’ tab so you can create a new admin user. Input the username and password for this user and click on the Grant Admin, so the permission level can be set all over. I created a new user whose name is Root.

At this point, what is left by the influx DB is to start sending sensor data to the Home Assistant to Influx DB. You can do this by going to your home assistant configuration.yaml File and add this Config below to it. Your host is the IP of your Home Assistant, the port influx is a default port for DB Aid on, and the rest of the values ​​are based on the values ​​you have used during the setup.

influxdb:
  host: 192.168.8.12
  port: 8086
  database: homeassistant
  username: root
  password: password
  max_retries: 3
  default_measurement: state

Restart your Home Assistant and go to Inflactions DB. Click on Explore Tab, and check to see if you have Database. Outogen File there. Click on it, and if you see some values ​​under measurements and tags, you are good to go.

Method to install and configure graphrana

Our agenda is to install and create the next grapha. The purpose is to be an influx DB and make dashboards based on questions data.

Go to the Ed on Store, Find Graphana, and install. Remember to togel on these important settings, then start Aid on.

Once it starts, click Graphana on the sidebar. You will arrive at Graphana’s homepage where you can create these dashboards.

But before you do this, you need to connect the inflax DB to graphic. Go to Graphana’s tab >> contacts. You should see a “add a new connection” page. Find the influx DB and select it. Then click the new data source button.

Under HTTP, Edit URL and use – Leave http:// Or try to use localhost Along with this, scroll down on the details of the influx DB and fill the data you used when setting the influx DB. Then click on the Save & Test. If the Config was correct, you should see the Green Tuck and the text that “data source is working … Measurement.”

How to make a graphian solar dashboard

With this, you should run the influx DB and be linked to graphica. Let’s get the construction of beautiful dashboards from all the data produced. This section is sophisticated, so you can feel free to edit and edit your taste design. We will use this dashboard Here As inspiration for our design.

So now go to your graph in the Home Assistant, click on the icon and create a new dashboard.

You should know that the dashboard in Graphana refers to the whole place and everything on the dashboard is a panel. Every theory on the dashboard is a panel.

Let’s create a new panel. Select the influx DB as a data source, and on it By Select the row, W, which is the unit we want to make a concept. In Existence_Ad :: Tag, because this is the way to set the values ​​through the name of the Home Assistant Sensor entity. Then select your panel’s existence ID – is mine Groatt_pv1_ Charge_ Power. You can change the title of the panel, change the concept in the state, and add the watt to yellow as a unit and base color.

Raw query looks like:

SELECT mean("value") FROM "W" WHERE ("entity_id"::tag = 'growatt_pv1_charge_power') AND $timeFilter GROUP BY time($__interval) fill(null)

The Grafana Edit page looks like:

At this point, you should be able to reproduce the rest of the dashboard. But I did all this manually, so if you don’t want you to go through it yourself.

Here A gut hub is a link to the repo that has a json file of this dashboard. When you go to make a dashboard, you will see the option to import from the JSON file. You can choose to copy and paste or upload file, which also works for you.

After import, you need to edit each panel through GUI only to use your entity ID tag and your inflax DB Database UID in home assistant.

A picture of my developed results is:

How to delete a new admin user and delete default Admin User

By default, Graphana Aid on Home Assistant uses an author proxy and configure the default user (admin) With a password (hassio) It is compatible with your HA login session. It prevents passwords or user changes via UI.

For context, a autobiography, or a proxy of verification, works as a batch between a client and target resources, dealt with verification and permission from the client.

As a security phase, we need to make a new user for graphana aid and edit their permission to get admin concessions, then delete the default admin user. This is because you cannot change the default admin password on Ed.

Go to Graphana Menu> Administration> Users and Access> Users. Then create a new user.

Next, give him the admins. Edit yes to Graphana Admin and make sure the role of the organization is set on the admin, then save.

Return to Ed on Configure tab. Scroll into the network setting and add a port to expose the ed on. I will use Port 3000. Save and resume. If you have SSL on and it is not formed, Ed will not start. You can disable it because we will have a cloud flair handle.

To confirm that the port has been correctly exposed, go And confirm that you see this graphic login screen. Make sure it is HTTP and not https.

Log in like the new user you created. Then go to your users list and delete the default admin user.

After that, go back to the Grafana Aid on Configure Tab. Click 3 dots on the line of options and select Edit Edit. Then add this line below to your configuration file and save.

grafana_ingress_user: usernameofnewuser

How to enable remote access to the solar dashboard

At this point, we have a solar dashboard ready and we can access it in the home assistant while staying inside our home network. But we just don’t want it. We want anyone to visit the link without access to our home network.

I will enforce this section with the help of Home Assistant Cloud Flird Aid on, which takes advantage of the cloud flair tunnel. It is Gut Hub Ripozetry -Settlement is easy and stress -free.

After passing through the setup and accessing your home assistant network (Remember to turn on 2FA), go to the cloud -filled Aid on Configure Tab and edit the additional hosts.

- hostname: subdomain_you_want.your_domain.xyz
  service: 
  disableChunkedEncoding: true

Save Ad on and Restore and check the logs. You should see that you have made DNS entry for the host name you have added.

As another safety move, go to your graphina aid on configuration tab. Add these values ​​to environmental variables.

- name: GF_AUTH_ANONYMOUS_ENABLED
  value: "true"
- name: GF_AUTH_ANONYMOUS_ORG_ROLE
  value: "Viewer"
- name: GF_AUTH_DISABLE_LOGIN_FORM
  value: "true"

• GF_AUTH_ANONYMOUS_ENABLED: Whoever visits graphana without login will still be allowed.

• GF_AUTH_ANONYMOUS_ORG_ROLE: It sets a default permission for anonymous users. In this case, anonymous consumers will have the role of viewers.

• GF_AUTH_DISABLE_LOGIN_FORM: Graphana disables the login form on the login page. Make sure you are already logged in the remote host name. But if you turn off, you can always edit it on the Ad on Configure tab.

Wrap

Finally, go to the remote host name for your graph and you should see the Grafana homepage. Then go to your dashboards and click on the solar dashboard created. Share it and choose publicly. Now you can share this link (not the original copied URL from the URL and the share button on this page) and they can see your beautiful dashboard.

This method works through your home assistant machine, all the way to do everything. I hope you enjoy tinkering, will meet next time.