Eigene Visualisierung von Daten vom Auto

stein · 13. April 2022

Also im WeConnect-cli hat es ja funktioniert.

Du kannst mal

Code

weconnect-cli --username kailas@online.de --password PW get /

machen, da sollten alle Daten auch kommen.

Das ist schon mal gut. Also bleibt die Frage warum es im VWsFriend nicht geht.

Hast du deinen Usernamen auch in der myconfig.env eingetragen?

AdMan

Hallo,
schau mal hier: (hier klicken). Dort findet man vieles zum VW ID.

ponzelar · 13. April 2022

Danke, die Daten kommen alle,und sind auch logisch. Ich habe 3 Usernamen:

vwsfriend, weconnect, db_user mit div. Werten eingetragen

stein · 13. April 2022

VWSFRIEND_USER ist für die Oberfläche, den kannst du dir aussuchen.

WECONNECT_USER muss deine Volkswagen ID sein. Also kailas@online.de

DB_USER brauchst du nur wenn du mal auf die Datenbank von Hand zugreifen willst. Ist erstmal egal.

ponzelar · 13. April 2022

da ist mal ein Fehler: ich hatte da *.env robert eingetragen

Code

weconnect-cli --username kailas@online.de --password PW get /
Vehicle: WVWZZZxxxxx
VIN:               WVWZZZE1xxxxx
Model:             ID.3
Device Platform:   WCAR
Nickname:          ID.3 Pro
Role:              PRIMARY_USER
Enrollment Status: COMPLETED
User Role Status:  ENABLED
Capabilities: 35 items
    [automation] disabling: True
    [batteryChargingCare] Status: MISSING_SERVICE disabling: False
    [batteryColdWarning] Status: MISSING_SERVICE disabling: False
    [batterySupport] Status: MISSING_SERVICE disabling: False
    [cdisDigitalKey] Status: MISSING_SERVICE disabling: False
    [charging] disabling: True
    [chargingStations] disabling: True
    [climatisation] disabling: True
    [dealerAppointment] Status: MISSING_SERVICE disabling: False
    [destinations] disabling: True
    [fuelStatus] disabling: False
    [ignition] disabling: False
    [mapUpdate] disabling: True
    [measurements] Status: MISSING_SERVICE disabling: False
    [onlineSpeech] disabling: True
    [parkingBrake] Status: MISSING_SERVICE disabling: False
    [parkingInformation] disabling: True
    [parkingPosition] Status: MISSING_SERVICE disabling: False
    [personalizationOnline] Status: MISSING_SERVICE disabling: False
    [plugAndCharge] Status: MISSING_SERVICE disabling: False
    [poiSearch] Status: MISSING_SERVICE disabling: False
    [privateEmergencyCall] Status: MISSING_SERVICE disabling: False
    [readiness] disabling: False
    [roadExperienceManagementLocalization] Status: MISSING_SERVICE disabling: False
    [roadExperienceManagementLocalizationUpload] Status: MISSING_SERVICE disabling: False
    [roadsideAssistant] Status: MISSING_SERVICE disabling: False
    [routing] disabling: True
    [state] Status: MISSING_SERVICE disabling: False
    [trafficInformation] disabling: True
    [vehicleHealth] Status: MISSING_SERVICE disabling: False
    [vehicleHealthInspection] Status: MISSING_SERVICE disabling: False
    [vehicleHealthWarnings] Status: MISSING_SERVICE disabling: False
    [vehicleLights] Status: MISSING_SERVICE disabling: False
    [vehicleWakeUpTrigger] Status: MISSING_SERVICE disabling: False
    [webRadio] disabling: True
Domains: 6 items
[automation] Elements: 2 items
    [climatisationTimer] (last captured 2022-04-13T08:57:23+00:00)
        Time in Car: 2022-04-13T10:57:23+02:00 (captured at 2022-04-13T08:57:23+00:00)
        Timers: 2 items
            1: Enabled: False at 1999-12-31T22:00:00+00:00 
            2: Enabled: False at 1999-12-31T22:00:00+00:00 
    [chargingProfiles] (last captured 2022-04-13T08:57:27+00:00)
        Time in Car: 2022-04-13T10:57:23+02:00 (captured at 2022-04-13T08:57:27+00:00)
            Profiles: 0 items
