# Elasticsearch Sql CLI Not working

**URL:** https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589
**Category:** Elasticsearch
**Tags:** elastic-stack-sql
**Created:** [August 27, 2024, 5:52am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589 "2024-08-27T05:52:49Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Debasis\_Mallick](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/debasis_mallick/32/123723_2.png) [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [August 27, 2024, 5:52am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589/1 "2024-08-27T05:52:49Z")

</div>

Hi Team,

I am trying to connect elastic sql through below command but not able to connect.

```auto
[root@cb-1 bin]# ./elasticsearch-sql-cli https://xx.xx.xx.xx:9200
ERROR: Cannot communicate with the server https://xx.xx.xx.xx:9200. This version of CLI only works with Elasticsearch version 8.9.2
[root@cb-1 bin]

```

Below is the JDK version is currently running on my VM.

```auto
[root@cb-1 ~]# java -version
openjdk version "1.8.0_181"
OpenJDK Runtime Environment (build 1.8.0_181-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)
[root@cb-1 ~]#

```

The installed elastic version is as below.

```auto

[root@cb-1 bin]# ./elasticsearch --version
Version: 8.9.2, Build: rpm/e8179018838f55b8820685f92e245abef3bddc0f/2023-08-31T02:43:14.210479707Z, JVM: 20.0.2

```

Thanks,  
Debasis

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [August 27, 2024, 8:27am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589/2 "2024-08-27T08:27:48Z")

</div>

Could you try with the username and password?

```auto
./elasticsearch-sql-cli sql_user:strongpassword@https://xx.xx.xx.xx:9200

```

If it still does not work, could you try with a more recent version? 8.15.0.

---

<div class="post-metadata">

### Author: ![Debasis\_Mallick](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/debasis_mallick/32/123723_2.png) [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [August 28, 2024, 5:31am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589/3 "2024-08-28T05:31:07Z")

</div>

@dadoonet Do we need to create separate user for sql access or any user name can pass in the command line. Is there any issue with elastic version 8.9.2.

Thanks,  
Debasis

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [August 28, 2024, 6:34am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-not-working/365589/4 "2024-08-28T06:34:14Z")

</div>

> [@Debasis\_Mallick](#):
>
> Do we need to create separate user for sql access

I don't think so.

> [@Debasis\_Mallick](#):
>
> Is there any issue with elastic version 8.9.2.

I don't know but I'd try to test on 8.15.