Page 1 of 1

xiaomi gateway

Posted: Friday 15 December 2023 19:50
by remko2000
I am doing a clean install of domoticz. I also want to add my xiaomi gateway again. In my old Domoticz environment it is also operational, but unfortunately I cannot copy the password in the web environment. I therefore placed a copy of my old database (db) on my mac, but how do I retrieve the password from it via db browser? Or is there a smarter way?

Re: xiaomi gateway

Posted: Sunday 17 December 2023 14:06
by remko2000
If I search in db domoticz by DB browser with SQL :

Code: Select all

SELECT Name, Password
FROM Hardware
WHERE Name="Xiaomi Gateway";
I get:
Uitvoering voltooid zonder fouten.
Resultaat: 0 records geretourneerd in 11ms
In regel 1:
SELECT Name, Password
FROM Hardware
WHERE Name="Xiaomi Gateway";
Is my searchcode not right?

Re: xiaomi gateway

Posted: Sunday 17 December 2023 23:28
by waltervl
You can look in the hardware table directly with db browser. That table should not be that big.

Re: xiaomi gateway

Posted: Friday 22 December 2023 17:13
by remko2000
thx, found it!