# SQL Access is missing in X-pack

**URL:** <https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [July 6, 2018, 2:13pm UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933 "2018-07-06T14:13:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![wrahmouni](https://avatars.discourse-cdn.com/v4/letter/w/e0b2c6/32.png) [@wrahmouni](https://discuss.elastic.co/u/wrahmouni)\
**Post date:** [July 6, 2018, 2:13pm UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/1 "2018-07-06T14:13:19Z")

</div>

Hi,  
After installing elasticsearch, I wanted to use the functionalities provided by SQL access, but unfortunately I could enable it. I'm using the basic license. When I want to run this instruction in kibana  
POST /\_xpack/sql?format=txt  
{  
"query": "SELECT \* FROM w7\_log "  
}

I get this error

{  
"error": {  
"root\_cause": [  
{  
"type": "invalid\_index\_name\_exception",  
"reason": "Invalid index name [_xpack], must not start with '_', '-', or '+'",  
"index\_uuid": "_na_",  
"index": "\_xpack"  
}  
],  
"type": "invalid\_index\_name\_exception",  
"reason": "Invalid index name [_xpack], must not start with '_', '-', or '+'",  
"index\_uuid": "_na_",  
"index": "\_xpack"  
},  
"status": 400  
}

I tried to add this setting "xpack.sql.enabled: true"into the elasticsearch.yml but I figured out that elasticsearch didn't start at all complaining that this setting doesn't exist.  
This is also to mention that I installed the x-pack plugin separately and I still face the same issues.

I'm looking forward to your reply and your help.  
Best regards,

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [July 6, 2018, 3:06pm UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/2 "2018-07-06T15:06:11Z")

</div>

Are you running Elasticsearch 6.3?

---

<div class="post-metadata">

**Author:** ![wrahmouni](https://avatars.discourse-cdn.com/v4/letter/w/e0b2c6/32.png) [@wrahmouni](https://discuss.elastic.co/u/wrahmouni)\
**Post date:** [July 9, 2018, 11:18am UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/3 "2018-07-09T11:18:04Z")

</div>

I was on an older version that's why it didn't work. Thanks for your support 🙂

---

<div class="post-metadata">

**Author:** ![AcepcsMa](https://avatars.discourse-cdn.com/v4/letter/a/bc8723/32.png) [@AcepcsMa](https://discuss.elastic.co/u/AcepcsMa)\
**Post date:** [July 11, 2018, 3:37am UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/4 "2018-07-11T03:37:18Z")

</div>

I think you'd better upgrade your es to 6.3

---

<div class="post-metadata">

**Author:** ![wrahmouni](https://avatars.discourse-cdn.com/v4/letter/w/e0b2c6/32.png) [@wrahmouni](https://discuss.elastic.co/u/wrahmouni)\
**Post date:** [July 11, 2018, 7:54am UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/5 "2018-07-11T07:54:10Z")

</div>

Done and it works. Thank you.

---

<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:** [August 8, 2018, 7:54am UTC](https://discuss.elastic.co/t/sql-access-is-missing-in-x-pack/138933/6 "2018-08-08T07:54:12Z")

</div>

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