How to connect local kibana with AWS elasticsearch, what should be the settings in kibana.yml?

[Vijay_Gupta]

Hello,
I have an elasticsearch instance on AWS, below are the sample details of the same.

 amazon_es{
    hosts => "https://search-vijay-test1-uwjuyejkuydjkdukdukkiu.us-east-3.es.amazonaws.com:443"
    ssl => true
    doc_as_upsert => true
    index => "my_index_name"
    sniffing => false
    document_id =>  "%{fingerprint}"
    region => "us-east-3"
    aws_access_key_id => "DRTYYFYIFOFSGVEYEGRA"
    aws_secret_access_key => "sYufMfpfNfEfwf9evqLeQDzRRkK1F4Ewwwwssl2s"
 }

Note: It does not have an username password for elastic, its open and I am able to connect it via python code(pasting python code in comment/reply section as it's crossing 7000 words).

I want to connect this with kibana 7.4 installed on my local machine, what should be setting for kibana.yml , pasting below what I tried in kibana.yml,

# Kibana is served by a back end server. This setting specifies the port to use.
server.port: 5601

# Specifies the address to which the Kibana server will bind. IP addresses and host names are both valid values.
# The default is 'localhost', which usually means remote machines will not be able to connect.
# To allow connections from remote users, set this parameter to a non-loopback address.
server.host: "localhost"

# Enables you to specify a path to mount Kibana at if you are running behind a proxy.
# Use the `server.rewriteBasePath` setting to tell Kibana if it should remove the basePath
# from requests it receives, and to prevent a deprecation warning at startup.
# This setting cannot end in a slash.
#server.basePath: ""

# Specifies whether Kibana should rewrite requests that are prefixed with
# `server.basePath` or require that they are rewritten by your reverse proxy.
# This setting was effectively always `false` before Kibana 6.3 and will
# default to `true` starting in Kibana 7.0.
#server.rewriteBasePath: false

# The maximum payload size in bytes for incoming server requests.
#server.maxPayloadBytes: 1048576

# The Kibana server's name.  This is used for display purposes.
#server.name: "your-hostname"

# The URLs of the Elasticsearch instances to use for all your queries.
elasticsearch.hosts: ["https://search-vijay-test1-uwjuyejkuydjkdukdukkiu.us-east-3.es.amazonaws.com:443"]

# When this setting's value is true Kibana uses the hostname specified in the server.host
# setting. When the value of this setting is false, Kibana uses the hostname of the host
# that connects to this Kibana instance.
#elasticsearch.preserveHost: true

# Kibana uses an index in Elasticsearch to store saved searches, visualizations and
# dashboards. Kibana creates a new index if the index doesn't already exist.
#kibana.index: ".kibana"

# The default application to load.
#kibana.defaultAppId: "home"

# If your Elasticsearch is protected with basic authentication, these settings provide
# the username and password that the Kibana server uses to perform maintenance on the Kibana
# index at startup. Your Kibana users still need to authenticate with Elasticsearch, which
# is proxied through the Kibana server.
#elasticsearch.username: "kibana"
#elasticsearch.password: "pass"

# Enables SSL and paths to the PEM-format SSL certificate and SSL key files, respectively.
# These settings enable SSL for outgoing requests from the Kibana server to the browser.
#server.ssl.enabled: true
#server.ssl.certificate: /path/to/your/server.crt
#server.ssl.key: /path/to/your/server.key

# Optional settings that provide the paths to the PEM-format SSL certificate and key files.
# These files validate that your Elasticsearch backend uses the same key files.
#elasticsearch.ssl.certificate: /path/to/your/client.crt
#elasticsearch.ssl.key: /path/to/your/client.key

# Optional setting that enables you to specify a path to the PEM file for the certificate
# authority for your Elasticsearch instance.
#elasticsearch.ssl.certificateAuthorities: [ "/path/to/your/CA.pem" ]

# To disregard the validity of SSL certificates, change this setting's value to 'none'.
#elasticsearch.ssl.verificationMode: full

# Time in milliseconds to wait for Elasticsearch to respond to pings. Defaults to the value of
# the elasticsearch.requestTimeout setting.
#elasticsearch.pingTimeout: 1500

# Time in milliseconds to wait for responses from the back end or Elasticsearch. This value
# must be a positive integer.
#elasticsearch.requestTimeout: 30000

# List of Kibana client-side headers to send to Elasticsearch. To send *no* client-side
# headers, set this value to [] (an empty list).
#elasticsearch.requestHeadersWhitelist: [ authorization ]

# Header names and values that are sent to Elasticsearch. Any custom headers cannot be overwritten
# by client-side headers, regardless of the elasticsearch.requestHeadersWhitelist configuration.
#elasticsearch.customHeaders: {}

# Time in milliseconds for Elasticsearch to wait for responses from shards. Set to 0 to disable.
#elasticsearch.shardTimeout: 30000

# Time in milliseconds to wait for Elasticsearch at Kibana startup before retrying.
#elasticsearch.startupTimeout: 5000

# Logs queries sent to Elasticsearch. Requires logging.verbose set to true.
#elasticsearch.logQueries: false

# Specifies the path where Kibana creates the process ID file.
#pid.file: /var/run/kibana.pid

# Enables you specify a file where Kibana stores log output.
#logging.dest: stdout

# Set the value of this setting to true to suppress all logging output.
#logging.silent: false

# Set the value of this setting to true to suppress all logging output other than error messages.
#logging.quiet: false

# Set the value of this setting to true to log all events, including system usage information
# and all requests.
#logging.verbose: false

# Set the interval in milliseconds to sample system and process performance
# metrics. Minimum is 100ms. Defaults to 5000.
#ops.interval: 5000

# Specifies locale to be used for all localizable strings, dates and number formats.
# Supported languages are the following: English - en , by default , Chinese - zh-CN .
#i18n.locale: "en"

It gives error of xpack like below when run below command from terminal -
c:\kibana-7.4.0-windows-x86_64>.\bin\kibana.bat

[warning][license][xpack] License information from the X-Pack plugin could not be obtained from Elasticsearch for the [data] cluster. Authentication Exception :: {"path":"/_xpack","statusCode":401,"response":"{\"Message\":\"Your request: '/_xpack' is not allowed.\"}"}

and when I visit - http://localhost:5601/status

It says - "Kibana server is not ready yet"

Can anyone please help with recommended setting to connect AWS ES with Local Kibana??

[Vijay_Gupta]

Python code for reference -

query_string = "Vijay"
index = "my_index_name"
size = 10000
ACCESS_KEY = 'DRTYYFYIFOFSGVEYEGRA'
SECRET_KEY = 'sYufMfpfNfEfwf9evqLeQDzRRkK1F4Ewwwwssl2s'
REGION ='us-east-3'

host = 'search-vijay-test1-uwjuyejkuydjkdukdukkiu.us-east-3.es.amazonaws.com'
awsauth = AWS4Auth(ACCESS_KEY, SECRET_KEY, REGION, 'es')

es = Elasticsearch(
    hosts=[{'host': host, 'port': 443}],
    http_auth=awsauth,
    use_ssl=True,
    verify_certs=True,
    connection_class=RequestsHttpConnection
)

body = {

    "_source": ["dob", "first_name", "mobile_number"], # get only wanted fields
"query": {
       "bool": {
       "should": {"query_string": {"query":query_string,"default_operator": "AND"}}
      }
    }
    }

# Init scroll by search
data = es.search(
    index=index,
    size=size,
    body=json.dumps(body)
)

[azasypkin]

Hey @Vijay_Gupta,

You're trying to run Kibana with X-Pack plugin against AWS Elasticsearch that doesn't support X-Pack. You can try to use OSS Kibana distribution (https://www.elastic.co/downloads/kibana-oss), but I'm not sure if Elasticsearch version distributed by AWS is completely compatible with upstream Elastic Kibana OSS.

Alternatively you can use Elasticsearch and Kibana that are supported and developed by Elastic itself: https://www.elastic.co/cloud/. These should always be compatible and work flawlessly.

Best,
Oleg