kibana

elasticsearch / kibana errors “Data too large, data for [@timestamp] would be larger than limit

by

Clearing the cache alleviates the symptoms for now. http://www.elastic.co/guide/en/elasticsearch/reference/current/indices-clearcache.html Clear a single index curl -XPOST ‘http://localhost:9200/twitter/_cache/clear’ Clear multiple indicies curl -XPOST ‘http://localhost:9200/kimchy,elasticsearch/_cache/clear’ curl -XPOST ‘http://localhost:9200/_cache/clear’ Or as suggested by a user in IRC. This one seems to work the best. curl -XPOST ‘http://localhost:9200/_cache/clear’ -d ‘{ “fielddata”: “true” }’ Update: these errors went away as soon … Read more

How to set authentication in kibana

by

Kibana itself doesn’t support authentication or restricting access to dashboards. You can restrict access to Kibana 4 using nginx as a proxy in front of Kibana as described here: https://serverfault.com/a/345244. Just set proxy_pass to port 5601 and disable this port on firewall for others. This will completly enable or disable Kibana. Elastic also has a … Read more

How do I exclude multiple terms in Kibana 4

by

If I understand your question properly, you’re trying to use the “Exclude Pattern” to exclude certain values from populating in the chart. The “Exclude Pattern” and “Include Pattern” fields are for Regular Expressions and are documented here: http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html. If you want to exclude multiple fields, you could do something like this: term1|term2|term3

how to set fielddata=true in kibana

by

In your ES mapping, you need to set fielddata:true in your publisher field: PUT your_index/_mapping/your_type { “your_type”: { “properties”: { “publisher”: { “type”: “text”, “fielddata”: true } } } } You’ll need to reindex your data after making this change, but afterwards Kibana won’t complain anymore. UPDATE You can either execute the above query in … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)