19

I have searched enough on the web but did not find the solution.

Is there a remote GUI client for Elastic Search server just like Oracle SQL Developer in order to see the schema & other details of the remote elastic db.

Currently I am using the elastic head plugin

enter image description here

It doesn't let me connect to the remote elastic cluster. It only works if the elastic server is hosted in the same machine. I also added the below entries to elastic.yml file but doesn't works. Says no connection to the remote host.

#http.cors.enable: true
#http.cors.allow-origin: "remotehosturl:9200"
underdog
  • 4,447
  • 9
  • 44
  • 89

3 Answers3

17

You need to remove the # character in front your two lines, as that comments out the line and thus has no effect.

Also the correct settings for CORS is named http.cors.enabled not http.cors.enable

So you should include these two lines:

http.cors.enabled: true
http.cors.allow-origin: "remotehosturl:9200"

Also you have the choice with other plugins, such as Marvel, Kopf or the Sense Chrome plugin (soon available as a Kibana-powered standalone tool)

Val
  • 207,596
  • 13
  • 358
  • 360
  • tried everything but for some reason still it doesn't work. I am trying to connect the same url with sense chrome plugin. It works fine. – underdog Nov 13 '15 at 07:25
  • Can you comment out the `allow_origin` line (i.e. add the `#` character at the beginning of the line) and see if it works? If not, can you replace the value simply with `*`? – Val Nov 13 '15 at 07:37
5

Dejavu is a MIT-licensed modern alternative to Elasticsearch Head, I am one of the contributors to the project.

You can use it as a remote web app, a chrome extension or as a docker image.

It supports:

  • Excel like UI for CRUD operations - including ability to view and add mappings from GUI,
  • Visual filters,
  • Ability to import CSV / JSON files directly,
  • Query views,
  • Export data in CSV / JSON formats.

When using it in a remote mode, you will have to set the Elasticsearch config to allow CORS from the origin where dejavu's app is running.

You can read more about the project at https://github.com/appbaseio/dejavu.

siddharthlatest
  • 2,237
  • 1
  • 20
  • 24
2

Marvel's sense is official GUI client for elasticsearch maintained by elastic.It is now even free to use in production with ES release 2.0. Sense query user interface has intellisense hooked with it which is very usefull when writing complex queries and offer lot of other metrics about cluster health, CPU load, memory(build on top of kibana).I prefer sense over head.It is worth taking a look atleast.

You have to install this plugin on your remote server. Installation- https://www.elastic.co/downloads/marvel

user3775217
  • 4,675
  • 1
  • 22
  • 33