GRDF: Gazpar_2_MQTT

Do It Yourself Vos Projets
1

Comme écrit avant, GRDF à de nouveau changé vers une authentification sans captcha…mais encore différent de la méthode utilisé par gazpar2mqtt. J’ai pris un peu (alors bien plus) de temps pour creer mon propre solution qui est largement basé sur le taf de @yukulehe.

C’est pas encore ‹ top › mais ça a l’air de fontionner (testé par 3 personnes).

vingerha/gazpar_2_mqtt: Based on abandoned gazpar2mqtt (yukulehe) with fix for login (github.com)

La documentation reste pour le moment en Anglais (aussi beaucoup copié de gazpar2mqtt). Si qqu veut le traduire…merci :slight_smile:

Erreur/idées etc. stp dans mon github report

2 « J'aime »
2

Super idée
Merci
Phil

3

intéressant, je vais surveiller le github

4

J’ai investi tant des heures pour apprendre comment creer in ‹ addon › ::skull: :rage: :ghost: :alien: :confounded: :scream: :rofl:

2. Installation · vingerha/gazpar_2_mqtt Wiki (github.com)

1 « J'aime »
5

Bonjour, et merci pour le temps passé :wink:

Je viens d’essayer, apparemment il y a des données qui remontent mais en erreur.

2024-05-04 10:25:59,353 INFO Retrieve list of PCEs...
2024-05-04 10:25:59,585 INFO 1 PCE found !
2024-05-04 10:25:59,595 INFO ---------------------------------
2024-05-04 10:25:59,595 INFO Get measures of PCE xxxxxxx alias xxxxxxxxxx
2024-05-04 10:25:59,596 INFO Range period : from 2021-05-04 (3 years ago) to 2024-05-04 (today) ...
2024-05-04 10:25:59,597 INFO ---------------
2024-05-04 10:25:59,597 INFO Retrieve informative measures...
2024-05-04 10:26:00,744 INFO Informative measures found !
2024-05-04 10:26:00,744 INFO Analysis of informative measures provided by GRDF...
2024-05-04 10:26:00,744 INFO 1088 informative measures provided by Grdf
2024-05-04 10:26:00,745 INFO 648 informative measures are ok
2024-05-04 10:26:00,745 INFO Accuracy is 60 percent
2024-05-04 10:26:00,745 INFO Last valid informative measure provided by GRDF : 
2024-05-04 10:26:00,745 INFO Date = 2024-04-24
2024-05-04 10:26:00,745 INFO Start index = 6677, End index = 6682
2024-05-04 10:26:00,745 INFO Volume = 5 m3, Energy = 47 kWh, Factor = 9.47136
2024-05-04 10:26:00,745 WARNING Inconsistencies detected on the measure : 
2024-05-04 10:26:00,745 WARNING Volume provided by Grdf (None m3) has been replaced by the volume between start index and end index (5 m3)
2024-05-04 10:26:00,746 INFO ---------------
2024-05-04 10:26:00,746 INFO Retrieve published measures...
2024-05-04 10:26:01,009 INFO Published measures found !
2024-05-04 10:26:01,009 INFO Analysis of published measures provided by GRDF...
2024-05-04 10:26:01,009 INFO 69 published measures provided by Grdf
2024-05-04 10:26:01,010 INFO 0 published measures are ok
2024-05-04 10:26:01,010 INFO Accuracy is 0 percent
2024-05-04 10:26:01,011 WARNING Unable to find the last published measure.
2024-05-04 10:26:01,011 INFO ---------------
2024-05-04 10:26:01,011 INFO Update of database with retrieved measures...
2024-05-04 10:26:01,038 INFO Database updated !
2024-05-04 10:26:01,038 INFO ---------------
2024-05-04 10:26:01,038 INFO Retrieve PCE's thresholds from GRDF...
2024-05-04 10:26:01,376 INFO 0 thresholds found !
2024-05-04 10:26:01,382 INFO -----------------------------------------------------------
2024-05-04 10:26:01,383 INFO #                    Load prices                           #
2024-05-04 10:26:01,383 INFO -----------------------------------------------------------
2024-05-04 10:26:01,383 INFO Loading prices from file prices.csv of directory /data
2024-05-04 10:26:01,383 WARNING Unable to find price file prices.csv in directory /data
2024-05-04 10:26:01,383 INFO -----------------------------------------------------------
2024-05-04 10:26:01,383 INFO #           Home assistant publication mode               #
2024-05-04 10:26:01,383 INFO -----------------------------------------------------------
2024-05-04 10:26:01,384 INFO Publishing values of PCE xxxxxx alias xxxxxxxxx...
2024-05-04 10:26:01,384 INFO ---------------------------------
2024-05-04 10:26:01,385 WARNING Unable to publish last published measure infos.
2024-05-04 10:26:01,386 INFO Publishing devices...
2024-05-04 10:26:01,386 INFO You can retrieve published values subscribing topic homeassistant/+/gazpar_01392908705971/#
2024-05-04 10:26:16,828 INFO Devices published !
2024-05-04 10:26:16,828 INFO -----------------------------------------------------------
2024-05-04 10:26:16,829 INFO #               Disconnexion from MQTT                    #
2024-05-04 10:26:16,829 INFO -----------------------------------------------------------
2024-05-04 10:26:17,631 INFO Mqtt broker disconnected
2024-05-04 10:26:17,745 INFO -----------------------------------------------------------
2024-05-04 10:26:17,746 INFO #          Disconnexion from SQLite database              #
2024-05-04 10:26:17,746 INFO -----------------------------------------------------------
2024-05-04 10:26:17,747 INFO SQLite database disconnected
2024-05-04 10:26:17,747 INFO -----------------------------------------------------------
2024-05-04 10:26:17,747 INFO #                Next run                                 #
2024-05-04 10:26:17,747 INFO -----------------------------------------------------------
2024-05-04 10:26:17,748 INFO gazpar2mqtt next run scheduled at 06:30
2024-05-04 10:26:17,748 INFO -----------------------------------------------------------
2024-05-04 10:26:17,748 INFO #                  End of program                         #
2024-05-04 10:26:17,748 INFO -----------------------------------------------------------
6

