[Bug]: elasticsearch database query error

[rty813]

Short description of current behavior

Elasticsearch database query error.

Video or screenshots

Expected behavior

query successful

How to reproduce the error

1. add elasticsearch database by sql.
2. click "es" from sidebar.

Anything else?

I checked the source code and found two issues.

1. If it starts with 7... then you should use http_auth=("username", "password") instead of basic_auth=.... The basic_auth=... parameter was only added in v8.0.0.

The version of the Elasticsearch Python library installed in the container is 7.13.4, but in this version, "basic_auth" should be changed to "http_auth". Ref

mindsdb/mindsdb/integrations/handlers/elasticsearch_handler/elasticsearch_handler.py

Line 77 in 48f7699

basic_auth=(self.connection_data['username'], self.connection_data['password'])

2. The connect() function returns a StatusResponse instead of an Elasticsearch client.
   

   mindsdb/mindsdb/integrations/handlers/elasticsearch_handler/elasticsearch_handler.py

   Line 63 in 48f7699

   def connect(self) -> StatusResponse:

   
   

   mindsdb/mindsdb/integrations/handlers/elasticsearch_handler/elasticsearch_handler.py

   Lines 138 to 141 in 48f7699

   	connection = self.connect()
   	try:
   	response = connection.sql.query(body={'query': query})

[ZoranPandovski]

@rty813 Thanks for reporting. Let's migrate to the latest Elastic client version