ELK integration

---

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 ?

cheers!

@defcon Another approach is to write a web socket client which listens to update events and writes the necessary data to a log file (JSON records or CSV). See https://pimatic.org/guide/api/

You may also want to have a look at the “IoT Use Case” blog articles written by @SaxnPaule -http://www.bigdata-unleashed.com/20161011/iot-use-case-visualisierung-und-datenauswertung

Maybe you could define some rules, that write attribute changes to a specific logfile via shell-plugin. Then you connect this logfile to Logstash and ship the data to your ES.

Thanks for the answer, i will go for the websocket client

@defcon Another interesting route to follow. Have a look at kibi which is a fork of kibana. One of the great advantages over kibana is that you can directly integrate NoSQL and SQL data sources.