# Elastic SQL CLI Error
**URL:** https://discuss.elastic.co/t/elastic-sql-cli-error/345905
**Category:** Elasticsearch
**Created:** [October 27, 2023, 10:17am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905 "2023-10-27T10:17:35Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [October 27, 2023, 10:17am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/1 "2023-10-27T10:17:35Z")
HI Team,
I am able to connect to Elastic sql CLI but while querying the index data getting below error. Could you please help me on this.
> sql\> select \* from employee;
> Communication error [Cannot POST address [http://10.10.18.174:9200/\_sql?error\_trace](http://10.10.18.174:9200/_sql?error_trace) (Unexpected end of file from server)]
Thanks,
Debasis
---
### Author:  [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [October 30, 2023, 9:50am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/2 "2023-10-30T09:50:25Z")
Hi Team,
Any update on the below request.
Thanks,
Debasis
---
### Author:  [@TimV](https://discuss.elastic.co/u/TimV)
#### Post date: [October 31, 2023, 6:33am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/3 "2023-10-31T06:33:39Z")
Do you have access to `curl` on the same machine?
What does this give you?
```bash
curl http://10.10.18.174:9200/
```
---
### Author:  [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [October 31, 2023, 7:04am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/4 "2023-10-31T07:04:01Z")
@TimV Thanks for response.
We are getting below response while doing curl.
> [root@cb-1 bin]# curl [http://10.10.18.174:9200/](http://10.10.18.174:9200/)
> curl: (52) Empty reply from server
Thanks,
Debasis
---
### Author:  [@TimV](https://discuss.elastic.co/u/TimV)
#### Post date: [November 2, 2023, 3:44am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/5 "2023-11-02T03:44:52Z")
The most likely cause is that your ES server is actually running with TLS and you need
```auto
curl https://10.10.18.174:9200/
```
If that works then you'll need to apply the same config to the SQL CLI
---
### Author:  [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [November 2, 2023, 4:45am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/6 "2023-11-02T04:45:07Z")
Hi @TimV ,
Still we are getting below error related to certificate in Elasticsearch.
> [root@cb-1 bin]# ./elasticsearch-sql-cli [https://elastic:elastic@10.10.18.174:9200](https://elastic:elastic@10.10.18.174:9200) -c -d -v
> sql\>
> | select \* from employee;
> Communication error [Cannot POST address [https://10.10.18.174:9200/\_sql?error\_trace](https://10.10.18.174:9200/_sql?error_trace) (PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target)]
Thanks,
Debasis
---
### Author:  [@TimV](https://discuss.elastic.co/u/TimV)
#### Post date: [November 7, 2023, 4:46am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/7 "2023-11-07T04:46:29Z")
Your Elasticsearch nodes are using a certificate that was issued by a CA that isn't trusted by your JVM.
You'll need to use the `-k` option to provide a keystore (truststore) to the SQL CLI.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 5, 2023, 4:46am UTC](https://discuss.elastic.co/t/elastic-sql-cli-error/345905/8 "2023-12-05T04:46:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.