# How logstash parse sqlite data to json file

**URL:** <https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162>\
**Category:** Logstash\
**Created:** [November 26, 2018, 11:17am UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162 "2018-11-26T11:17:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![T\_Putra\_Safrul\_Huda](https://avatars.discourse-cdn.com/v4/letter/t/a87d85/32.png) [@T\_Putra\_Safrul\_Huda](https://discuss.elastic.co/u/T_Putra_Safrul_Huda)\
**Post date:** [November 26, 2018, 11:17am UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/1 "2018-11-26T11:17:23Z")

</div>

my purpose is using elasticsearch for sqlite data analysis and i am use logstash for parse sqlite to json format, i not understand how setting that, can you help me

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 26, 2018, 12:18pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/2 "2018-11-26T12:18:29Z")

</div>

What is your question?

---

<div class="post-metadata">

**Author:** ![T\_Putra\_Safrul\_Huda](https://avatars.discourse-cdn.com/v4/letter/t/a87d85/32.png) [@T\_Putra\_Safrul\_Huda](https://discuss.elastic.co/u/T_Putra_Safrul_Huda)\
**Post date:** [November 26, 2018, 12:35pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/3 "2018-11-26T12:35:54Z")

</div>

sorry my language it so bad, my question is, how dionaea.sqlite log parse to .json with logstash filter, i want to analysis dionaea log to elasticsearch, are you know how configure that ?

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 26, 2018, 12:54pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/4 "2018-11-26T12:54:22Z")

</div>

Set up the config like here:

[https://www.elastic.co/guide/en/logstash/current/plugins-inputs-sqlite.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-sqlite.html)

---

<div class="post-metadata">

**Author:** ![T\_Putra\_Safrul\_Huda](https://avatars.discourse-cdn.com/v4/letter/t/a87d85/32.png) [@T\_Putra\_Safrul\_Huda](https://discuss.elastic.co/u/T_Putra_Safrul_Huda)\
**Post date:** [November 26, 2018, 1:15pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/5 "2018-11-26T13:15:52Z")

</div>

if input use filebeat send log dionaea.sqlite to logstash, do i still use plugin-input-sqlite too?

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 26, 2018, 1:16pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/6 "2018-11-26T13:16:42Z")

</div>

No you can use one or the other

---

<div class="post-metadata">

**Author:** ![T\_Putra\_Safrul\_Huda](https://avatars.discourse-cdn.com/v4/letter/t/a87d85/32.png) [@T\_Putra\_Safrul\_Huda](https://discuss.elastic.co/u/T_Putra_Safrul_Huda)\
**Post date:** [November 26, 2018, 1:35pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/7 "2018-11-26T13:35:41Z")

</div>

thank you so much for this answer:slightly\_smiling\_face:

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 24, 2018, 1:39pm UTC](https://discuss.elastic.co/t/how-logstash-parse-sqlite-data-to-json-file/158162/8 "2018-12-24T13:39:39Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.