effectivement il y a des soucis, j’ai comme message
Soucis sur le compte
Vérifier les logs ou votre configuration
Bonjour à tous,
message SOS pour l’installation de l’add-on, malgré ma (courageuse) lecture des 1900 messages je me résoud à envoyer ma bouteille à la mer.
Au lancement j’ai le message « database is locked » dont je n’arrive pas à trouver la cause. J’ai désinstallé et réinstallé, même chose.
Dans la log il y a aussi un message d’erreur sur le discover-MQTT, je ne sais pas si c’est lié, la connexion à mon broker fonctionne pourtant quelques lignes plus loin.
La connexion enedis fonctionne, la commande curl me renvoie le message
{« valid »:true,« information »:« »,« consent_expiration_date »:« 2028-01-17T13:50:58 »,« call_number »:1,« quota_reached »:false,« quota_limit »:50,« quota_reset_at »:« 2025-01-17T23:59:59.999999 »,« last_call »:« 2025-01-17T09:44:37.158079 »,« ban »:false}
Bref voici mon config.yaml et ma log.
cycle: 14400 # 4H
debug: true
log2file: false
wipe_influxdb: false # Work only with influxdb > 2.X
# Par défaut le backend en local dans le /data/cache.db du conteneur.
# Mais il est possible de basculer sur une base de données externe de type SQLite ou PostgreSQL
# Exemple pour Postgres :
# storage_uri: postgresql://myelectricaldata:myelectricaldata@postgres:5432/myelectricaldata
mqtt:
enable: true
hostname: 192.168.1.111
port: 1883
username: MQTTFREEBOX
password: XXXXXXX&
prefix: myelectricaldata
client_id: myelectricaldata # DOIT ETRE UNIQUE SUR LA TOTALITE DES CLIENTS CONNECTE AU SERVEUR MQTT
retain: true
qos: 0
home_assistant: # MQTT est obligaoire pour Home Assistant
enable: true
discovery: true
discovery_prefix: homeassistant
home_assistant_ws:
enable: true
ssl: false
token: eyJhXXXXXXXXQE
url: 192.168.1.62:8123
influxdb:
enable: false
hostname: a0d7b954-influxdb.local.hass.io
# hostname: 192.168.1.62
port: 8086
token: myelectricaldata:myelectricaldata
org: "myelectricaldata/autogen"
bucket: "-"
# ATTENTION, L'activation de l'importation asynchrone va réduire fortement le temps d'importation dans InfluxDB
# mais va augmenter la consommation mémoire & CPU et donc à activer uniquement sur un hardware robuste.
method: synchronous # Mode disponible : synchronous / asynchronous / batching
# batching_options permet uniquement de configurer la methode `batching`.
# Pour plus d'information : https://github.com/influxdata/influxdb-client-python#batching
batching_options:
batch_size: 1000
flush_interval: 1000
jitter_interval: 0
retry_interval: 5000
max_retry_time: 180_000
max_retries: 5
max_retry_delay: 125_000
exponential_base: 2
myelectricaldata:
"19XXXXXXX67":
enable: "true"
token: yTXXXXXXXXXXXXXXXX-8=
name: "Appart4AB"
addresses: "true"
cache: "true"
consumption: "true"
consumption_detail: "true"
consumption_price_base: "0.145907"
consumption_price_hc: "0.124364"
consumption_price_hp: "0.164915"
consumption_max_date: "2021-06-01"
consumption_detail_max_date: "2021-06-01"
offpeak_hours_0: 22H00-6H00 # LUNDI
offpeak_hours_1: 22H00-6H00 # MARDI
offpeak_hours_2: 22H00-6H00 # MERCREDI
offpeak_hours_3: 22H00-6H00 # JEUDI
offpeak_hours_4: 22H00-6H00 # VENDREDI
offpeak_hours_5: 22H00-6H00;12H00-14H00 # SAMEDI
offpeak_hours_6: 22H00-6H00;12H00-14H00 # DIMANCHE
plan: TEMPO
production: "false"
production_detail: "false"
production_price: "0.0"
production_max_date: "2021-06-01"
production_detail_max_date: "2021-06-01"
refresh_addresse: "false"
refresh_contract: "false"
tempo:
enable: true
price_blue_hc: 0.1296
price_blue_hp: 0.1609
price_red_hc: 0.1568
price_red_hp: 0.7562
price_white_hc: 0.1486
price_white_hp: 0.1894
Add-on: MyElectricalData
Use Enedis Gateway API to send data in your MQTT Broker (latest channel)
-----------------------------------------------------------
Add-on version: 0.13.2
You are running the latest version of this add-on.
System: Home Assistant OS 14.1 (amd64 / qemux86-64)
Home Assistant Core: 2025.1.2
Home Assistant Supervisor: 2024.12.3
-----------------------------------------------------------
-----------------------------------------------------------
/etc/cont-init.d/00-global_var.sh: executing
CONFIG_LOCATION='/config/myelectricaldata/config.yaml'
TZ='Europe/Paris'
mqtt_autodiscover='true'
verbose='true'
/etc/cont-init.d/01-config_yaml.sh: executing
Setting permissions for the config.yaml directory
Load environment variables from /config/myelectricaldata/config.yaml if existing
If accessing the file with filebrowser it should be mapped to /homeassistant/addons_config/enedisgateway2mqtt/config.yaml
---------------------------------------------------------
Wiki here on how to use : github.com/alexbelgium/hassio-addons/wiki/Add‐ons-feature-:-add-env-variables
cycle='14400'
.....
(je tronque - config en message séparé)
.....
/etc/cont-init.d/01-custom_script.sh: executing
Execute /homeassistant/addons_config/enedisgateway2mqtt/enedisgateway2mqtt.sh if existing
Wiki here : github.com/alexbelgium/hassio-addons/wiki/Add-ons-feature-:-customisation
/etc/cont-init.d/32-nginx_ingress.sh: executing
/etc/cont-init.d/91-mqtt_autodiscover.sh: executing
[14:13:17] INFO: mqtt_autodiscover is defined in options, attempting autodiscovery...
[14:13:17] FATAL: No internal MQTT service found. Please install Mosquitto broker
Error : /etc/cont-init.d/91-mqtt_autodiscover.sh exiting 1
/etc/cont-init.d/99-run.sh: executing
creating symlink
[14:13:17] INFO: Using database file found in /config/myelectricaldata
[14:13:17] INFO: Using config file found in /config/myelectricaldata/config.yaml
Config file is a valid yaml
[14:13:18] INFO: Starting nginx
[14:13:18] INFO: Starting the app
2025-01-17 14:13:19.065 - INFO : Display configuration :
2025-01-17 14:13:19.065 - INFO : cycle: 14400
2025-01-17 14:13:19.065 - INFO : debug: True
2025-01-17 14:13:19.065 - INFO : log2file: False
2025-01-17 14:13:19.065 - INFO : wipe_influxdb: False
2025-01-17 14:13:19.065 - INFO : mqtt:
2025-01-17 14:13:19.065 - INFO : enable: True
2025-01-17 14:13:19.065 - INFO : hostname: 192.168.1.111
2025-01-17 14:13:19.065 - INFO : port: 1883
2025-01-17 14:13:19.065 - INFO : username: MQTTFREEBOX
2025-01-17 14:13:19.065 - INFO : password: ** hidden **
2025-01-17 14:13:19.065 - INFO : prefix: myelectricaldata
2025-01-17 14:13:19.065 - INFO : client_id: myelectricaldata
2025-01-17 14:13:19.065 - INFO : retain: True
2025-01-17 14:13:19.065 - INFO : qos: 0
2025-01-17 14:13:19.065 - INFO : home_assistant:
2025-01-17 14:13:19.066 - INFO : enable: True
2025-01-17 14:13:19.066 - INFO : discovery: True
2025-01-17 14:13:19.066 - INFO : discovery_prefix: homeassistant
2025-01-17 14:13:19.066 - INFO : home_assistant_ws:
2025-01-17 14:13:19.066 - INFO : enable: True
2025-01-17 14:13:19.066 - INFO : ssl: False
2025-01-17 14:13:19.066 - INFO : token: ** hidden **
2025-01-17 14:13:19.066 - INFO : url: 192.168.1.62:8123
2025-01-17 14:13:19.066 - INFO : influxdb:
2025-01-17 14:13:19.066 - INFO : enable: False
2025-01-17 14:13:19.066 - INFO : hostname: a0d7b954-influxdb.local.hass.io
2025-01-17 14:13:19.066 - INFO : port: 8086
2025-01-17 14:13:19.066 - INFO : token: ** hidden **
2025-01-17 14:13:19.066 - INFO : org: myelectricaldata/autogen
2025-01-17 14:13:19.066 - INFO : bucket: -
2025-01-17 14:13:19.066 - INFO : method: synchronous
2025-01-17 14:13:19.066 - INFO : batching_options:
2025-01-17 14:13:19.066 - INFO : batch_size: 1000
2025-01-17 14:13:19.066 - INFO : flush_interval: 1000
2025-01-17 14:13:19.066 - INFO : jitter_interval: 0
2025-01-17 14:13:19.067 - INFO : retry_interval: 5000
2025-01-17 14:13:19.067 - INFO : max_retry_time: 180000
2025-01-17 14:13:19.067 - INFO : max_retries: 5
2025-01-17 14:13:19.067 - INFO : max_retry_delay: 125000
2025-01-17 14:13:19.067 - INFO : exponential_base: 2
2025-01-17 14:13:19.067 - INFO : myelectricaldata:
2025-01-17 14:13:19.067 - INFO : 1masqué7:
2025-01-17 14:13:19.067 - INFO : enable: true
2025-01-17 14:13:19.067 - INFO : token: ** hidden **
2025-01-17 14:13:19.067 - INFO : name: Appart4AB
2025-01-17 14:13:19.067 - INFO : addresses: true
2025-01-17 14:13:19.067 - INFO : cache: true
2025-01-17 14:13:19.067 - INFO : consumption: true
2025-01-17 14:13:19.067 - INFO : consumption_detail: true
2025-01-17 14:13:19.067 - INFO : consumption_price_base: 0.145907
2025-01-17 14:13:19.067 - INFO : consumption_price_hc: 0.124364
2025-01-17 14:13:19.067 - INFO : consumption_price_hp: 0.164915
2025-01-17 14:13:19.067 - INFO : consumption_max_date: 2021-06-01
2025-01-17 14:13:19.067 - INFO : consumption_detail_max_date: 2021-06-01
2025-01-17 14:13:19.067 - INFO : offpeak_hours_0: 22H00-6H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_1: 22H00-6H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_2: 22H00-6H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_3: 22H00-6H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_4: 22H00-6H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_5: 22H00-6H00;12H00-14H00
2025-01-17 14:13:19.067 - INFO : offpeak_hours_6: 22H00-6H00;12H00-14H00
2025-01-17 14:13:19.068 - INFO : plan: TEMPO
2025-01-17 14:13:19.068 - INFO : production: false
2025-01-17 14:13:19.068 - INFO : production_detail: false
2025-01-17 14:13:19.068 - INFO : production_price: 0.0
2025-01-17 14:13:19.068 - INFO : production_max_date: 2021-06-01
2025-01-17 14:13:19.068 - INFO : production_detail_max_date: 2021-06-01
2025-01-17 14:13:19.068 - INFO : refresh_addresse: false
2025-01-17 14:13:19.068 - INFO : refresh_contract: false
2025-01-17 14:13:19.068 - INFO : tempo:
2025-01-17 14:13:19.068 - INFO : enable: True
2025-01-17 14:13:19.068 - INFO : price_blue_hc: 0.1296
2025-01-17 14:13:19.068 - INFO : price_blue_hp: 0.1609
2025-01-17 14:13:19.068 - INFO : price_red_hc: 0.1568
2025-01-17 14:13:19.068 - INFO : price_red_hp: 0.7562
2025-01-17 14:13:19.068 - INFO : price_white_hc: 0.1486
2025-01-17 14:13:19.068 - INFO : price_white_hp: 0.1894
2025-01-17 14:13:19.068 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:19.068 - INFO : Check config.yaml :
2025-01-17 14:13:19.068 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:19.068 - INFO : CONFIG VALID
2025-01-17 14:13:19.068 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
2025-01-17 14:13:20.013 - INFO : Configure Databases
2025-01-17 14:13:20.078 - INFO : => day
2025-01-17 14:13:20.085 - INFO : => call_number
2025-01-17 14:13:20.090 - INFO : => max_call
2025-01-17 14:13:20.097 - INFO : => version
2025-01-17 14:13:20.104 - INFO : => lock
2025-01-17 14:13:20.108 - INFO : => lastUpdate
2025-01-17 14:13:20.110 - INFO : Success
2025-01-17 14:13:20.110 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.110 - INFO : Connect to MQTT broker 192.168.1.111:1883
2025-01-17 14:13:20.266 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.266 - INFO : CONNECTION SUCCESS
2025-01-17 14:13:20.267 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
/app/models/query_contract.py:40: SyntaxWarning: invalid escape sequence '\('
offpeak_hours = re.search("HC \((.*)\)", contracts["offpeak_hours"]).group(1)
2025-01-17 14:13:20.669 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.669 - INFO : RUN IN PRODUCTION MODE
2025-01-17 14:13:20.669 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.669 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.669 - INFO : CHARGEMENT DU CONFIG.YAML...
2025-01-17 14:13:20.669 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:20.669 - INFO : 19124023148267
2025-01-17 14:13:21.422 - INFO : => Success
2025-01-17 14:13:21.422 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:21.422 - INFO : NETTOYAGE DE LA BASE DE DONNÉES...
2025-01-17 14:13:21.422 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:21.427 - WARNING : - Suppression du point de livraison MON_PDL_1
2025-01-17 14:13:22.146 - WARNING : - Suppression du point de livraison MON_PDL_2_AVEC_PRODUCTION
/app/main.py:93: DeprecationWarning:
on_event is deprecated, use lifespan event handlers instead.
Read more about it in the
[FastAPI docs for Lifespan Events](https://fastapi.tiangolo.com/advanced/events/).
@APP.on_event("startup")
/app/main.py:99: DeprecationWarning:
on_event is deprecated, use lifespan event handlers instead.
Read more about it in the
[FastAPI docs for Lifespan Events](https://fastapi.tiangolo.com/advanced/events/).
@APP.on_event("startup")
/app/main.py:105: DeprecationWarning:
on_event is deprecated, use lifespan event handlers instead.
Read more about it in the
[FastAPI docs for Lifespan Events](https://fastapi.tiangolo.com/advanced/events/).
@APP.on_event("startup")
2025-01-17 14:13:22.931 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ __ __ _____ _ _ _ _ ____ _ ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ | \/ | _ _ | ____|| | ___ ___ | |_ _ __ (_) ___ __ _ | || _ \ __ _ | |_ __ _ ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ | |\/| || | | || _| | | / _ \ / __|| __|| '__|| | / __| / _` || || | | | / _` || __| / _` | ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ | | | || |_| || |___ | || __/| (__ | |_ | | | || (__ | (_| || || |_| || (_| || |_ | (_| | ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ |_| |_| \__, ||_____||_| \___| \___| \__||_| |_| \___| \__,_||_||____/ \__,_| \__| \__,_| ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ |___/ ║▌║▌║█│▌
2025-01-17 14:13:22.931 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.931 - INFO : ▌│█║▌║▌║ VERSION : 0.13.2 ║▌║▌║█│▌
2025-01-17 14:13:22.932 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.962 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.962 - INFO : RUN IN PRODUCTION MODE
2025-01-17 14:13:22.962 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.962 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.962 - INFO : CHARGEMENT DU CONFIG.YAML...
2025-01-17 14:13:22.962 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.962 - INFO : 19124023148267
2025-01-17 14:13:22.969 - INFO : => Success
2025-01-17 14:13:22.969 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.969 - INFO : NETTOYAGE DE LA BASE DE DONNÉES...
2025-01-17 14:13:22.969 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:22.999 - INFO : Started server process [938]
2025-01-17 14:13:22.999 - INFO : Waiting for application startup.
2025-01-17 14:13:23.009 - INFO : Application startup complete.
2025-01-17 14:13:23.014 - INFO : Uvicorn running on http://0.0.0.0:5000 (Press CTRL+C to quit)
2025-01-17 14:13:23.018 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:23.018 - INFO : DÉMARRAGE DU JOB D'IMPORTATION DANS 10S
2025-01-17 14:13:23.020 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:23.020 - INFO : 10s
2025-01-17 14:13:23.020 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:23.020 - INFO : RÉCUPÉRATION DU STATUT DE LA PASSERELLE :
2025-01-17 14:13:23.020 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:23.125 - INFO : status: True
2025-01-17 14:13:23.126 - INFO : information: None
2025-01-17 14:13:23.126 - INFO : nb_client: 3377
2025-01-17 14:13:23.126 - INFO : waiting_estimation: 0.0s
2025-01-17 14:13:24.022 - INFO : 9s
2025-01-17 14:13:24.075 - INFO : 127.0.0.1:40770 - "GET / HTTP/1.1" 200
2025-01-17 14:13:25.024 - INFO : 8s
2025-01-17 14:13:26.024 - INFO : 7s
2025-01-17 14:13:27.024 - INFO : 6s
2025-01-17 14:13:28.025 - INFO : 5s
2025-01-17 14:13:29.026 - INFO : 4s
2025-01-17 14:13:29.155 - INFO : 127.0.0.1:58326 - "GET / HTTP/1.1" 200
2025-01-17 14:13:30.027 - INFO : 3s
2025-01-17 14:13:31.027 - INFO : 2s
2025-01-17 14:13:32.027 - INFO : 1s
2025-01-17 14:13:33.028 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:33.028 - INFO : RÉCUPÉRATION DU STATUT DE LA PASSERELLE :
2025-01-17 14:13:33.028 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:33.159 - INFO : status: True
2025-01-17 14:13:33.159 - INFO : information: None
2025-01-17 14:13:33.159 - INFO : nb_client: 3377
2025-01-17 14:13:33.159 - INFO : waiting_estimation: 0.0s
2025-01-17 14:13:33.159 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:33.159 - INFO : RÉCUPÉRATION DES DONNÉES TEMPO :
2025-01-17 14:13:33.159 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-17 14:13:39.217 - INFO : 127.0.0.1:58336 - "GET / HTTP/1.1" 500
2025-01-17 14:13:39.217 - ERROR : Exception in ASGI application
Traceback (most recent call last):
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.12/site-packages/uvicorn/protocols/http/h11_impl.py", line 408, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 84, in __call__
return await self.app(scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/applications.py", line 123, in __call__
await self.middleware_stack(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/middleware/errors.py", line 186, in __call__
raise exc
File "/usr/local/lib/python3.12/site-packages/starlette/middleware/errors.py", line 164, in __call__
await self.app(scope, receive, _send)
File "/usr/local/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app
raise exc
File "/usr/local/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
await app(scope, receive, sender)
File "/usr/local/lib/python3.12/site-packages/starlette/routing.py", line 758, in __call__
await self.middleware_stack(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/routing.py", line 778, in app
await route.handle(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/routing.py", line 299, in handle
await self.app(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/routing.py", line 79, in app
await wrap_app_handling_exceptions(app, request)(scope, receive, send)
File "/usr/local/lib/python3.12/site-packages/starlette/_exception_handler.py", line 64, in wrapped_app
raise exc
File "/usr/local/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
await app(scope, receive, sender)
File "/usr/local/lib/python3.12/site-packages/starlette/routing.py", line 74, in app
response = await func(request)
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/fastapi/routing.py", line 299, in app
raise e
File "/usr/local/lib/python3.12/site-packages/fastapi/routing.py", line 294, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/fastapi/routing.py", line 193, in run_endpoint_function
return await run_in_threadpool(dependant.call, **values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/starlette/concurrency.py", line 42, in run_in_threadpool
return await anyio.to_thread.run_sync(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/anyio/to_thread.py", line 56, in run_sync
return await get_async_backend().run_sync_in_worker_thread(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 2177, in run_sync_in_worker_thread
return await future
^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 859, in run
result = context.run(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/routers/html.py", line 31, in main
return Index(CONFIG, DB).display()
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/templates/index.py", line 41, in display
select_usage_points=self.usage_point_select.html(),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/templates/models/usage_point_select.py", line 20, in html
for config in self.db.get_usage_point_all():
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/models/database.py", line 280, in get_usage_point_all
data = self.session.scalars(query).all()
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in scalars
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1778, in scalars
return self.execute(
^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
result = conn._execute_20(statement, params or {}, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: SELECT usage_points.usage_point_id, usage_points.name, usage_points.cache, usage_points.consumption, usage_points.consumption_detail, usage_points.production, usage_points.production_detail, usage_points.consumption_price_base, usage_points.consumption_price_hc, usage_points.consumption_price_hp, usage_points.production_price, usage_points.offpeak_hours_0, usage_points.offpeak_hours_1, usage_points.offpeak_hours_2, usage_points.offpeak_hours_3, usage_points.offpeak_hours_4, usage_points.offpeak_hours_5, usage_points.offpeak_hours_6, usage_points."plan", usage_points.refresh_addresse, usage_points.refresh_contract, usage_points.token, usage_points.progress, usage_points.progress_status, usage_points.enable, usage_points.consentement_expiration, usage_points.call_number, usage_points.quota_reached, usage_points.quota_limit, usage_points.quota_reset_at, usage_points.last_call, usage_points.ban, usage_points.consumption_max_date, usage_points.consumption_detail_max_date, usage_points.production_max_date, usage_points.production_detail_max_date, usage_points.consumption_max_power, usage_points.last_error
Salut,
tu devrais faire du nettoyage dans ton config.yaml. si tu n’utilise pas influxdb, ces lignes suffise:
influxdb:
enable: false
exemple de ma config:
cycle: 14400
debug: false
log2file: false
wipe_influxdb: false
home_assistant:
enable: true
discovery: true
discovery_prefix: homeassistant
home_assistant_ws:
enable: false
influxdb:
enable: false
mqtt:
enable: true
hostname: core-mosquitto
port: 1883
username: myelectricaldata
password: xxxxxxxxxxxxxxx
prefix: myelectricaldata
client_id: myelectricaldata
retain: true
qos: 0
myelectricaldata:
"241xxxxxxxxxxxxx":
enable: 'true'
token: guHxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
name: 'Maison'
addresses: 'true'
cache: 'true'
consumption: 'true'
consumption_detail: 'true'
consumption_price_base: '0.2516'
consumption_price_hc: '0.1456'
consumption_price_hp: '0.1876'
consumption_max_date: '2025-01-05'
consumption_detail_max_date: '2025-01-05'
offpeak_hours_0: '23H02-7H02'
offpeak_hours_1: '23H02-7H02'
offpeak_hours_2: '23H02-7H02'
offpeak_hours_3: '23H02-7H02'
offpeak_hours_4: '23H02-7H02'
offpeak_hours_5: '23H02-7H02'
offpeak_hours_6: '23H02-7H02'
plan: HC/HP
tempo:
enable: false
Effectivement, ça ne pouvait pas faire de mal, mais malheureusement c’est sans effet 
Ta base de donnée ne serait pas corrompue ?
Tu n’as pas un message d’erreur dans les journaux de HA ?
non pas vu d’erreur dans les logs, pas de fichier de type database_corrupted dans mon répertoire config, et je n’ai ni problème d’affichage de graphes d’historique dans HA ni de problème à faire des query par l’add-on SQLLite.
Merci d’essayer de trouver des solutions en tout cas, j’y ai passé 10h avant d’appeler à l’aide.
Bon, les joies de l’informatique : sans toucher à rien (j’ai laissé tombé depuis lundi), et bien ça fonctionne… Seule action effectuée qui a pu avoir un impact : j’ai fait un reboot complet (pas un redémarrage) pour un autre sujet, et je viens par hasard de regarder la log de MED : tout va bien.
Hello,
L’un.e d’entre vous a exploré la voie HelloWatt ? Ils font de sacrées belles analyses des données linky avec des déductions des conso par appareil (je suppose en fonction de la puissance et de l’heure) et des comparaisons au niveau national ou local en fonction de la typologie de son logement. Perso, ça m’a convaincu !
Je les ai contacté, a priori on peut récupérer leurs données via mqtt.
Bonjour à tous,
Depuis un ptit moment j’ai l’impression que c’est la galère pour avoir la remontée d’infos quotidienne de la consommation de la veille. Je l’ai soit tard dans la journée, soit le lendemain. C’est pareil pour vous ?
Merci
Bonjour,
Oui je confirme qu’en automatique les informations remontent avec beaucoup de retard. Par contre, en cliquant sur le bouton d’update de la ligne, les données sont mises à jour.
Tu fais ça comment ? Moi je redémarre l’intégration pour essayer de mettre à jour la conso de la veille.
Salut,
vous avez essayé, c’est méthode ?
tu ouvres la page MED dans la barre latérale, tu charges ton point de livraison et tout en bas, tu as un menu disponible.
supprimer le cache de la passerelle et le cache local.
La poubelle simple, c’est le cache local et la poubelle avec la croix, c’est le cache de la passerelle.
Puis redémarrer le module complémentaire MED.
Non je n’ai pas osé faire ça par peur de tout perdre 
Tu ferais les 2 suppressions toi + restart du service ?
je les fais plusieurs fois et je n’ai rien perdu.
oui supprime les deux caches et redémarre juste le module complémentaire de Myelectricaldata.
Ok, je vais le lancer.
Au redémarrage du module, l’ensemble des valeurs seront chargés ou il faudra attendre ?
Oui, les valeurs sont chargées directement, quand le module a fini de démarrer.
Regarde le journal du module, tu vois l’évolution de la récupération des données.
quand tu vois ce message, ca fini de charger.
2025-01-22 15:01:10.947 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2025-01-22 15:01:10.947 - INFO : ▌│█║▌║▌║ ___ _ _____ _ _ _ _ _ _ ║▌║▌║█│▌
2025-01-22 15:01:10.947 - INFO : ▌│█║▌║▌║ |_ _| _ __ ___ _ __ ___ _ __ | |_ | ___|(_) _ __ (_) ___ | |__ | || || | ║▌║▌║█│▌
2025-01-22 15:01:10.948 - INFO : ▌│█║▌║▌║ | | | '_ ` _ \ | '_ \ / _ \ | '__|| __| | |_ | || '_ \ | |/ __|| '_ \ | || || | ║▌║▌║█│▌
2025-01-22 15:01:10.948 - INFO : ▌│█║▌║▌║ | | | | | | | || |_) || (_) || | | |_ | _| | || | | || |\__ \| | | ||_||_||_| ║▌║▌║█│▌
2025-01-22 15:01:10.948 - INFO : ▌│█║▌║▌║ |___||_| |_| |_|| .__/ \___/ |_| \__| |_| |_||_| |_||_||___/|_| |_|(_)(_)(_) ║▌║▌║█│▌
2025-01-22 15:01:10.948 - INFO : ▌│█║▌║▌║ |_| ║▌║▌║█│▌
2025-01-22 15:01:10.948 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Redemarrage en cours, je verrais donc les effets demain 
Bonsoir,
est-il possible de rajouter des heures supplémentaires à heures creuses/heures pleines?
Chez Total Energie, il existe les heures super creuses:
Dans l’affirmative, quelqu’un pourrait-il m’aider afin de mettre en place celles-ci dans le fichier configuration ?
En vous remerciant par avance,
Cordialement,