Incorrect source in elasticsearch-sql-cli

[alpar-t]

One can't start the tool from any working directory.

Here's a reproduction

# create a test cluster
./gradlew run
cd distribution/build/testclusters/runTask-0
ES_CONFIG_PATH=$PWD/config ./distro/8.0.0-DEFAULT/bin/elasticsearch-sql-cli
# Fails with : ./distro/8.0.0-DEFAULT/bin/elasticsearch-sql-cli: line 9: ./distro/8.0.0-DEFAULT/bin/x-pack-env: No such file or directory
cd distro/8.0.0-DEFAULT
ES_CONFIG_PATH=$PWD/../../config ./bin/elasticsearch-sql-cli
# works

The reason for this is that source "dirname "$0""/elasticsearch-env changes the working directory to $ES_HOME so I think the second source should just be

source ./bin/x-pack-env

Would be nice to add some packaging tests to qa/os to make sure the tool can be called from different places.

[elasticmachine]

Pinging @elastic/es-search (:Search/SQL)

[q2dg]

If it's called inside "home" folder (that is, if it was installed from deb/rpm packages, when called inside "/usr/share/elasticsearch" folder), it works by just writing ./bin/elasticsearch-sql-cli

[annirathore]

I am getting below error during run ./bin/elasticsearch-sql-cli

WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
ERROR: Cannot communicate with the server http://localhost:9200/. This version of CLI only works with Elasticsearch version v7.5.1 [3ae9ac9]

[bpintea]

ERROR: Cannot communicate with the server http://localhost:9200/. This version of CLI only works with Elasticsearch version v7.5.1 [3ae9ac9]

@annirathore you will find usage help on the discussion forum: discuss.elastic.co.

[elasticmachine]

Pinging @elastic/es-core-infra (:Core/Infra/Build)