# Es-Sql-Query - http client did not trust this server's certificate

**URL:** https://discuss.elastic.co/t/es-sql-query-http-client-did-not-trust-this-servers-certificate/248019
**Category:** Elasticsearch
**Created:** [September 9, 2020, 1:46pm UTC](https://discuss.elastic.co/t/es-sql-query-http-client-did-not-trust-this-servers-certificate/248019 "2020-09-09T13:46:41Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Jose\_H](https://avatars.discourse-cdn.com/v4/letter/j/e99b99/32.png) [@Jose\_H](https://discuss.elastic.co/u/Jose_H)
#### Post date: [September 9, 2020, 1:46pm UTC](https://discuss.elastic.co/t/es-sql-query-http-client-did-not-trust-this-servers-certificate/248019/1 "2020-09-09T13:46:41Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 7, 2020, 1:46pm UTC](https://discuss.elastic.co/t/es-sql-query-http-client-did-not-trust-this-servers-certificate/248019/2 "2020-10-07T13:46:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.