xiaomi gateway

[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?

[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?

[waltervl]

You can look in the hardware table directly with db browser. That table should not be that big.

[remko2000]

thx, found it!