[userCapabilities] Elements: 1 items
    [capabilitiesStatus]
        Capabilities: 35 items
            [automation] disabling: True
            [batteryChargingCare] Status: MISSING_SERVICE disabling: False
            [batteryColdWarning] Status: MISSING_SERVICE disabling: False
            [batterySupport] Status: MISSING_SERVICE disabling: False
            [cdisDigitalKey] Status: MISSING_SERVICE disabling: False
            [charging] disabling: True
            [chargingStations] disabling: True
            [climatisation] disabling: True
            [dealerAppointment] Status: MISSING_SERVICE disabling: False
            [destinations] disabling: True
            [fuelStatus] disabling: False
            [ignition] disabling: False
            [mapUpdate] disabling: True
            [measurements] Status: MISSING_SERVICE disabling: False
            [onlineSpeech] disabling: True
            [parkingBrake] Status: MISSING_SERVICE disabling: False
            [parkingInformation] disabling: True
            [parkingPosition] Status: MISSING_SERVICE disabling: False
            [personalizationOnline] Status: MISSING_SERVICE disabling: False
            [plugAndCharge] Status: MISSING_SERVICE disabling: False
            [poiSearch] Status: MISSING_SERVICE disabling: False
            [privateEmergencyCall] Status: MISSING_SERVICE disabling: False
            [readiness] disabling: False
            [roadExperienceManagementLocalization] Status: MISSING_SERVICE disabling: False
            [roadExperienceManagementLocalizationUpload] Status: MISSING_SERVICE disabling: False
            [roadsideAssistant] Status: MISSING_SERVICE disabling: False
            [routing] disabling: True
            [state] Status: MISSING_SERVICE disabling: False
            [trafficInformation] disabling: True
            [vehicleHealth] Status: MISSING_SERVICE disabling: False
            [vehicleHealthInspection] Status: MISSING_SERVICE disabling: False
            [vehicleHealthWarnings] Status: MISSING_SERVICE disabling: False
            [vehicleLights] Status: MISSING_SERVICE disabling: False
            [vehicleWakeUpTrigger] Status: MISSING_SERVICE disabling: False
            [webRadio] disabling: True
[charging] Elements: 5 items
    [batteryStatus] (last captured 2022-04-12T13:59:42+00:00)
        Current SoC: 76%
        Range: 332km
    [chargingStatus] (last captured 2022-04-12T13:59:42+00:00)
        State: readyForCharging
        Mode: manual
        Remaining Charging Time: 0 minutes
        Charge Power: 0.0 kW
        Charge Rate: 0.0 km/h
        Charge Type: invalid
        Charging Settings: default
    [chargingSettings] (last captured 2022-04-13T08:57:45+00:00)
        Maximum Charge Current AC: maximum
        Auto Unlock When Charged: off
        Target SoC: 80 %
    [chargeMode]
        Preferred charge mode: manual
        Available charge modes: [invalid]
    [plugStatus] (last captured 2022-04-13T08:57:38+00:00)
        Plug: disconnected, unlocked
[climatisation] Elements: 3 items
    [climatisationStatus] (last captured 2022-04-13T08:57:36+00:00)
        State: off
        Remaining Climatization Time: 0 min
    [climatisationSettings] (last captured 2022-04-13T08:57:36+00:00)
        Target Temperature in °C: 18.5 °C 
        Target Temperature in °F: 65.0 °F 
        Temperature unit in car: celsius
        Climatization without external Power: True
        Start climatization after unlock: False
        Window heating: False
        Heating Front Left Seat: False
        Heating Front Right Seat: False
    [windowHeatingStatus] (last captured 2022-04-13T08:57:36+00:00)
        Windows: 2 items
            front: off
            rear: off
