MyElectricalData problèmes de mise en route - données

Entraide Home Assistant
1

Bonjour à tous,

Voila 2 mois que je tente de faire fonctionner " MyElectricalData" .
Et malgré la mise à jour, je suis bloquée.
Je ne suis pas experte et je progresse toujours à taton, mais le je suis embêtée, et je me permet de poster pour tenter de comprendre.

Donc au démarrage du module j’obtiens ceci:

Starting...
/etc/cont-init.d/00-banner.sh: executing
-----------------------------------------------------------
 Add-on: MyElectricalData
 Use Enedis Gateway API to send data in your MQTT Broker (latest channel)
-----------------------------------------------------------
 Add-on version: 0.8.11-beta1
 You are running the latest version of this add-on.
 System: Home Assistant OS 9.4  (aarch64 / raspberrypi4-64)
 Home Assistant Core: 2022.12.8
 Home Assistant Supervisor: 2022.11.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums
 https://github.com/alexbelgium/hassio-addons
-----------------------------------------------------------
/etc/cont-init.d/00-global_var.sh: executing
CONFIG_LOCATION='/config/enedisgateway2mqtt/enedisgateway2mqtt.conf'
TZ='Europe/Paris'
mqtt_autodiscover='true'
verbose='true'
/etc/cont-init.d/01-custom_script.sh: executing
[20:02:31] INFO: Execute /config/enedisgateway2mqtt.sh if existing
[20:02:32] INFO: ... no script found
/etc/cont-init.d/91-mqtt_autodiscover.sh: executing
[20:02:33] INFO: mqtt_autodiscover is defined in options, attempting autodiscovery...
[20:02:34] INFO: ... MQTT service found, fetching server detail (you can enter those manually in your config file) ...
/etc/cont-init.d/91-mqtt_autodiscover.sh: exiting 2
/etc/cont-init.d/99-run.sh: executing
creating symlink
[20:02:38] INFO: Using database file found in /config/enedisgateway2mqtt
[20:02:38] FATAL: Config file not found. The addon will create a new one, then stop. Please customize the file in /config/enedisgateway2mqtt/enedisgateway2mqtt.conf before restarting.
 
[20:02:38] INFO: Starting the app

au bout de 15s/30s en ré actualisant j’obtiens ceci:

File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1472, in _execute_ddl
    ret = self._execute_context(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table config already exists
[SQL: 
CREATE TABLE config (
	"key" TEXT NOT NULL, 
	value TEXT NOT NULL, 
	PRIMARY KEY ("key")
)
]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
2022-12-23 20:06:45.975 -     INFO :  Configure Databases
2022-12-23 20:06:46.206 -     INFO :   => day
2022-12-23 20:06:46.224 -     INFO :   => call_number
2022-12-23 20:06:46.234 -     INFO :   => max_call
2022-12-23 20:06:46.246 -     INFO :   => version
2022-12-23 20:06:46.259 -     INFO :   => lock
2022-12-23 20:06:46.270 -     INFO :   => lastUpdate
2022-12-23 20:06:46.271 -     INFO :   Success
2022-12-23 20:06:48.956 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:48.957 -     INFO :  RUN IN PRODUCTION MODE
2022-12-23 20:06:48.957 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:49.023 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:49.024 -     INFO : ▌│█║▌║▌║  __  __         _____  _              _          _               _  ____          _           ║▌║▌║█│▌
2022-12-23 20:06:49.025 -     INFO : ▌│█║▌║▌║ |  \/  | _   _ | ____|| |  ___   ___ | |_  _ __ (_)  ___   __ _ | ||  _ \   __ _ | |_   __ _  ║▌║▌║█│▌
2022-12-23 20:06:49.025 -     INFO : ▌│█║▌║▌║ | |\/| || | | ||  _|  | | / _ \ / __|| __|| '__|| | / __| / _` || || | | | / _` || __| / _` | ║▌║▌║█│▌
2022-12-23 20:06:49.030 -     INFO : ▌│█║▌║▌║ | |  | || |_| || |___ | ||  __/| (__ | |_ | |   | || (__ | (_| || || |_| || (_| || |_ | (_| | ║▌║▌║█│▌
2022-12-23 20:06:49.030 -     INFO : ▌│█║▌║▌║ |_|  |_| \__, ||_____||_| \___| \___| \__||_|   |_| \___| \__,_||_||____/  \__,_| \__| \__,_| ║▌║▌║█│▌
2022-12-23 20:06:49.047 -     INFO : ▌│█║▌║▌║          |___/                                                                                ║▌║▌║█│▌
2022-12-23 20:06:49.048 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:49.049 -     INFO : ▌│█║▌║▌║                                       VERSION : 0.8.10                                        ║▌║▌║█│▌
2022-12-23 20:06:49.049 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:49.050 -     INFO :  Display configuration :
2022-12-23 20:06:49.050 -     INFO :    cycle: 14400
2022-12-23 20:06:49.050 -     INFO :    debug: False
2022-12-23 20:06:49.051 -     INFO :    home_assistant:
2022-12-23 20:06:49.051 -     INFO :      card_myenedis: True
2022-12-23 20:06:49.052 -     INFO :      discovery_prefix: homeassistant
2022-12-23 20:06:49.052 -     INFO :      enable: False
2022-12-23 20:06:49.053 -     INFO :    influxdb:
2022-12-23 20:06:49.053 -     INFO :      asynchronous: false
2022-12-23 20:06:49.053 -     INFO :      bucket: myelectricaldata
2022-12-23 20:06:49.054 -     INFO :      enable: False
2022-12-23 20:06:49.054 -     INFO :      host: influxdb
2022-12-23 20:06:49.054 -     INFO :      org: myelectricaldata
2022-12-23 20:06:49.055 -     INFO :      port: 8086
2022-12-23 20:06:49.055 -     INFO :      token: ** hidden **
2022-12-23 20:06:49.055 -     INFO :    mqtt:
2022-12-23 20:06:49.056 -     INFO :      client_id: myelectricaldata
2022-12-23 20:06:49.056 -     INFO :      enable: False
2022-12-23 20:06:49.057 -     INFO :      host: X.X.X.X
2022-12-23 20:06:49.057 -     INFO :      password: ** hidden **
2022-12-23 20:06:49.057 -     INFO :      port: 1883
2022-12-23 20:06:49.058 -     INFO :      prefix: myelectricaldata
2022-12-23 20:06:49.059 -     INFO :      qos: 0
2022-12-23 20:06:49.059 -     INFO :      retain: True
2022-12-23 20:06:49.060 -     INFO :      username: 
2022-12-23 20:06:49.060 -     INFO :    myelectricaldata:
2022-12-23 20:06:49.060 -     INFO :      pdl:
2022-12-23 20:06:49.061 -     INFO :        cache: True
2022-12-23 20:06:49.061 -     INFO :        consumption: True
2022-12-23 20:06:49.061 -     INFO :        consumption_detail: True
2022-12-23 20:06:49.062 -     INFO :        consumption_detail_max_date: 
2022-12-23 20:06:49.062 -     INFO :        consumption_max_date: 
2022-12-23 20:06:49.062 -     INFO :        consumption_price_base: 0
2022-12-23 20:06:49.063 -     INFO :        consumption_price_hc: 0
2022-12-23 20:06:49.063 -     INFO :        consumption_price_hp: 0
2022-12-23 20:06:49.064 -     INFO :        enable: True
2022-12-23 20:06:49.064 -     INFO :        offpeak_hours_0: 
2022-12-23 20:06:49.064 -     INFO :        offpeak_hours_1: 
2022-12-23 20:06:49.065 -     INFO :        offpeak_hours_2: 
2022-12-23 20:06:49.065 -     INFO :        offpeak_hours_3: 
2022-12-23 20:06:49.066 -     INFO :        offpeak_hours_4: 
2022-12-23 20:06:49.066 -     INFO :        offpeak_hours_5: 
2022-12-23 20:06:49.066 -     INFO :        offpeak_hours_6: 
2022-12-23 20:06:49.067 -     INFO :        plan: BASE
2022-12-23 20:06:49.067 -     INFO :        production: False
2022-12-23 20:06:49.067 -     INFO :        production_detail: False
2022-12-23 20:06:49.068 -     INFO :        production_detail_max_date: 
2022-12-23 20:06:49.068 -     INFO :        production_max_date: 
2022-12-23 20:06:49.069 -     INFO :        production_price: 0
2022-12-23 20:06:49.069 -     INFO :        token: ** hidden **
2022-12-23 20:06:49.069 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-23 20:06:49.070 -     INFO :  Check config.yaml :
2022-12-23 20:06:49.070 - CRITICAL :  Some mandatory parameters are missing:
2022-12-23 20:06:49.071 - CRITICAL :  - PDL must be 14 characters (pdl => 3)
2022-12-23 20:06:49.071 - CRITICAL :  
2022-12-23 20:06:49.072 - CRITICAL :  You can get list of parameters here :
2022-12-23 20:06:49.072 - CRITICAL :   => https://github.com/m4dm4rtig4n/enedisgateway2mqtt#configuration-file

Donc la j’ai repris mon fichier je ne sais combien de fois.
J’ai donc dans : /config/enedisgateway2mqtt/enedisgateway2mqtt.yaml, ceci

cycle: 14400  # 4H
debug: false

home_assistant:
  card_myenedis: true
  discovery_prefix: homeassistant
  enable: true
  
influxdb:
  enable: true
  hostname: a0d7b954-influxdb
  port: 8086
  token: E4tVe41pui7VHmCoPtizuVCmzMCPb4QX25UhpW5ILka803GnYdVMxC
  org: "-"
  bucket: myelectricaldata/autogen
  # 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
    
mqtt:
  enable: true
  hostname: core-mosquitto
  port: 1883
  username: mqtt
  password: mqtt
  prefix: myelectricaldata
  client_id: myelectricaldata     # DOIT ETRE UNIQUE SUR LA TOTALITE DES CLIENTS CONNECTE AU SERVEUR MQTT
  retain: true
  qos: 0
  
myelectricaldata:
  5************8:
    name: Domicile
    enable: 'true'
    token: E*********************************C
    cache: true
    refresh_addresse: true
    refresh_contract: true

Du coups… je ne vois pas ou est le problème…. Le PDL et le token sont bon. J’ai fait une erreur qq parts ?

D’avance merci pour votre aide et patience !

Ma configuration

[center] ## System Information

version core-2022.12.8
installation_type Home Assistant OS
dev false
hassio true
docker true
user root
virtualenv false
python_version 3.10.7
os_name Linux
os_version 5.15.76-v8
arch aarch64
timezone Europe/Paris
config_dir /config
Home Assistant Community Store
GitHub API ok
GitHub Content ok
GitHub Web ok
GitHub API Calls Remaining 4796
Installed Version 1.28.3
Stage running
Available Repositories 1199
Downloaded Repositories 15
AccuWeather
can_reach_server ok
remaining_requests 43
Aqara Gateway

telnet_logged |
– | –
mqtt_connected |

Home Assistant Cloud
logged_in false
can_reach_cert_server ok
can_reach_cloud_auth ok
can_reach_cloud ok
Home Assistant Supervisor
host_os Home Assistant OS 9.4
update_channel stable
supervisor_version supervisor-2022.11.2
agent_version 1.4.1
docker_version 20.10.19
disk_total 109.3 GB
disk_used 29.5 GB
healthy true
supported true
board rpi4-64
supervisor_api ok
version_api ok
installed_addons Terminal & SSH (9.6.1), Samba share (10.0.0), File editor (5.4.2), Duck DNS (1.15.0), Dnsmasq (1.5.1), eWeLink Smart Home (1.3.3), Z-Wave JS (0.1.74), Spotify Connect (0.12.2), Mosquitto broker (6.1.3), Zigbee2MQTT (1.28.4-1), Hotspot wifi pour RPI (dev), MyElectricalData (0.8.11-beta1)
Dashboards
dashboards 1
resources 12
views 13
mode storage
Recorder
oldest_recorder_run 14 décembre 2022 à 19:01
current_recorder_run 23 décembre 2022 à 18:56
estimated_db_size 444.27 MiB
database_engine sqlite
database_version 3.38.5
Spotify
api_endpoint_reachable ok
Xiaomi Miot Auto
component_version 0.7.1
can_reach_server ok
can_reach_spec ok
logged_accounts 1
total_devices 7
[/center] ___
2

Hello

Tu es sur que ton chemin est bon dans la config ?
Car la il dis qui trouve pas ton fichier configuration

Capture d’écran 2022-12-23 203204
Capture d’écran 2022-12-23 2032041065×487 15.6 KB

3

De plus si tu as que cela il te manque des infos

Voici ce que contient le fichier

Capture d’écran 2022-12-23 203657
Capture d’écran 2022-12-23 203657519×618 20 KB

4

Bonsoir à tous les deux,

Merci pour votre réponse.

J’ai donc effectué les vérif et modif que vous m’avez soumis.

Ci joint ce que je recupére:

Starting...
/etc/cont-init.d/00-banner.sh: executing
-----------------------------------------------------------
 Add-on: MyElectricalData
 Use Enedis Gateway API to send data in your MQTT Broker (latest channel)
-----------------------------------------------------------
 Add-on version: 0.8.11-beta1
 You are running the latest version of this add-on.
 System: Home Assistant OS 9.4  (aarch64 / raspberrypi4-64)
 Home Assistant Core: 2022.12.8
 Home Assistant Supervisor: 2022.11.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums
 https://github.com/alexbelgium/hassio-addons
-----------------------------------------------------------
/etc/cont-init.d/00-global_var.sh: executing
CONFIG_LOCATION='/config/enedisgateway2mqtt/config.yaml'
TZ='Europe/Paris'
mqtt_autodiscover='true'
verbose='true'
/etc/cont-init.d/01-custom_script.sh: executing
[22:39:30] INFO: Execute /config/enedisgateway2mqtt.sh if existing
[22:39:30] INFO: ... no script found
/etc/cont-init.d/91-mqtt_autodiscover.sh: executing
[22:39:31] INFO: mqtt_autodiscover is defined in options, attempting autodiscovery...
[22:39:32] INFO: ... MQTT service found, fetching server detail (you can enter those manually in your config file) ...
/etc/cont-init.d/91-mqtt_autodiscover.sh: exiting 2
/etc/cont-init.d/99-run.sh: executing
creating symlink
[22:39:36] INFO: Using database file found in /config/enedisgateway2mqtt
[22:39:36] INFO: Using config file found in /config/enedisgateway2mqtt/config.yaml
/config/enedisgateway2mqtt/config.yaml
  29:1      error    trailing spaces  (trailing-spaces)
  38:81     warning  line too long (113 > 80 characters)  (line-length)
  39:81     warning  line too long (105 > 80 characters)  (line-length)
  40:81     warning  line too long (83 > 80 characters)  (line-length)
  42:81     warning  line too long (91 > 80 characters)  (line-length)
  52:1      error    trailing spaces  (trailing-spaces)
  54:81     warning  line too long (105 > 80 characters)  (line-length)
  75:27     error    no new line character at the end of file  (new-line-at-end-of-file)
[22:39:37] FATAL: Config file has an invalid yaml format. Please check the file in /config/enedisgateway2mqtt/config.yaml. Errors list above. You can check yaml validity with the online tool yamllint.com
/etc/cont-init.d/99-run.sh: exiting 1

image
image1076×561 18.7 KB

Ca avance mais je reste bloquée. Des idées à nouveau ?

Merci encore à vous

5

Je me reponds à moi meme.

J’ai repris ligne par ligne par rapport au journal, et jai reussi à corriger.

Demain je re editerais ce post, si jamais d’autres personnes sont aussi confrontées (et peu expérimenté comme moi) pour résoudre les problèmes par ligne.

Nouvelle avancée, nouveaux problèmes.
L’application « crash »
Et la… je nai pas encore trouvé…

Si certain ont des idées je prends.

Voici le journal:

2022-12-24 00:38:14.032 -     INFO :   => lastUpdate
2022-12-24 00:38:14.033 -     INFO :   Success
2022-12-24 00:38:16.756 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.757 -     INFO :  RUN IN PRODUCTION MODE
2022-12-24 00:38:16.758 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.813 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.814 -     INFO : ▌│█║▌║▌║  __  __         _____  _              _          _               _  ____          _           ║▌║▌║█│▌
2022-12-24 00:38:16.814 -     INFO : ▌│█║▌║▌║ |  \/  | _   _ | ____|| |  ___   ___ | |_  _ __ (_)  ___   __ _ | ||  _ \   __ _ | |_   __ _  ║▌║▌║█│▌
2022-12-24 00:38:16.815 -     INFO : ▌│█║▌║▌║ | |\/| || | | ||  _|  | | / _ \ / __|| __|| '__|| | / __| / _` || || | | | / _` || __| / _` | ║▌║▌║█│▌
2022-12-24 00:38:16.815 -     INFO : ▌│█║▌║▌║ | |  | || |_| || |___ | ||  __/| (__ | |_ | |   | || (__ | (_| || || |_| || (_| || |_ | (_| | ║▌║▌║█│▌
2022-12-24 00:38:16.816 -     INFO : ▌│█║▌║▌║ |_|  |_| \__, ||_____||_| \___| \___| \__||_|   |_| \___| \__,_||_||____/  \__,_| \__| \__,_| ║▌║▌║█│▌
2022-12-24 00:38:16.816 -     INFO : ▌│█║▌║▌║          |___/                                                                                ║▌║▌║█│▌
2022-12-24 00:38:16.817 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.817 -     INFO : ▌│█║▌║▌║                                       VERSION : 0.8.10                                        ║▌║▌║█│▌
2022-12-24 00:38:16.818 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.818 -     INFO :  Display configuration :
2022-12-24 00:38:16.818 -     INFO :    cycle: 14400
2022-12-24 00:38:16.819 -     INFO :    debug: False
2022-12-24 00:38:16.819 -     INFO :    home_assistant:
2022-12-24 00:38:16.820 -     INFO :      card_myenedis: True
2022-12-24 00:38:16.820 -     INFO :      discovery_prefix: homeassistant
2022-12-24 00:38:16.821 -     INFO :      enable: True
2022-12-24 00:38:16.821 -     INFO :    influxdb:
2022-12-24 00:38:16.821 -     INFO :      enable: True
2022-12-24 00:38:16.822 -     INFO :      hostname: a0d7b954-influxdb
2022-12-24 00:38:16.822 -     INFO :      port: 8086
2022-12-24 00:38:16.823 -     INFO :      token: ** hidden **
2022-12-24 00:38:16.823 -     INFO :      org: -
2022-12-24 00:38:16.823 -     INFO :      bucket: myelectricaldata/autogen
2022-12-24 00:38:16.824 -     INFO :      asynchronous: false
2022-12-24 00:38:16.824 -     INFO :    mqtt:
2022-12-24 00:38:16.825 -     INFO :      client_id: myelectricaldata
2022-12-24 00:38:16.825 -     INFO :      enable: True
2022-12-24 00:38:16.825 -     INFO :      hostname: core-mosquitto
2022-12-24 00:38:16.826 -     INFO :      password: ** hidden **
2022-12-24 00:38:16.826 -     INFO :      port: 1883
2022-12-24 00:38:16.826 -     INFO :      prefix: myelectricaldata
2022-12-24 00:38:16.827 -     INFO :      qos: 0
2022-12-24 00:38:16.827 -     INFO :      retain: True
2022-12-24 00:38:16.828 -     INFO :      username: mqtt
2022-12-24 00:38:16.828 -     INFO :    myelectricaldata:
2022-12-24 00:38:16.828 -     INFO :      50087352204668:
2022-12-24 00:38:16.829 -     INFO :        name: Domicile
2022-12-24 00:38:16.829 -     INFO :        cache: True
2022-12-24 00:38:16.829 -     INFO :        consumption: True
2022-12-24 00:38:16.830 -     INFO :        consumption_detail: True
2022-12-24 00:38:16.830 -     INFO :        consumption_price_base: 0.22
2022-12-24 00:38:16.831 -     INFO :        enable: True
2022-12-24 00:38:16.831 -     INFO :        plan: BASE
2022-12-24 00:38:16.831 -     INFO :        token: ** hidden **
2022-12-24 00:38:16.832 -     INFO :        refresh_addresse: True
2022-12-24 00:38:16.832 -     INFO :        refresh_contract: True
2022-12-24 00:38:16.833 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.833 -     INFO :  Check config.yaml :
2022-12-24 00:38:16.833 -     INFO :   => Config valid
2022-12-24 00:38:16.864 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.865 -     INFO :  LOADING CONFIGURATION...
2022-12-24 00:38:16.865 -     INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-24 00:38:16.866 -     INFO :  5**********8
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: usage_points.consentement_expiration
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/app/main.py", line 46, in <module>
    DB.set_usage_point(usage_point_id, data)
  File "/app/models/database.py", line 205, in set_usage_point
    usage_points = self.session.scalars(query).one_or_none()
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars
    return self.execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1712, in execute
    result = conn._execute_20(statement, params or {}, execution_options)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
    util.raise_(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: usage_points.consentement_expiration
[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 
FROM usage_points 
WHERE usage_points.usage_point_id = ?]
[parameters: (5************8,)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
[00:38:17] FATAL: The app has crashed. Are you sure you entered the correct config options?
7

hello
je ne sais pas si ce sera la solution, mais sur ma config qui est ok : true ou false est tjr en minuscules. Si tu veux comparer de nouveau un config ok c’est ici Les cartes et MyelectricalData
Disclaimer, je galère actuellement sur une autre machine car les sensors ne remontent pas donc oui je ne suis pas un expert, juste un newbee qui progresse tt doucment :wink: bonne chance !

8

Ta version est 8.10 qui est loin derrière la version courante. Un des solutions entretemps est addresser les usage points. Fait la maj avant et rapporte les resultats…car on va pas analyser ni réparer sur une si ancienne version

9

Bonjour,

j’ai un soucis aussi pour la mise en route mais ça concerne influxdb car je n’ai rien qui remonte.
dans le fichier config.yaml de myelectricaldata j’ai ça :

influxdb:
  bucket: "myelectricaldata/autogen"
  enable: true
  hostname: a0d7b954-influxdb
  method: synchronous
  org: "-"
  port: 8086
  token: xxxxx:xxxxx
  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

pouvez-vous m’aider s’il vous plait ?

10

Hello

alors deja tu dois mettre les journaux !
qu’on regarde pourquoi il arrive a se connecté mais aucune info qui remontent.

ensuite ta config de influx quel version ?
influx est installé sur autre materiel ou sur HA ou en addons ???

Ensuite avec @FROlCi , qui a ouvert un topic sur les cartes , on a rajouté comment faire pour que influxdb se connecte.

Donc une recherche devrais t’aidé. :wink:

11

j’ai déjà lu le sujet et je n’y arrive pas :
influxdb est installé via les modules complémentaires et est en version 4.5.0

le journal :

time="2023-03-04T13:44:42+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42516" response_time=349.186261ms status=304
time="2023-03-04T13:44:42+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42528" response_time="324.457µs" status=200
time="2023-03-04T13:44:42+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42536" url=/worker.0332b3d1.js
time="2023-03-04T13:44:42+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42544" response_time="97.313µs" status=200
time="2023-03-04T13:44:42+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42536" response_time=34.523459ms status=304
time="2023-03-04T13:44:42+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42554" response_time="166.108µs" status=200
time="2023-03-04T13:44:42+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42556" response_time=5.447443ms status=200
time="2023-03-04T13:44:43+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42572" response_time=4.989618ms status=200
time="2023-03-04T13:44:43+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42574" url=/icomoon.05bfd89e.woff2
time="2023-03-04T13:44:43+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42574" response_time=1.427568ms status=304
time="2023-03-04T13:44:43+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:42580" response_time=1.12387ms status=204
time="2023-03-04T13:44:43+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42584" url=/laser-spinner.0560a4d9.png
time="2023-03-04T13:44:43+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42584" response_time=7.046693ms status=304
time="2023-03-04T13:44:43+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:42592" response_time="371.067µs" status=200
time="2023-03-04T13:44:43+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:42602" response_time=3.6249ms status=200
time="2023-03-04T13:44:43+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42618" url=/Roboto-Bold.95244466.ttf
time="2023-03-04T13:44:43+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42630" url=/Roboto-Regular.f82a1950.ttf
time="2023-03-04T13:44:43+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42640" url=/Roboto-Black.4c9983d4.ttf
time="2023-03-04T13:44:43+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42618" response_time=26.461672ms status=304
time="2023-03-04T13:44:43+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42630" response_time=28.012108ms status=304
time="2023-03-04T13:44:43+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:42646" response_time=4.339202ms status=200
time="2023-03-04T13:44:43+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42640" response_time=31.267886ms status=304
time="2023-03-04T13:44:44+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:42652" response_time=1.156703ms status=204
time="2023-03-04T13:44:44+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42672" url=/RobotoMono-Medium.ed4bd09b.ttf
time="2023-03-04T13:44:44+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:42662" response_time=24.93594ms status=200
time="2023-03-04T13:44:44+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:42682" url=/Roboto-Medium.7030d125.ttf
time="2023-03-04T13:44:44+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42672" response_time=16.26859ms status=304
time="2023-03-04T13:44:44+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:42682" response_time=24.487725ms status=304
time="2023-03-04T13:44:46+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46462" response_time=27.515784ms status=200
time="2023-03-04T13:44:46+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46470" response_time=38.050991ms status=200
time="2023-03-04T13:44:46+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46482" response_time=49.417278ms status=200
time="2023-03-04T13:44:47+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46494" response_time=34.909046ms status=200
time="2023-03-04T13:44:47+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46522" response_time=37.801274ms status=200
time="2023-03-04T13:44:47+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46510" response_time=53.068752ms status=200
time="2023-03-04T13:44:52+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46524" response_time="80.776µs" status=200
time="2023-03-04T13:45:03+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:48900" response_time="97.665µs" status=200
time="2023-03-04T13:45:14+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:56844" response_time="163.22µs" status=200
time="2023-03-04T13:45:17+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:58820" response_time="421.863µs" status=200
time="2023-03-04T13:45:24+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:58830" response_time="101.036µs" status=200
time="2023-03-04T13:45:28+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:53900" response_time=1.512197ms status=204
time="2023-03-04T13:45:28+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:53910" response_time=20.662038ms status=200
time="2023-03-04T17:11:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:45372" url=/
time="2023-03-04T17:11:10+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:45372" response_time=1.374464ms status=304
time="2023-03-04T17:11:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:45384" url=/src.9cea3e4e.css
time="2023-03-04T17:11:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:45398" url=/src.a969287c.js
time="2023-03-04T17:11:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:45384" response_time=379.087724ms status=200
time="2023-03-04T17:11:13+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:45398" response_time=2.439625834s status=200
time="2023-03-04T17:11:26+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:36926" url=/src.a969287c.js
time="2023-03-04T17:11:28+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:36926" response_time=2.2353087s status=200
time="2023-03-05T08:55:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:45976" url=/
time="2023-03-05T08:55:10+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:45976" response_time=1.380207ms status=304
time="2023-03-05T08:55:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:45986" url=/src.9cea3e4e.css
time="2023-03-05T08:55:10+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46002" url=/src.a969287c.js
time="2023-03-05T08:55:10+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:45986" response_time=65.908765ms status=304
time="2023-03-05T08:55:10+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46002" response_time=413.078045ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46006" response_time=5.574901ms status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46012" url=/worker.0332b3d1.js
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46014" response_time="87.592µs" status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46020" response_time="148.313µs" status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46012" response_time=42.534674ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46034" response_time=23.846809ms status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46050" url=/icomoon.05bfd89e.woff2
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46050" response_time=6.84422ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46046" response_time=6.941071ms status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:46052" response_time=1.009285ms status=204
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46066" url=/laser-spinner.0560a4d9.png
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46066" response_time=5.520883ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46068" response_time="362.792µs" status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46078" url=/Roboto-Regular.f82a1950.ttf
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46090" url=/Roboto-Bold.95244466.ttf
time="2023-03-05T08:55:11+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46104" url=/Roboto-Black.4c9983d4.ttf
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46090" response_time=36.835349ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46106" response_time=15.345144ms status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46108" response_time=8.786884ms status=200
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46078" response_time=50.549436ms status=304
time="2023-03-05T08:55:11+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46104" response_time=31.569167ms status=304
time="2023-03-05T08:55:14+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:46114" response_time=1.030081ms status=204
time="2023-03-05T08:55:14+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46122" response_time=24.663151ms status=200
time="2023-03-05T08:55:14+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:46124" response_time="158.239µs" status=200
time="2023-03-05T08:55:14+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46132" response_time=6.895256ms status=200
time="2023-03-05T08:55:15+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46144" response_time=6.869479ms status=200
time="2023-03-05T08:55:15+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:46154" response_time=1.154062ms status=204
time="2023-03-05T08:55:15+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46178" url=/Roboto-Medium.7030d125.ttf
time="2023-03-05T08:55:15+01:00" level=info msg="Serving assets" component=server method=GET remote_addr="127.0.0.1:46186" url=/RobotoMono-Medium.ed4bd09b.ttf
time="2023-03-05T08:55:15+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46186" response_time=16.534667ms status=304
time="2023-03-05T08:55:15+01:00" level=info msg="Response: Not Modified" component=server method=GET remote_addr="127.0.0.1:46178" response_time=22.232919ms status=304
time="2023-03-05T08:55:15+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:46170" response_time=183.739654ms status=200
time="2023-03-05T08:55:22+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:49830" response_time=1.448854ms status=200
time="2023-03-05T08:55:32+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:52176" response_time=3.772476ms status=200
time="2023-03-05T08:55:39+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60928" response_time="679.196µs" status=200
time="2023-03-05T08:55:43+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60944" response_time=5.040295ms status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60946" response_time="168.517µs" status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60952" response_time="87.277µs" status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60956" response_time=4.119139ms status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60962" response_time=25.382309ms status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60968" response_time=3.86729ms status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: No Content" component=server method=GET remote_addr="127.0.0.1:60970" response_time=1.197116ms status=204
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=GET remote_addr="127.0.0.1:60978" response_time="297.293µs" status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:60986" response_time=2.093865ms status=200
time="2023-03-05T08:55:44+01:00" level=info msg="Response: OK" component=server method=POST remote_addr="127.0.0.1:60990" response_time=3.558516ms status=200

merci