# Es 7.0.0 use ssl can't connect with sql
**URL:** https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540
**Category:** Elasticsearch
**Created:** [May 24, 2019, 2:33am UTC](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540 "2019-05-24T02:33:58Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@zqc0512](https://discuss.elastic.co/u/zqc0512)
#### Post date: [May 24, 2019, 2:33am UTC](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540/1 "2019-05-24T02:33:59Z")
the error is
```
[es@xxxx elasticsearch-7]$ ./bin/elasticsearch-sql-cli https://elastic:Axxxx@xxxxx:19200
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
ERROR: Cannot communicate with the server https://elastic:xxxx@xxxxx:19200. This version of CLI only works with Elasticsearch version v7.0.0 [b7e28a7]
```
the es log is
`[2019-05-24T10:31:40,046][WARN][o.e.x.s.t.n.SecurityNetty4HttpServerTransport] [node-1] http client did not trust this server's certificate, closing connection Netty4HttpChannel{localAddress=0.0.0.0/0.0.0.0:19200, remoteAddress=/xxxxx:35242}`
---
### Author:  [@zqc0512](https://discuss.elastic.co/u/zqc0512)
#### Post date: [May 24, 2019, 3:02am UTC](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540/2 "2019-05-24T03:02:45Z")
like this need import cert into java
(PS: ES7 use openjdk12 under es directory)
> **[escline/InstallCert](https://github.com/escline/InstallCert)**
>
> Java program to retrieve server certificate that can be added to local keystore - escline/InstallCert
need copy the file jssecacerts in to jdk directory $ESHOME/jdk/lib/security/jssecacerts
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 21, 2019, 3:02am UTC](https://discuss.elastic.co/t/es-7-0-0-use-ssl-cant-connect-with-sql/182540/3 "2019-06-21T03:02:45Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.