[fuelStatus] Elements: 1 items
    [rangeStatus] (last captured 2022-04-12T13:59:42+00:00)
        Car Type: electric
        Total Range: 332 km
        Primary Engine: electric  SoC: 76% (332 km)
[readiness] Elements: 1 items
    [readinessStatus]
        Connection State: 
            Is online: True
            Is active: False
            Battery power level: comfort
            Daily Power Budget Available: True 
        Connection Warning: 
            Insufficient Battery Level Warning: False
            Daily Power Budget Warning: False 


pi@raspberrypi:~ $

Alles anzeigen

der Fehler beim Start mit docker-Compose etc.bringt immer noch den Fehler wie in 403 gezeigt. Database vwsfriend fehlt. Der Container ist da.

ponzelar · 13. April 2022

Es gibt eine Änderung:

Code

postgresdb_1  | 2022-04-13 14:02:03.687 UTC [5723] FATAL:  database "vwsfriend" does not exist
postgresdb_1  | 2022-04-13 14:02:08.657 UTC [5732] FATAL:  database "vwsfriend" does not exist
postgresdb_1  | 2022-04-13 14:02:13.713 UTC [5733] FATAL:  database "vwsfriend" does not exist
vwsfriend_1   | 2022-04-13T14:02:13+0000:ERROR:agent_connector:Could not establish a connection to database, will try again after 10 seconds: (psycopg2.OperationalError) FATAL:  database "vwsfriend" does not exist
vwsfriend_1   | 
vwsfriend_1   | (Background on this error at: https://sqlalche.me/e/14/e3q8)
postgresdb_1  | 2022-04-13 14:02:18.910 UTC [5742] FATAL:  database "vwsfriend" does not exist
postgresdb_1  | 2022-04-13 14:02:23.739 UTC [5743] FATAL:  database "vwsfriend" does not exist
vwsfriend_1   | 2022-04-13T14:02:23+0000:ERROR:agent_connector:Could not establish a connection to database, will try again after 10 seconds: (psycopg2.OperationalError) FATAL:  database "vwsfriend" does not exist
vwsfriend_1   |

Das läuft jetzt wieder unendlich. Es ist mir rätselhaft!!!

stein · 13. April 2022

Es kann sein dass das ganze wegen der vielen Änderungen etwas durcheinander ist. Wenn du

Code

docker-compose down -v

machst, dann sollte es alles zurück setzen und danach bei up wieder anlegen.

siduenho · 13. April 2022

ponzelar Bitte ändere zeitnah dein Passwort Ich habe das Mal aus allen Beiträgen entfernt.

ponzelar · 13. April 2022

siduenho Ja, vielen Dank war dämlich.

stein Ganz großen Dank. Offensichtlich hatte ich von Anfang an einen Fehler beim Start mit Compose-....

stein · 13. April 2022

Super wenn es jetzt läuft!

weadolf · 14. April 2022

Hallo stein,

seit 2 Tagen wird mir im Grafana Information Fenster nur noch eine Fehlermeldung angezeigt.

Screenshot 2022-04-14 100449.png

Der Log schaut wie folgt aus

Code

grafana_1     | logger=context t=2022-04-14T07:33:04.6+0000 lvl=info msg="Request Completed" method=POST path=/api/ds/query status=400 remote_addr=192.168.0.105 time_ms=234 size=1246 referer="http://192.168.0.122:3000/?orgId=1&refresh=1m"
postgresdb_1  | 2022-04-14 07:34:04.531 UTC [331] ERROR:  relation "warning_lights" does not exist at character 2893
postgresdb_1  | 2022-04-14 07:34:04.531 UTC [331] STATEMENT:  SELECT
postgresdb_1  |           logtime,
postgresdb_1  |           log FROM
postgresdb_1  |         (
postgresdb_1  |           (SELECT
postgresdb_1  |             started AS logtime,
postgresdb_1  |             'charging started' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE started IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY started DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             connected AS logtime,
postgresdb_1  |             'charger connected' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE connected IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY connected DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             locked AS logtime,
postgresdb_1  |             'connector locked' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE locked IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY locked DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |             (SELECT
postgresdb_1  |             ended AS logtime,
postgresdb_1  |             'charging ended' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE ended IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY ended DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             disconnected AS logtime,
postgresdb_1  |             'charger disconnected' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE disconnected IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY disconnected DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             unlocked AS logtime,
postgresdb_1  |             'connector unlocked' AS log
postgresdb_1  |           FROM charging_sessions
postgresdb_1  |           WHERE unlocked IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY unlocked DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             date AS logtime,
postgresdb_1  |             'car was refueled' AS log
postgresdb_1  |           FROM refuel_sessions
postgresdb_1  |           WHERE date IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY date DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |            UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             "startDate" AS logtime,
postgresdb_1  |             'trip started' AS log
postgresdb_1  |           FROM trips
postgresdb_1  |           WHERE "startDate" IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY "startDate" DESC
postgresdb_1  |           LIMIT 10)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             "endDate" AS logtime,
postgresdb_1  |             'trip ended' AS log
postgresdb_1  |           FROM trips
postgresdb_1  |           WHERE "endDate" IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY "endDate" DESC
postgresdb_1  |           LIMIT 10)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |           "carCapturedTimestamp" AS logtime,
postgresdb_1  |           CASE WHEN "climatisationState"= 'OFF' THEN 'climatisation stopped'
postgresdb_1  |                WHEN "climatisationState"= 'HEATING' THEN 'climatisation heating'
postgresdb_1  |                WHEN "climatisationState"= 'COOLING' THEN 'climatisation cooling'
postgresdb_1  |                WHEN "climatisationState"= 'VENTILATION' THEN 'climatisation ventilating'
postgresdb_1  |                ELSE 'unkown'
postgresdb_1  |           END AS log
postgresdb_1  |         FROM
postgresdb_1  |           (SELECT
postgresdb_1  |                 "carCapturedTimestamp",
postgresdb_1  |                 "climatisationState",
postgresdb_1  |                 LAG("climatisationState") OVER (ORDER BY "carCapturedTimestamp") AS "beforeClimatisationState",
postgresdb_1  |                 'climatisation started' AS log
postgresdb_1  |               FROM climatization
postgresdb_1  |               WHERE "carCapturedTimestamp" IS NOT NULL AND "climatisationState" IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |                 AND "climatisationState" IN ('OFF', 'HEATING', 'COOLING', 'VENTILATION')
postgresdb_1  |               ORDER BY "carCapturedTimestamp" DESC
postgresdb_1  |             ) AS climatization
postgresdb_1  |           WHERE "climatisationState" != "beforeClimatisationState"
postgresdb_1  |           ORDER BY "carCapturedTimestamp" DESC
postgresdb_1  |           LIMIT 10)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             start AS logtime,
postgresdb_1  |             'New warning: '||text AS log
postgresdb_1  |           FROM warning_lights
postgresdb_1  |           WHERE start IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
grafana_1     | logger=context t=2022-04-14T07:34:04.54+0000 lvl=info msg="Request Completed" method=POST path=/api/ds/query status=400 remote_addr=192.168.0.105 time_ms=160 size=1246 referer="http://192.168.0.122:3000/?orgId=1&refresh=1m"
postgresdb_1  |           ORDER BY start DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |           UNION
postgresdb_1  |           (SELECT
postgresdb_1  |             "end" AS logtime,
postgresdb_1  |             'Warning gone: '||text AS log
postgresdb_1  |           FROM warning_lights
postgresdb_1  |           WHERE "end" IS NOT NULL AND vehicle_vin = 'WVGZZZE2ZMP053xxx'
postgresdb_1  |           ORDER BY "end" DESC
postgresdb_1  |           LIMIT 3)
postgresdb_1  |         ) AS logs
postgresdb_1  |         ORDER BY 1 DESC
postgresdb_1  |         LIMIT 20

