Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
Moderator: leecollings
-
- Posts: 80
- Joined: Monday 05 November 2018 17:41
- Target OS: Linux
- Domoticz version:
- Contact:
Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
Probably access rights
-
- Posts: 14
- Joined: Wednesday 15 December 2021 20:02
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
I don,t tink it has to do with permissions. Gif both directory and file full permision.
Looks like the plugin can not handle read only databases
error checking db: error checking for valid SQLite file: attempt to write a readonly database (1544)
Looks like the plugin can not handle read only databases
error checking db: error checking for valid SQLite file: attempt to write a readonly database (1544)
-
- Posts: 14
- Joined: Wednesday 15 December 2021 20:02
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
I find the problem of this.
If i change the pragma journal mode from Wall to Off there is no error anymore.
Now is my question how can i change this on a command line in linux ???
If i change the pragma journal mode from Wall to Off there is no error anymore.
Now is my question how can i change this on a command line in linux ???
Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
Some beautiful work you made. I have two questions:hemant5400z wrote: ↑Thursday 17 November 2022 20:56 Hi All,
......
If people are interested in the queries, let me know, happy to share them. Also if someone has a bright idea on how to do the Bruto Verbruik, in a smarter way please share, currently did a transform in Grafana with a nasty outerjoin, should be a smarter way.
Cheers,
Hemant
1. How did you manage to value labels on the bar?
2. Please share the queries you used
My setup is a bit complex. I have a home with a smart-meter and part of the home is a guesthouse with a submeter. I needed to know the "bruto verbruik" of each part of the home. I read directly the smart-meter data (with youless) plus the data from a submeter (with youless) plus the data from the solar panels (3phase with one youless+kWh per phase). The "bruto verbruik" from the submeter is straightforward, but I also needed the "bruto verbruik" of the main part of the house. The way I did this is by calculating this in Domoticz using dzevents and dummy sensors. With SQLite plugin and Grafana, I can graph "Bruto Verbruik" of the two meters, Solar Panel Production (3-phase, each phase and total) and of course "Netto Verbruik".
On top, I use several youless+kWh meter combinations to read power consumption, (airco's, heatpump, network)
Guus
-
- Posts: 80
- Joined: Monday 05 November 2018 17:41
- Target OS: Linux
- Domoticz version:
- Contact:
Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush
gvhoofst wrote: ↑Tuesday 17 January 2023 13:13Some beautiful work you made. I have two questions:hemant5400z wrote: ↑Thursday 17 November 2022 20:56 Hi All,
......
If people are interested in the queries, let me know, happy to share them. Also if someone has a bright idea on how to do the Bruto Verbruik, in a smarter way please share, currently did a transform in Grafana with a nasty outerjoin, should be a smarter way.
Cheers,
Hemant
1. How did you manage to value labels on the bar?
2. Please share the queries you used
My setup is a bit complex. I have a home with a smart-meter and part of the home is a guesthouse with a submeter. I needed to know the "bruto verbruik" of each part of the home. I read directly the smart-meter data (with youless) plus the data from a submeter (with youless) plus the data from the solar panels (3phase with one youless+kWh per phase). The "bruto verbruik" from the submeter is straightforward, but I also needed the "bruto verbruik" of the main part of the house. The way I did this is by calculating this in Domoticz using dzevents and dummy sensors. With SQLite plugin and Grafana, I can graph "Bruto Verbruik" of the two meters, Solar Panel Production (3-phase, each phase and total) and of course "Netto Verbruik".
On top, I use several youless+kWh meter combinations to read power consumption, (airco's, heatpump, network)
Guus
Hi,
The value label comes from Grafana as the display is set to always:
SELECT
(round(sum(value5),3)/1000) + (round(sum(value1),3)/1000) as Netto_Verbruik,
strftime('%Y-%m', date) year_month
from MultiMeter_calendar where devicerowid=64 and strftime('%Y',date) <= strftime('%Y',date('now'))
GROUP BY year_month
ORDER BY year_month ASC
Hemant
- Attachments
-
- Capture2.PNG (88.57 KiB) Viewed 1301 times
Who is online
Users browsing this forum: No registered users and 0 guests