Hi all,
Im having issues with getting data from my index, using elasticsearch-sql-cli:
/usr/share/elasticsearch/bin/elasticsearch-sql-cli https://elastic:my-password@elastic.local:9200
ERROR: Cannot communicate with the server https://my-password@elastic.local
[2020-09-09T17:01:33,597][WARN ][o.e.x.s.t.n.SecurityNetty4HttpServerTransport] [ELK-SVR] http client did not trust this server's certificate,
closing connection Netty4HttpChannel{localAddress=/172.16.10.38:9200, remoteAddress=/172.16.10.38:53496}
Below is my es.yml config for XPACK:
#---------------------------------- XPACK -----------------------------------
xpack.security.enabled: true
xpack.security.http.ssl.enabled: true
xpack.security.transport.ssl.enabled: true
xpack.security.http.ssl.key: certs/elastic.key
xpack.security.http.ssl.certificate: certs/elastic.crt
xpack.security.http.ssl.certificate_authorities: certs/ca.crt
xpack.security.transport.ssl.key: certs/elastic.key
xpack.security.transport.ssl.certificate: certs/elastic.crt
xpack.security.transport.ssl.certificate_authorities: certs/ca.crt
Cant seem to figured this one out. Grateful for any help received.