You need to enable JavaScript to run this app. 如何在Open Distro for Elasticsearch中使用elasticsearch-dbapi并忽略SSL证书?
优惠活动
大模型
产品
解决方案
定价
更多

如何在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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.18 18:27:02