Hello all, I recently bought a Sonoff Zigbee USB 3.0 Plus and am trying to integrate it into HA using ZHA. I am running my HA in a VM through Virtualbox. I flashed the dongle with the latest firmware following this guide https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=video&cd=&cad=rja&uact=8&ved=2ahUKEwjOjtfYvOL4AhW5lmoFHct_CqEQtwJ6BAgFEAI&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DKBAGWBWBATg&usg=AOvVaw32HfgYXrQMc51ecgSLMzeh
I was able to successfully pass the USB through to HA and ZHA could see it when attempting to add the integration. However, the integration fails during setup and I get the following from the log entry
Logger: homeassistant.config_entries
Source: components/zha/core/gateway.py:173
First occurred: 3:03:20 PM (1 occurrences)
Last logged: 3:03:20 PM
Error setting up entry Sonoff Zigbee 3.0 USB Dongle Plus, s/n: ... - ITead for zha
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/config_entries.py", line 339, in async_setup
result = await component.async_setup_entry(hass, self)
File "/usr/src/homeassistant/homeassistant/components/zha/__init__.py", line 102, in async_setup_entry
await zha_gateway.async_initialize()
File "/usr/src/homeassistant/homeassistant/components/zha/core/gateway.py", line 173, in sync_initialize
self.application_controller = await app_controller_cls.new(
File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 61, in new
await app._load_db()
File "/usr/local/lib/python3.9/site-packages/zigpy/application.py", line 53, in _load_db
await self._dblistener.load()
File "/usr/local/lib/python3.9/site-packages/zigpy/appdb.py", line 491, in load
await self._load_node_descriptors()
File "/usr/local/lib/python3.9/site-packages/zigpy/appdb.py", line 573, in _load_node_descriptors
async with self.execute(f"SELECT * FROM node_descriptors{DB_V}") as cursor:
File "/usr/local/lib/python3.9/site-packages/aiosqlite/context.py", line 41, in __aenter__
self._obj = await self._coro
File "/usr/local/lib/python3.9/site-packages/aiosqlite/core.py", line 184, in execute
cursor = await self._execute(self._conn.execute, sql, parameters)
File "/usr/local/lib/python3.9/site-packages/aiosqlite/core.py", line 129, in _execute
return await future
File "/usr/local/lib/python3.9/site-packages/aiosqlite/core.py", line 102, in run
result = function()
sqlite3.OperationalError: no such table: node_descriptors_v8
I read the documentation for ZHA here Zigbee Home Automation - Home Assistant and attempted to run the command to clear the modem manager on my MX Linux host
sudo apt-get purge modemmanager
I rebooted HA after doing that but still see the error. I’m not finding anything on Google for that particular error. Is there something I’m doing wrong here?