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

[Jose_H]

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.