如何在Open Distro for Elasticsearch中使用elasticsearch-dbapi并忽略SSL证书?
问题解决说明
运行环境版本
- Open Distro for Elasticsearch 1.13.2
- Python 3.7
- elasticsearch client 7.12.1
- sqlalchemy 1.4.17
- eland 7.10.1b1
可正常运行的参考代码
原生Elasticsearch客户端连接测试:
from elasticsearch import Elasticsearch es = Elasticsearch(['https://admin:admin@localhost:9200/'], use_ssl = True, verify_certs = False, ssl_show_warn = False) res = es.indices.get_alias("*") print(res)
Eland调用测试:
import eland as ed df = ed.DataFrame(es, es_index_pattern = "kibana_sample_data_flights") df
故障排查与修复
1. sqlalchemy自签名证书报错
报错信息:
Error: [('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')]
故障原因:连接字符串没有携带SSL校验配置,默认会验证自签名证书导致失败。
修复后的代码:
# Using sqlalchemy from sqlalchemy.engine import create_engine engine = create_engine( "odelasticsearch+https://admin:admin@localhost:9200/", connect_args={ "use_ssl": True, "verify_certs": False, "ssl_show_warn": False } ) rows = engine.connect().execute( "select Carrier, count(*) from kibana_sample_data_flights GROUP BY Carrier" ) print([row for row in rows])
2. elasticsearch-dbapi连接断开报错
报错信息:
ProtocolError: ('Connection aborted.', RemoteDisconnected ('Remote end closed connection without response'))
故障原因:连接参数未指定HTTPS协议、端口、账号凭证,服务端直接拒绝HTTP请求导致连接断开。
修复后的代码:
# Using elasticsearch-dbapi from es.elastic.api import connect conn = connect( host="localhost", port=9200, http_auth=("admin", "admin"), scheme="https", verify_certs=False, ssl_show_warn=False ) curs = conn.cursor() curs.execute( "select * from kibana_sample_data_flights LIMIT 10" ) print([row for row in curs])
内容的提问来源于stack exchange,提问作者Ruben Diaz
相关产品推荐
相关产品推荐

