Issue Summary
I’ve installed the connector and enabled the query runner, but I can’t connect.
Technical details:
- Redash Version: 5.0.0
- Browser/OS: Chrome on Mac
- How did you install Redash:
- Docker-compose on Mac, with the
docker-compose.production.yml
configuration. - Built a local Docker Image called
redash:with_snowflake
. I uncommented the Snowflake connector in therequirements_all_ds.txt
file. - Updated
docker-compose.production.yml
to (a) use my custom local image, and (b) set theREDASH_ADDITIONAL_QUERY_RUNNERS
environment variable on both the server and the worker.
- Docker-compose on Mac, with the
Issue Detail
When I put in my connection credentials and test my connection, it can’t connect, and outputs this:
server_1 | [2018-10-10 20:34:44,043][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTPS connection (1): <my snowflake instance>.snowflakecomputing.com
server_1 | [2018-10-10 20:34:44,214][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1 | [2018-10-10 20:34:44,218][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1 | [2018-10-10 20:34:44,221][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.netsolssl.com
server_1 | [2018-10-10 20:34:44,268][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
[~300 repeated messages]
server_1 | [2018-10-10 20:34:47,721][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1 | [2018-10-10 20:34:47,745][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1 | Exception in thread RequestExec-0:
server_1 | Traceback (most recent call last):
server_1 | File "/usr/lib/python2.7/threading.py", line 801, in __bootstrap_inner
server_1 | self.run()
server_1 | File "/usr/lib/python2.7/threading.py", line 754, in run
server_1 | self.__target(*self.__args, **self.__kwargs)
server_1 | File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/network.py", line 704, in request_exec
server_1 | auth=SnowflakeAuth(token),
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/sessions.py", line 465, in request
server_1 | resp = self.send(prep, **send_kwargs)
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/sessions.py", line 573, in send
server_1 | r = adapter.send(request, **kwargs)
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/adapters.py", line 370, in send
server_1 | timeout=timeout
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 544, in urlopen
server_1 | body=body, headers=headers)
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 341, in _make_request
server_1 | self._validate_conn(conn)
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 761, in _validate_conn
server_1 | conn.connect()
server_1 | File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connection.py", line 238, in connect
server_1 | ssl_version=resolved_ssl_version)
server_1 | File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/ssl_wrap_socket.py", line 483, in ssl_wrap_socket_with_ocsp
server_1 | ).validate(server_hostname, ret.connection)
server_1 | File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/ocsp_pyopenssl.py", line 1103, in validate
server_1 | u'hostname={0}, err={1}', hostname, r.get()))
server_1 | File "/usr/lib/python2.7/multiprocessing/pool.py", line 567, in get
server_1 | raise self._value
server_1 | PyAsn1Error: Attempted "__eq__" operation on ASN.1 schema object
server_1 |