Erreurs sont pas des erreurs et attendu (hérité de l’ancien gazpar2mqtt)…je ne les comprends pas non plus…si t’as enrégistré tout pour tn serveur MQTT tu dois voir les données dans mqtt et (si param ) dans HA

EDIT: je vais revoir les messages ‹ erreurs › prochainement

7

Ok, merci, donc je n’en tiens pas compte :wink:

8

Pour le moment, non…j’ai pas découvert des soucis pour le moment. Si tu detecte une anomalie, stp le rapporter ici
Issues · vingerha/gazpar_2_mqtt (github.com)

9

Bonjour, j’ai installé l’ADDON mais je ne réussi pas a me connecter a mon BROKER MQTT.

je ne sais pas si ma configuration MQTT est correcte

Voici mon fichier de config

GRDF_USERNAME=fxxxxxx@xxxx.fr
GRDF_PASSWORD=yyyyyyyyyyyyyyy
MQTT_HOST=mqtt://192.168.1.134:1883
MQTT_USERNAME=xxxxxxx
MQTT_PASSWORD=yyyyyyy
DEBUG_MODE=True

Voici les logs

2024-05-05 15:03:50,657 INFO -----------------------------------------------------------
2024-05-05 15:03:50,657 INFO #               Welcome to gazpar2mqtt                    #
2024-05-05 15:03:50,657 INFO -----------------------------------------------------------
2024-05-05 15:03:50,657 INFO Program version : 0.4.0
2024-05-05 15:03:50,657 INFO Database version : 0.2.0
2024-05-05 15:03:50,657 INFO Influxdb version : 0.1.0
2024-05-05 15:03:50,657 INFO Please note that the the tool is under development, various functions may disappear or be modified.
2024-05-05 15:03:50,657 DEBUG If you can read this line, you are in DEBUG mode.
2024-05-05 15:03:50,657 INFO -----------------------------------------------------------
2024-05-05 15:03:50,657 INFO #                Program parameters                       #
2024-05-05 15:03:50,657 INFO -----------------------------------------------------------
2024-05-05 15:03:50,657 INFO GRDF config : username = ******@****.**, password = ******
2024-05-05 15:03:50,657 INFO GRDF config : username = xxxxxxxxxxxxxxxxx, password = yyyyyyyyyyyyyy
2024-05-05 15:03:50,657 INFO MQTT broker config : host = mqtt://192.168.1.134:1883, port = 1883, clientId = gazpar2mqtt, qos = 1, topic = gazpar, retain = True, ssl = False
2024-05-05 15:03:50,658 INFO Browser Logs folder: ./, download_folder: ./, chomedriver: /usr/bin/chromedriver, screenshots: False
2024-05-05 15:03:50,658 INFO Standlone mode : Enable = False
2024-05-05 15:03:50,658 INFO Home Assistant discovery : Enable = False, Topic prefix = homeassistant, Device name = gazpar
2024-05-05 15:03:50,658 INFO Threshold options : Warning percentage = 80
2024-05-05 15:03:50,659 INFO Database options : Force reinitialization = False, Path = /data
2024-05-05 15:03:50,659 INFO Debug mode : Enable = True
2024-05-05 15:03:50,659 INFO Check parameters...
2024-05-05 15:03:50,659 WARNING Both Standalone mode and Home assistant discovery are disable. No value will be published to MQTT ! Please check your parameters.
2024-05-05 15:03:50,659 INFO Parameters are ok !
2024-05-05 15:03:50,659 INFO -----------------------------------------------------------
2024-05-05 15:03:50,659 INFO #        Connexion to SQLite database                     #
2024-05-05 15:03:50,659 INFO -----------------------------------------------------------
2024-05-05 15:03:50,659 INFO Connexion to SQLite database...
2024-05-05 15:03:50,659 DEBUG Connexion to database
2024-05-05 15:03:50,660 INFO SQLite database connected !
2024-05-05 15:03:50,660 INFO Last execution date 2024-05-05 10:38:29.680070, program was in version 0.4.0.
2024-05-05 15:03:50,660 INFO Checking database version...
2024-05-05 15:03:50,660 INFO Your database is already up to date : version 0.2.0.
2024-05-05 15:03:50,660 INFO Retrieve database statistics...
2024-05-05 15:03:50,661 INFO 1069 informatives measures stored
2024-05-05 15:03:50,661 INFO 1 PCE(s)
2024-05-05 15:03:50,661 INFO First measure : 2021-05-04
2024-05-05 15:03:50,661 INFO Last measure : 2024-04-24
2024-05-05 15:03:50,661 INFO -----------------------------------------------------------
2024-05-05 15:03:50,661 INFO #              Connexion to Mqtt broker                   #
2024-05-05 15:03:50,661 INFO -----------------------------------------------------------
2024-05-05 15:03:50,661 INFO Connect to Mqtt broker...
2024-05-05 15:03:50,662 DEBUG Mqtt connect : activation of callbacks
2024-05-05 15:03:50,662 DEBUG Mqtt connect : connection to broker mqtt://192.168.1.134:1883:1883...
2024-05-05 15:03:50,662 ERROR Unable to connect to Mqtt broker. Please check that broker is running, or check broker configuration.
2024-05-05 15:03:50,663 INFO -----------------------------------------------------------
2024-05-05 15:03:50,663 INFO #                    Load prices                           #
2024-05-05 15:03:50,663 INFO -----------------------------------------------------------
2024-05-05 15:03:50,663 INFO Loading prices from file prices.csv of directory /data
2024-05-05 15:03:50,663 DEBUG Retrieve list of prices...
2024-05-05 15:03:50,663 WARNING Unable to find price file prices.csv in directory /data
2024-05-05 15:03:50,663 INFO -----------------------------------------------------------
2024-05-05 15:03:50,663 INFO #          Disconnexion from SQLite database              #
2024-05-05 15:03:50,663 INFO -----------------------------------------------------------
2024-05-05 15:03:50,663 DEBUG Disconnexion of the database
2024-05-05 15:03:50,663 INFO SQLite database disconnected
2024-05-05 15:03:50,663 INFO -----------------------------------------------------------
2024-05-05 15:03:50,663 INFO #                Next run                                 #
2024-05-05 15:03:50,664 INFO -----------------------------------------------------------
2024-05-05 15:03:50,664 INFO No schedule defined.
2024-05-05 15:03:50,664 INFO -----------------------------------------------------------
2024-05-05 15:03:50,664 INFO #                  End of program                         #
2024-05-05 15:03:50,664 INFO -----------------------------------------------------------
2024-05-05 15:03:50,664 INFO End of gazpar2mqtt. See u...
10

