Xiaomi Aqara Human Motion Sensor - how to get graph working?

Yoinkz · March 6, 2018, 2:27pm

Will do thanks @vzorglub

Do you know the command to check how large the database is?

… and also, do you export the data to your openhab (basicUI or habPanel)?

When I try to share my graph, I get a link that looks like this:
http://ip:3000/render/d-solo/sOu_M3Zgk/xiaomi-lux-sensors?refresh=1h&orgId=1&panelId=4&from=now-48&to=now&width=1000&height=350&tz=UTC%2B01%3A00

I’m not able to edit it so it works in basicUI - also when using the frame in the habPanel I get the whole graph + the posibility to edit the settings.

vzorglub · March 6, 2018, 4:07pm

I don’t use basic ui.
I use the frame in Habpanel and you can tell grafana to make the dashboard non-editable.
There is also a way to disable clicks on frames with a bit of code in the frame but I haven’t looked into it yet.

vzorglub · March 6, 2018, 4:08pm

I only checked the database size once and I can’t remember the size. I googled it at the time.

Yoinkz · March 6, 2018, 7:33pm

@vzorglub sounds good :).

How does your link look like in habpanel? The one used in the frame?

vzorglub · March 6, 2018, 10:37pm

Yes exactly the same

Yoinkz · March 7, 2018, 11:16am

Okay Seems to be working just fine :).

vzorglub · March 9, 2018, 7:35am

Hi,
To get the size of the influxdb database:

cd /var/lib/influxdb/data
sudo du -sh openhab_db

where /var/lib/influxdb/data is the data directory defined in influxdb.conf.

Mine after 3 month is 4.7M
That’s 20M/Year
But it will depend on how many items you have and how often they are updated of course!

Yoinkz · March 9, 2018, 6:15pm

Yes! Works brilliant!

Haha, then the size doesn’t gonna be a problem on your end