How can I connect to elasticsearch through an ssh tunnel?

1

I have setup an ssh tunnel. I know it’s working because I can get results from my elasticsearch cluster via browser.

How can I connect to this through dremio? I tried fudging around with the Java connection settings (https://java.com/en/download/help/proxy_setup.xml) with no success. I keep getting the same “Unable to get host lists from any host seed.” error.

2

This configuration is not quite supported by Dremio: when connecting to an elastic server, Dremio will fetch the list of the servers comprising the cluster and try to directly connect to each of them to parallelize processing as much as possible.

I would advise checking Elastic settings regarding network configuration at https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-network.html#network-interface-values: settings like {{network.publish_host}} and {{http.publish_host}} may help you advertise how to connect to the cluster through your proxy.

3

@laurent does anything in 1.2 help @Chris_Tinnon on this subject?

4

Hi @Chris_Tinnon,

Can you try enabling “Query whitelisted hosts only” under “Advanced Options” and under “Connection Options” enable “SSL enabled connecting to Elasticsearch cluster” and see if you are able to add?

Kindly let me know

Thanks
@balaji.ramaswamy

5

Take a look at these Elasticsearch tutorials .