Pourquoi t’as fait ça? Ni l’exemple ni la docu disent d’utiliser mqtt:// (soit le nom soit l’adresse IP) … si pas clair m’éguiller vers la confusion.

11

Mon broker mqtt n’est pas intégré a home assistant, il est dans une autre vm

12

Donc…utiliser adresse IP…!? SANS mqtt://

EDIT: j’ai pas testé ça mais ça doit fonctionner… :crossed_fingers:

13

cela n’a pas l’air de fonctionner.

j’ai bien des consommation relevé dans les logs mai pas moyen de se connecter au broker.

14

cela fonctionne finalement après plusieurs essais.

Merci pour cet Addon

15

Bonjour, de mon côté j’ai:

 Retrieve list of PCEs...
2024-05-06 18:12:59,474 INFO 1 PCE found !
2024-05-06 18:12:59,477 INFO ---------------------------------
2024-05-06 18:12:59,477 INFO Get measures of PCE ************** alias Maison
2024-05-06 18:12:59,477 INFO Range period : from 2021-05-06 (3 years ago) to 2024-05-06 (today) ...
2024-05-06 18:12:59,478 INFO ---------------
2024-05-06 18:12:59,478 INFO Retrieve informative measures...
2024-05-06 18:13:00,071 INFO Informative measures found !
2024-05-06 18:13:00,071 INFO Analysis of informative measures provided by GRDF...
2024-05-06 18:13:00,071 INFO 919 informative measures provided by Grdf
2024-05-06 18:13:00,072 INFO 647 informative measures are ok
2024-05-06 18:13:00,072 INFO Accuracy is 70 percent
2024-05-06 18:13:00,072 INFO Last valid informative measure provided by GRDF : 
2024-05-06 18:13:00,072 INFO Date = 2024-04-24
2024-05-06 18:13:00,072 INFO Start index = 4979, End index = 4983
2024-05-06 18:13:00,072 INFO Volume = 4 m3, Energy = 41 kWh, Factor = 11.06118
2024-05-06 18:13:00,072 INFO ---------------
2024-05-06 18:13:00,072 INFO Retrieve published measures...
2024-05-06 18:13:00,319 INFO Published measures found !
2024-05-06 18:13:00,319 INFO Analysis of published measures provided by GRDF...
2024-05-06 18:13:00,319 INFO 58 published measures provided by Grdf
2024-05-06 18:13:00,319 INFO 0 published measures are ok
2024-05-06 18:13:00,319 INFO Accuracy is 0 percent
2024-05-06 18:13:00,320 WARNING Unable to find the last published measure.
2024-05-06 18:13:00,320 INFO ---------------
2024-05-06 18:13:00,320 INFO Update of database with retrieved measures...
2024-05-06 18:13:00,332 INFO Database updated !
2024-05-06 18:13:00,332 INFO ---------------
2024-05-06 18:13:00,332 INFO Retrieve PCE's thresholds from GRDF...
2024-05-06 18:13:00,596 INFO 0 thresholds found !
2024-05-06 18:13:00,600 INFO -----------------------------------------------------------
2024-05-06 18:13:00,601 INFO #                    Load prices                           #
2024-05-06 18:13:00,601 INFO -----------------------------------------------------------
2024-05-06 18:13:00,601 INFO Loading prices from file prices.csv of directory /data
2024-05-06 18:13:00,601 WARNING Unable to find price file prices.csv in directory /data
2024-05-06 18:13:00,601 INFO -----------------------------------------------------------
2024-05-06 18:13:00,601 INFO #           Stand alone publication mode                  #
2024-05-06 18:13:00,601 INFO -----------------------------------------------------------
2024-05-06 18:13:00,601 INFO Publishing values of PCE*************** alias Maison...
2024-05-06 18:13:00,601 INFO ---------------------------------
2024-05-06 18:13:00,601 INFO You can retrieve published values subscribing topic gazpar/05540376180642/#
2024-05-06 18:13:00,602 INFO Publishing to Mqtt...
2024-05-06 18:13:01,607 WARNING Unable to publish last measure infos.
2024-05-06 18:13:06,622 ERROR Standalone mode : unable to publish value to mqtt broker
2024-05-06 18:13:06,622 INFO -----------------------------------------------------------
2024-05-06 18:13:06,622 INFO #               Disconnexion from MQTT                    #

