It isn’t working for me.
sqlite3 ~/.mozilla-iot/config/db.sqlite3 "SELECT id FROM things"
only returns the IDs of valid things. The timer IDs are all for the newly created timers that work. There are no IDs for the old timers that don’t work and I can’t get rid of.
I tried to do
sqlite3 ~/.mozilla-iot/config/db.sqlite3 "DELETE FROM things WHERE id = 'Leak-state'"
where 'Leak-state'
is the display name of one of the old timers. (The new working timer has a slightly different display name.)
Also, I can’t get rid of the Zigbee device that I removed from the gateway (and removed the battery from the actual device.) I did
sqlite3 ~/.mozilla-iot/config/db.sqlite3 "DELETE FROM things WHERE id = 'zb-8418260000e90e56'"
and restarted the gateway. 'zb-8418260000e90e56'
is the actual id. But it won’t go away. I can remove it on the Things page. But if I go into pair mode by clicking on the “+”, it keeps reappearing.
Just to double check, I’m restarting the gateway like
sudo systemctl restart mozilla-iot-gateway.service
Correct?