superset 连接时遇到的坑

1. 错误1 连接es时出现如下错误:

Traceback (most recent call last):File "/usr/local/lib/python3.7/site-packages/elasticsearch/connection/http_urllib3.py", line 252, in perform_requestmethod, url, body, retries=Retry(False), headers=request_headers, **kwFile "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 756, in urlopenmethod, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2]File "/usr/local/lib/python3.7/site-packages/urllib3/util/retry.py", line 507, in incrementraise six.reraise(type(error), error, _stacktrace)File "/usr/local/lib/python3.7/site-packages/urllib3/packages/six.py", line 734, in reraiseraise value.with_traceback(tb)File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 706, in urlopenchunked=chunked,File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 382, in _make_requestself._validate_conn(conn)File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 1010, in _validate_connconn.connect()File "/usr/local/lib/python3.7/site-packages/urllib3/connection.py", line 421, in connecttls_in_tls=tls_in_tls,File "/usr/local/lib/python3.7/site-packages/urllib3/util/ssl_.py", line 432, in ssl_wrap_socketssl_sock = _ssl_wrap_socket_impl(sock, context, tls_in_tls)File "/usr/local/lib/python3.7/site-packages/urllib3/util/ssl_.py", line 474, in _ssl_wrap_socket_implreturn ssl_context.wrap_socket(sock)File "/usr/local/lib/python3.7/ssl.py", line 423, in wrap_socketsession=sessionFile "/usr/local/lib/python3.7/ssl.py", line 870, in _createself.do_handshake()File "/usr/local/lib/python3.7/ssl.py", line 1139, in do_handshakeself._sslobj.do_handshake()
urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1091)
DEBUG:elasticsearch:> {"query":"SELECT 1","fetch_size":10000}

解决办法

需要添加 verify_certs=False 参数, url 示例

elasticsearch+http://<user>:<password>@<host>:9200/?verify_certs=False

2. 错误2 连接mysql出现乱码

解决办法

#在连接时加上上编码
charset=utf8

3. 错误三 连接mysql mysqlclient 下载失败

解决办法

pip3 install pymysql
#最后使用的是pymysql 依赖, 使用pymysql 进行
mysql+pymysql://username:password@ip:3306/database?charset=utf8