j66321 opened a new issue #9228: Superset could not link to Elasticsearch database with account/password URL: https://github.com/apache/incubator-superset/issues/9228 A clear and concise description of what the bug is. ### Expected results With elasticsearch+https://10.0.30.44/ and extra parameter connect to Elasticsearch database. The database should be connect. ### Actual results `superset_1 | DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: elasticsearch+https://10.0.30.44/ superset_1 | DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): 10.0.30.44:9200 superset_1 | WARNING:elasticsearch:POST https://10.0.30.44:9200/_sql/ [status:N/A request:0.017s] superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | superset_1 | During handling of the above exception, another exception occurred: superset_1 | superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/elasticsearch/connection/http_urllib3.py", line 243, in perform_request superset_1 | method, url, body, retries=Retry(False), headers=request_headers, **kw superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 720, in urlopen superset_1 | method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/retry.py", line 376, in increment superset_1 | raise six.reraise(type(error), error, _stacktrace) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/packages/six.py", line 734, in reraise superset_1 | raise value.with_traceback(tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | DEBUG:elasticsearch:> {"query":"SELECT 1"} superset_1 | DEBUG:urllib3.connectionpool:Starting new HTTPS connection (2): 10.0.30.44:9200 superset_1 | WARNING:elasticsearch:POST https://10.0.30.44:9200/_sql/ [status:N/A request:0.013s] superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | superset_1 | During handling of the above exception, another exception occurred: superset_1 | superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/elasticsearch/connection/http_urllib3.py", line 243, in perform_request superset_1 | method, url, body, retries=Retry(False), headers=request_headers, **kw superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 720, in urlopen superset_1 | method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/retry.py", line 376, in increment superset_1 | raise six.reraise(type(error), error, _stacktrace) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/packages/six.py", line 734, in reraise superset_1 | raise value.with_traceback(tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | DEBUG:elasticsearch:> {"query":"SELECT 1"} superset_1 | DEBUG:urllib3.connectionpool:Starting new HTTPS connection (3): 10.0.30.44:9200 superset_1 | WARNING:elasticsearch:POST https://10.0.30.44:9200/_sql/ [status:N/A request:0.013s] superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | superset_1 | During handling of the above exception, another exception occurred: superset_1 | superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/elasticsearch/connection/http_urllib3.py", line 243, in perform_request superset_1 | method, url, body, retries=Retry(False), headers=request_headers, **kw superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 720, in urlopen superset_1 | method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/retry.py", line 376, in increment superset_1 | raise six.reraise(type(error), error, _stacktrace) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/packages/six.py", line 734, in reraise superset_1 | raise value.with_traceback(tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | DEBUG:elasticsearch:> {"query":"SELECT 1"} superset_1 | DEBUG:urllib3.connectionpool:Starting new HTTPS connection (4): 10.0.30.44:9200 superset_1 | WARNING:elasticsearch:POST https://10.0.30.44:9200/_sql/ [status:N/A request:0.013s] superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | superset_1 | During handling of the above exception, another exception occurred: superset_1 | superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/elasticsearch/connection/http_urllib3.py", line 243, in perform_request superset_1 | method, url, body, retries=Retry(False), headers=request_headers, **kw superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 720, in urlopen superset_1 | method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/retry.py", line 376, in increment superset_1 | raise six.reraise(type(error), error, _stacktrace) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/packages/six.py", line 734, in reraise superset_1 | raise value.with_traceback(tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen superset_1 | chunked=chunked, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request superset_1 | self._validate_conn(conn) superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn superset_1 | conn.connect() superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/connection.py", line 359, in connect superset_1 | ssl_context=context, superset_1 | File "/usr/local/lib/python3.6/site-packages/urllib3/util/ssl_.py", line 383, in ssl_wrap_socket superset_1 | return context.wrap_socket(sock) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 407, in wrap_socket superset_1 | _context=self, _session=session) superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 817, in __init__ superset_1 | self.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 1077, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | File "/usr/local/lib/python3.6/ssl.py", line 689, in do_handshake superset_1 | self._sslobj.do_handshake() superset_1 | urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | DEBUG:elasticsearch:> {"query":"SELECT 1"} superset_1 | WARNING:superset.views.core:Connection failed (es.exceptions.OperationalError) Error connecting to https://10.0.30.44:9200: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852) superset_1 | [SQL: SELECT 1] superset_1 | (Background on this error at: http://sqlalche.me/e/e3q8) superset_1 | 10.0.100.102 - - [03/Mar/2020 06:07:10] "POST /superset/testconn HTTP/1.1" 400 - superset_1 | INFO:werkzeug:10.0.100.102 - - [03/Mar/2020 06:07:10] "POST /superset/testconn HTTP/1.1" 400 - superset_1 | 127.0.0.1 - - [03/Mar/2020 06:07:31] "GET /health HTTP/1.1" 200 - superset_1 | INFO:werkzeug:127.0.0.1 - - [03/Mar/2020 06:07:31] "GET /health HTTP/1.1" 200 - superset_1 | 127.0.0.1 - - [03/Mar/2020 06:08:01] "GET /health HTTP/1.1" 200 - superset_1 | INFO:werkzeug:127.0.0.1 - - [03/Mar/2020 06:08:01] "GET /health HTTP/1.1" 200 - ` #### How to reproduce the bug We're using docker to run superset. And the originally issue was https connect failed(just like above log.) Found that our certification from elasticsearch have wrong information cause the superset validate fail. So we're tend to use https with account/password Is there any suggest or paramater we could use to run https without certification but with password. ### Environment - docker engine : 19.03.6 - superset version : Version: 0.999.0dev - python version : 2.7.5 - Extra Parameter : { "metadata_params": {}, "metadata_cache_timeout": {}, "schemas_allowed_for_csv_upload": [], "engine_params": { "connect_args":{ "port":"9200", "http_auth":"admin:1qaz@WSX3edc", "use_ssl":"True", "verify_certs":"False", "ssl_show_warn":"False" } } } ### Additional context Add any other context about the problem here.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