etc… et ca tourne en boucle. Dans Home assistant, si j’écoute MQTT, j’ai les infos qui tournent en boucle mais aucune entité de créée.
De l’aide svp?

16

Comprends pas car tu ne publie pas tout les logs. Je ne peux pas deviner ce que t’as fait… c’est quoi dans ton config.yaml/param.py ? Tu utilise le addon, docker-compose ou container…
???

EDIT: nvm…t’as essaié ‹ standalone › …jamais testé par moi… je vais voir. Entretemps tu pourrait utiliser HA discovery …ou attendre :slight_smile:

17

Il me semble avoir tout mis dans les log en disant que ca tourne en boucle. J’ai enlevé ce qui concerne mon compte.
Pour la config, j’ai tout dans des docker: mqtt, HA et le yaml:

version: '3.5'
services:
  gazpar2mqtt:
    container_name: gazpar_2_mqtt
    image: vingerha/gazpar_2_mqtt:latest
    tty: true
    restart: unless-stopped
    environment:
      DEBUG: 'True'
      # mandatory:
      GRDF_USERNAME: *********
      GRDF_PASSWORD: ********
      MQTT_HOST: 192.168.1.**
      TZ: Europe/Paris
      STANDALONE_MODE: 'True'
    volumes:     
      - ./:/data
      - ./app:/app
18

Si dessus :slight_smile:

19

On fait comment HA discovery?

20

Docker compose parameters fr FR · vingerha/gazpar_2_mqtt Wiki (github.com)