Alles anzeigen

Ich habe schon neu gestartet, aber die Fehlermeldung bleibt.

stein · 14. April 2022

Hmmm, das ist komisch. Du hast scheinbar schon die Dashboards für das kommende Release bekommen. Kann es sein dass du bei Grafana auf edge bist und nicht latest?

weadolf · 14. April 2022

stein, ich habe VWsFriend vor 5 Monaten auf einem RaspberryPi 3B installiert und habe immer nur fleißig deine Updates installiert. Ich denke Grafana habe ich über dein Script installiert. Kann ich irgendwo sehen, ob Grafana auf edge oder latest steht?

stein · 14. April 2022

Mit

Code

docker container ls

müsstest du es sehen.

weadolf · 14. April 2022

so schauts aus. Es ist edge. Kann ich das irgendwie ändern?

Code

pi@raspberrypi:~ $ docker container ls
CONTAINER ID   IMAGE                                  COMMAND                  CREATED       STATUS                 PORTS                                       NAMES
03de36206a33   tillsteinbach/vwsfriend:latest         "/bin/sh -c 'vwsfrie…"   6 hours ago   Up 6 hours (healthy)                                               vwsfriend_vwsfriend_1
e1cccefdc86b   tillsteinbach/vwsfriend-grafana:edge   "/run.sh"                6 hours ago   Up 6 hours (healthy)   0.0.0.0:3000->3000/tcp, :::3000->3000/tcp   vwsfriend_grafana_1
1977bc0e2211   postgres:13                            "docker-entrypoint.s…"   6 hours ago   Up 6 hours (healthy)   0.0.0.0:5432->5432/tcp, :::5432->5432/tcp   vwsfriend_postgresdb_1
7601b178768b   containrrr/watchtower                  "/watchtower --inter…"   4 weeks ago   Up 6 hours             8080/tcp                                    vwsfriend_watchtower_1

weadolf · 14. April 2022

stein, ich habe jetzt in der docker-compose.yml die Zeile 56 wie folgt geändert:

image: tillsteinbach/vwsfriend-grafana:${VWSFRIEND_GRAFANA_VERSION-latest}

in

image: tillsteinbach/vwsfriend-grafana:latest

und schon ist der Fehler weg.

Code

pi@raspberrypi:~ $ docker container ls
CONTAINER ID   IMAGE                                    COMMAND                  CREATED          STATUS                   PORTS                                       NAMES
b9a45ba555cd   tillsteinbach/vwsfriend-grafana:latest   "/run.sh"                6 minutes ago    Up 6 minutes (healthy)   0.0.0.0:3000->3000/tcp, :::3000->3000/tcp   vwsfriend_grafana_1
283f2ecf025c   tillsteinbach/vwsfriend:latest           "/bin/sh -c 'vwsfrie…"   14 minutes ago   Up 5 minutes (healthy)   0.0.0.0:4000->4000/tcp, :::4000->4000/tcp   vwsfriend_vwsfriend_1
44368ec9c834   postgres:13                              "docker-entrypoint.s…"   15 minutes ago   Up 6 minutes (healthy)   5432/tcp                                    vwsfriend_postgresdb_1
7601b178768b   containrrr/watchtower                    "/watchtower --inter…"   4 weeks ago      Up 8 hours               8080/tcp                                    vwsfriend_watchtower_1

stein, habe jetzt die Ursache gefunden. In meiner .env Datei stand als erster Eintrag

VWSFRIEND_GRAFANA_VERSION=edge

Ich nehme an, dass diese Zeile am Anfang noch drin war und später von dir entfernt wurde. Ich habe jetzt die Zeile in meiner .env Datei entfernt und es klappt nun.

Eigene Visualisierung von Daten vom Auto

Jetzt mitmachen!

Benutzer online in diesem Thema