Also im WeConnect-cli hat es ja funktioniert.
Du kannst mal
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?
Also im WeConnect-cli hat es ja funktioniert.
Du kannst mal
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?
Hallo,
schau mal hier: (hier klicken). Dort findet man vieles zum VW ID.
Danke, die Daten kommen alle,und sind auch logisch. Ich habe 3 Usernamen:
vwsfriend, weconnect, db_user mit div. Werten eingetragen
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.
da ist mal ein Fehler: ich hatte da *.env robert eingetragen
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.
Es gibt eine Änderung:
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!!!
Super wenn es jetzt läuft!
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
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.
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?
so schauts aus. Es ist edge. Kann ich das irgendwie ändern?
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
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.
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.
Drei Gründe dafür:
- Austausch mit anderen VW ID. Fahrern
- Alles zu Versicherung & Finanzierung
- Tipps zum Fahren & Laden
Registriere Dich kostenlos und nehme an unserer Community teil!