I want to integrate pimatic with the ELK stack (Elastic search/logstash/kibana) for visualising sensor data.
The issue i’m having is that in the pimatic-daemon-log there are no descriptions for sensors. Then i tried using the sqlite DB with a view that combines the sensor data and description but i’m not able to follow the DB as i get the message “Error: database is locked”.
I wanted to follow the sqlite DB with a logstash plugin but the plugin can’t query the DB because the pimatic process is locking it (=Error: database is locked). It would be nice if the pimatic logs would include the sensor/switch description or if i could follow the DB.
The view i created is:
create view pimaticlog as
select * from attributeValueNumber left outer join deviceAttribute on attributeValueNumber.deviceAttributeId = deviceAttribute. id
How can i extract this data (realtime) from pimatic ?