wez / govee2mqtt

Govee2MQTT: Connect Govee lights and devices to Home Assistant
MIT License
467 stars 30 forks source link

DIY Scenes not showing up in HA #290

Open Tical84 opened 1 week ago

Tical84 commented 1 week ago

Govee Device SKU

H805C

Govee2MQTT Version

2024.07.13-82ddc6e9

Describe the issue

I was able to get my Govee H805C (permanent outdoor lights) connected and showing the out of the box scenes, but the custom scenes I've created are not showing up.

I have the API in and the LAN toggle on in the Govee app.

Startup Diagnostics

s6-rc: info: service s6rc-oneshot-runner: starting s6-rc: info: service s6rc-oneshot-runner successfully started s6-rc: info: service fix-attrs: starting s6-rc: info: service fix-attrs successfully started s6-rc: info: service legacy-cont-init: starting s6-rc: info: service legacy-cont-init successfully started s6-rc: info: service legacy-services: starting s6-rc: info: service legacy-services successfully started GOVEE_API_KEY=REDACTED GOVEE_MQTT_HOST=core-mosquitto GOVEE_TEMPERATURE_SCALE=C GOVEE_EMAIL=REDACTED GOVEE_PASSWORD=REDACTED GOVEE_MQTT_PASSWORD=REDACTED GOVEE_MQTT_USER=addons GOVEE_MQTT_PORT=1883 ++ cd /app ++ exec /app/govee serve [2024-10-14T17:30:01 INFO govee::commands::serve] Starting service. version 2024.07.13-82ddc6e9 [2024-10-14T17:30:01 INFO govee::commands::serve] Querying platform API for device list [2024-10-14T17:30:03 INFO govee::commands::serve] Querying undocumented API for device + room list [2024-10-14T17:30:05 INFO govee::service::iot] Connected to IoT: CONNACK code 0: Connection Accepted. [2024-10-14T17:30:05 INFO govee::commands::serve] Starting LAN discovery [2024-10-14T17:30:05 INFO govee::service::iot] IoT (re)connected with status CONNACK code 0: Connection Accepted. [2024-10-14T17:30:05 INFO govee::commands::serve] Waiting 10 seconds for LAN API discovery [2024-10-14T17:30:15 INFO govee::commands::serve] Devices returned from Govee's APIs [2024-10-14T17:30:15 INFO govee::commands::serve] Soffit Lights (0A:D0:C1:75:B5:EA:43:55 H805C) [2024-10-14T17:30:15 INFO govee::commands::serve] LAN API: ip=10.0.0.155 [2024-10-14T17:30:15 INFO govee::commands::serve] Platform API: devices.types.light. supports_rgb=true supports_brightness=true [2024-10-14T17:30:15 INFO govee::commands::serve] color_temp=Some((2700, 6500)) segment_rgb=Some(0..27) [2024-10-14T17:30:15 INFO govee::commands::serve] Undoc: room=None supports_iot=true ble_only=false [2024-10-14T17:30:15 INFO govee::commands::serve] Quirk { sku: "H805C", icon: "mdi:light-bulb", supports_rgb: true, supports_brightness: true, color_temp_range: Some((2000, 9000)), avoid_platform_api: false, ble_only: false, lan_api_capable: true, device_type: Light, platform_temperature_sensor_units: None, platform_humidity_sensor_units: None, iot_api_supported: true, show_as_preset_buttons: None } [2024-10-14T17:30:15 INFO govee::commands::serve] [2024-10-14T17:30:15 INFO govee::commands::serve] Net Lights (09:BE:C5:75:4E:0E:37:8E H6811) [2024-10-14T17:30:15 INFO govee::commands::serve] Platform API: devices.types.light. supports_rgb=true supports_brightness=true [2024-10-14T17:30:15 INFO govee::commands::serve] color_temp=Some((2000, 9000)) segment_rgb=None [2024-10-14T17:30:15 INFO govee::commands::serve] Undoc: room=None supports_iot=true ble_only=false [2024-10-14T17:30:15 INFO govee::commands::serve] [2024-10-14T17:30:15 INFO govee::service::http] http server addr is 0.0.0.0:8056 [2024-10-14T17:30:35 INFO govee::service::state] requesting update via Platform API Net Lights (09:BE:C5:75:4E:0E:37:8E H6811) None [2024-10-14T17:30:41 INFO govee::service::hass] Wait 410ms for hass to settle on 41 entity configs [2024-10-14T17:30:41 INFO govee::service::hass] MQTT connected with status=CONNACK code 0: Connection Accepted. s6-rc: info: service legacy-services: stopping s6-rc: info: service legacy-services successfully stopped s6-rc: info: service legacy-cont-init: stopping s6-rc: info: service legacy-cont-init successfully stopped s6-rc: info: service fix-attrs: stopping s6-rc: info: service fix-attrs successfully stopped s6-rc: info: service s6rc-oneshot-runner: stopping s6-rc: info: service s6rc-oneshot-runner successfully stopped s6-rc: info: service s6rc-oneshot-runner: starting s6-rc: info: service s6rc-oneshot-runner successfully started s6-rc: info: service fix-attrs: starting s6-rc: info: service fix-attrs successfully started s6-rc: info: service legacy-cont-init: starting s6-rc: info: service legacy-cont-init successfully started s6-rc: info: service legacy-services: starting s6-rc: info: service legacy-services successfully started GOVEE_API_KEY=REDACTED GOVEE_MQTT_HOST=core-mosquitto GOVEE_TEMPERATURE_SCALE=C GOVEE_EMAIL=REDACTED GOVEE_PASSWORD=REDACTED GOVEE_MQTT_PASSWORD=REDACTED GOVEE_MQTT_USER=addons GOVEE_MQTT_PORT=1883 ++ cd /app ++ exec /app/govee serve [2024-10-14T17:31:48 INFO govee::commands::serve] Starting service. version 2024.07.13-82ddc6e9 [2024-10-14T17:31:48 INFO govee::commands::serve] Querying platform API for device list [2024-10-14T17:31:48 INFO govee::commands::serve] Querying undocumented API for device + room list [2024-10-14T17:31:48 INFO govee::service::iot] Connected to IoT: CONNACK code 0: Connection Accepted. [2024-10-14T17:31:48 INFO govee::commands::serve] Starting LAN discovery [2024-10-14T17:31:48 INFO govee::commands::serve] Waiting 10 seconds for LAN API discovery [2024-10-14T17:31:48 INFO govee::service::iot] IoT (re)connected with status CONNACK code 0: Connection Accepted. [2024-10-14T17:31:58 INFO govee::commands::serve] Devices returned from Govee's APIs [2024-10-14T17:31:58 INFO govee::commands::serve] Soffit Lights (0A:D0:C1:75:B5:EA:43:55 H805C) [2024-10-14T17:31:58 INFO govee::commands::serve] LAN API: ip=10.0.0.155 [2024-10-14T17:31:58 INFO govee::commands::serve] Platform API: devices.types.light. supports_rgb=true supports_brightness=true [2024-10-14T17:31:58 INFO govee::commands::serve] color_temp=Some((2700, 6500)) segment_rgb=Some(0..27) [2024-10-14T17:31:58 INFO govee::commands::serve] Undoc: room=None supports_iot=true ble_only=false [2024-10-14T17:31:58 INFO govee::commands::serve] Quirk { sku: "H805C", icon: "mdi:light-bulb", supports_rgb: true, supports_brightness: true, color_temp_range: Some((2000, 9000)), avoid_platform_api: false, ble_only: false, lan_api_capable: true, device_type: Light, platform_temperature_sensor_units: None, platform_humidity_sensor_units: None, iot_api_supported: true, show_as_preset_buttons: None } [2024-10-14T17:31:58 INFO govee::commands::serve] [2024-10-14T17:31:58 INFO govee::commands::serve] Net Lights (09:BE:C5:75:4E:0E:37:8E H6811) [2024-10-14T17:31:58 INFO govee::commands::serve] Platform API: devices.types.light. supports_rgb=true supports_brightness=true [2024-10-14T17:31:58 INFO govee::commands::serve] color_temp=Some((2000, 9000)) segment_rgb=None [2024-10-14T17:31:58 INFO govee::commands::serve] Undoc: room=None supports_iot=true ble_only=false [2024-10-14T17:31:58 INFO govee::commands::serve] [2024-10-14T17:31:58 INFO govee::service::http] http server addr is 0.0.0.0:8056 [2024-10-14T17:32:18 INFO govee::service::state] requesting update via Platform API Net Lights (09:BE:C5:75:4E:0E:37:8E H6811) None [2024-10-14T17:32:22 INFO govee::service::hass] Wait 410ms for hass to settle on 41 entity configs [2024-10-14T17:32:23 INFO govee::service::hass] MQTT connected with status=CONNACK code 0: Connection Accepted.

Additional Logs

No response

Home Assistant Logs

No response

Anything else?

No response

cpw7922 commented 1 day ago

To add to this, when I Purge Caches I get this in my logs

[2024-10-22T18:54:57 ERROR govee::hass_mqtt::light] Unable to list scenes for Permanent Lights Elite (25:DA:C2:70:xx:xx:xx:xx H805B): list_scene_names: get_scene_caps: no such table: topic_NB2HI4Bxxxxx: Error code 1: SQL error or missing database