Creating kibana Index using Elassandra and Sentinl

[sawdyj]

My project is using Elassandra alongside Kibana to visualise our data. I'm trying to use sentinl as a plugin for Kibana to allow us to report and alert on events. Using Elasticsearch and Kibana separately works perfectly fine but when using a clear Elassandra, Kibana errors on an indexing issue.

I raised the following on the Sentinl page but I thought there might also be some help on here.
sentinl/sentinl#650

The issue is found as soon as I make a kibana index on my data. Please see the below log.
If anyone has seen this issue before I would appreciate some help or guidance on the index mapping issue. Many thanks!

I am using Kibana and Elassandra 6.2.3.

I get the following log
C:\kibana-6.2.3-windows-x86_64\bin>kibana.bat
log [14:48:01.265] [info][status][plugin:[email protected]] Status changed from uninitialized to gree
n - Ready
log [14:48:01.345] [info][status][plugin:[email protected]] Status changed from uninitialized
to yellow - Waiting for Elasticsearch
log [14:48:01.351] [info][status][plugin:[email protected]] Status changed from uninitialized to gre
en - Ready
log [14:48:01.359] [info][status][plugin:[email protected]] Status changed from uninitialized to gre
en - Ready
log [14:48:01.366] [info][status][plugin:[email protected]] Status changed from uninitialized to gre
en - Ready
log [14:48:02.191] [info][status][plugin:[email protected]] Status changed from uninitialized to gr
een - Ready
log [14:48:02.228] [info][listening] Server running at http://localhost:5601
log [14:48:02.366] [info][status][plugin:[email protected]] Status changed from yellow to gree
n - Ready
log [14:48:02.371] [info][Sentinl][init] initializing ...
log [14:48:02.436] [info][Sentinl][init] Chrome bin found at: C:\kibana-6.2.3-windows-x86_64\plu
gins\sentinl\node_modules\puppeteer.local-chromium\linux-564778\chrome-linux\chrome
log [14:48:02.493] [info][Sentinl][init_indices] checking .kibana index ...
log [14:48:02.871] [info][Sentinl][init_indices] creating .kibana index ...
log [14:48:03.652] [error][Sentinl][init] start: Error: init indices: Error: create index: [i_o_
exception] Unknown type _kibana.doc_sentinl-watcher_input :: {"path":"/.kibana","query":{},"body":"{
"mappings":{"doc":{"properties":{"sentinl-watcher":{"properties":{"wizard":{"type":"o
bject","enabled":false},"input":{"type":"object","enabled":false},"actions":{"type":
"object","enabled":false},"transform":{"type":"object","enabled":false},"condition":{"
type":"object","enabled":false},"trigger":{"type":"object","enabled":false},"report":
{"type":"boolean"},"disable":{"type":"boolean"},"save_payload":{"type":"boolean"},"
impersonate":{"type":"boolean"},"spy":{"type":"boolean"},"title":{"type":"text"},"
username":{"type":"text"},"sentinl":{"type":"object","enabled":false},"dashboard_link
":{"type":"text"},"custom":{"type":"object","enabled":false}}},"sentinl-user":{"prope
rties":{"username":{"type":"text"},"sha":{"type":"text"},"password":{"type":"text
"}}}}}}}","statusCode":500,"response":"{"error":{"root_cause":[{"type":"i_o_exception","rea
son":"Unknown type _kibana.doc_sentinl-watcher_input"}],"type":"i_o_exception","reason":"U
nknown type _kibana.doc_sentinl-watcher_input","caused_by":{"type":"invalid_request_exception
","reason":"Unknown type _kibana.doc_sentinl-watcher_input"}},"status":500}"}
log [14:48:04.071] [info][Sentinl][init] PhantomJS bin found at: C:\kibana-6.2.3-windows-x86_64
plugins\sentinl\phantomjs\phantomjs-2.1.1-windows\bin\phantomjs.exe
error [14:58:32.943] [i_o_exception] Unknown type _kibana.doc_sentinl-watcher_input :: {"path":"/
.kibana/doc/index-pattern%3Ab82b0340-0467-11e9-b401-e956cf8b6277","query":{"refresh":"wait_for"},"bo
dy":"{"type":"index-pattern","updated_at":"2018-12-20T14:58:32.948Z","index-pattern":{"ti
tle":"observable*","timeFieldName":"timestamp"}}","statusCode":500,"response":"{"error":{"
root_cause":[{"type":"i_o_exception","reason":"Unknown type _kibana.doc_sentinl-watcher_inpu
t"}],"type":"i_o_exception","reason":"Unknown type _kibana.doc_sentinl-watcher_input","cau
sed_by":{"type":"invalid_request_exception","reason":"Unknown type _kibana.doc_sentinl-watch
er_input"}},"status":500}"}
at respond (C:\kibana-6.2.3-windows-x86_64\node_modules\elasticsearch\src\lib\transport.js:295:1
5)
at checkRespForFailure (C:\kibana-6.2.3-windows-x86_64\node_modules\elasticsearch\src\lib\transp
ort.js:254:7)
at HttpConnector. (C:\kibana-6.2.3-windows-x86_64\node_modules\elasticsearch\src\lib
connectors\http.js:159:7)
at IncomingMessage.bound (C:\kibana-6.2.3-windows-x86_64\node_modules\elasticsearch\node_modules
\lodash\dist\lodash.js:729:21)
at emitNone (events.js:91:20)
at IncomingMessage.emit (events.js:185:7)
at endReadableNT (_stream_readable.js:974:12)
at _combinedTickCallback (internal/process/next_tick.js:80:11)
at process._tickDomainCallback (internal/process/next_tick.js:128:9)

[vroyer]

The dash in doc_sentinl-watcher_input is not supported by cassandra.
Normally, it should be converted to doc_sentinl_watcher_input automatically.
How do you create it ?
What's your elassandra version 6.2.3.x ?
Thanks.

[sawdyj]

Sorry for my late response. I am running elassandra 6.2.3.5 with Kibana 6.2.3.
The sentinl watcher seems to get created automatically when I try to create an index within kibana as this is when it crashes. I'm unsure why the - is not converted.