You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/03/03 06:10:38 UTC
[GitHub] [incubator-superset] j66321 opened a new issue #9228: Superset
could not link to Elasticsearch database with account/password
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #9228: Superset could not link to Elasticsearch database with account/password
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9228:
URL: https://github.com/apache/incubator-superset/issues/9228#issuecomment-622742173
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org