Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush

Client tools or tools that can connect with Domoticz. Tools for Windows, iOS, Android, Linux etc.

Moderator: leecollings

hemant5400z
Posts: 80
Joined: Monday 05 November 2018 17:41
Target OS: Linux
Domoticz version:
Contact:

Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush

Post by hemant5400z »

Probably access rights
NvBgm55
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

Post by NvBgm55 »

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)
NvBgm55
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

Post by NvBgm55 »

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 ???
gvhoofst
Posts: 1
Joined: Monday 05 July 2021 2:00
Target OS: Linux
Domoticz version:
Contact:

Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush

Post by gvhoofst »

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
Some beautiful work you made. I have two questions:
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
hemant5400z
Posts: 80
Joined: Monday 05 November 2018 17:41
Target OS: Linux
Domoticz version:
Contact:

Re: Grafana SQLite plugin: Graphs Dashboard without InfluxDB datapush

Post by hemant5400z »

gvhoofst wrote: Tuesday 17 January 2023 13:13
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
Some beautiful work you made. I have two questions:
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
Capture2.PNG (88.57 KiB) Viewed 1301 times
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests