Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() #120

Closed
willh-cmyk opened this issue Oct 3, 2019 · 1 comment
Closed

APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() #120

willh-cmyk opened this issue Oct 3, 2019 · 1 comment

Comments

@willh-cmyk
Copy link

Please answer these questions before submitting your issue. Thanks!

  1. What version of Python are you using (python --version)?
    Python 3

  2. What operating system and processor architecture are you using (python -c 'import platform; print(platform.platform())')?
    Windows-10-10.0.18362-SP0

  3. What are the component versions in the environment (pip list)?

# Name                    Version                   Build  Channel
asn1crypto                1.0.0                    py37_0    conda-forge
azure-common              1.1.23                   pypi_0    pypi
azure-storage-blob        2.1.0                    pypi_0    pypi
azure-storage-common      2.1.0                    pypi_0    pypi
backcall                  0.1.0                    py37_0
blas                      1.0                         mkl
boto3                     1.9.241                    py_0    conda-forge
botocore                  1.12.241                   py_0    conda-forge
ca-certificates           2019.9.11            hecc5488_0    conda-forge
certifi                   2019.9.11                py37_0
cffi                      1.12.3           py37hb32ad35_0    conda-forge
chardet                   3.0.4                    pypi_0    pypi
colorama                  0.4.1                    py37_0
cryptography              2.7              py37hb32ad35_0    conda-forge
cycler                    0.10.0                   py37_0
decorator                 4.4.0                    py37_1
docutils                  0.15.2                   py37_0    conda-forge
freetype                  2.9.1                ha9979f8_1
future                    0.17.1                   pypi_0    pypi
icc_rt                    2019.0.0             h0cc432a_1
icu                       58.2                 ha66f8fd_1
idna                      2.8                      pypi_0    pypi
ijson                     2.5.1                    pypi_0    pypi
intel-openmp              2019.4                      245
ipykernel                 5.1.2            py37h39e3cac_0
ipython                   7.8.0            py37h39e3cac_0
ipython_genutils          0.2.0                    py37_0
jedi                      0.15.1                   py37_0
jmespath                  0.9.4                      py_0    conda-forge
jpeg                      9b                   hb83a4c4_2
jupyter_client            5.3.3                    py37_1
jupyter_core              4.5.0                      py_0
kiwisolver                1.1.0            py37ha925a31_0
libpng                    1.6.37               h2a8f88b_0
libsodium                 1.0.16               h9d3ae62_0
matplotlib                3.1.1            py37hc8f65d3_0
mkl                       2019.4                      245
mkl-service               2.3.0            py37hb782905_0
mkl_fft                   1.0.14           py37h14836fe_0
mkl_random                1.1.0            py37h675688f_0
numpy                     1.16.5           py37h19fb1c0_0
numpy-base                1.16.5           py37hc3f5095_0
openssl                   1.1.1c               hfa6e2cd_0    conda-forge
oscrypto                  0.19.1                   pypi_0    pypi
pandas                    0.25.1           py37ha925a31_0
parso                     0.5.1                      py_0
patsy                     0.5.1                    py37_0
pickleshare               0.7.5                    py37_0
pip                       19.2.3                   py37_0
prompt_toolkit            2.0.9                    py37_0
pyarrow                   0.14.0                   pypi_0    pypi
pycparser                 2.19                     pypi_0    pypi
pycryptodomex             3.9.0                    pypi_0    pypi
pygments                  2.4.2                      py_0
pyjwt                     1.7.1                    pypi_0    pypi
pyopenssl                 19.0.0                   pypi_0    pypi
pyparsing                 2.4.2                      py_0
pyqt                      5.9.2            py37h6538335_2
pysocks                   1.7.1                    py37_0    conda-forge
python                    3.7.4                h5263a28_0
python-dateutil           2.8.0                    py37_0
pytz                      2019.2                     py_0
pywin32                   223              py37hfa6e2cd_1
pyzmq                     18.1.0           py37ha925a31_0
qt                        5.9.7            vc14h73c81de_0
requests                  2.22.0                   pypi_0    pypi
s3transfer                0.2.1                    py37_0    conda-forge
scipy                     1.3.1            py37h29ff71c_0
seaborn                   0.9.0                    py37_0
setuptools                41.2.0                   py37_0
sip                       4.19.8           py37h6538335_0
six                       1.12.0                   py37_0
snowflake-connector-python 2.0.0                    pypi_0    pypi
snowflake-sqlalchemy      1.1.15                   pypi_0    pypi
sqlalchemy                1.3.8            py37hfa6e2cd_0    conda-forge
sqlite                    3.29.0               he774522_0
statsmodels               0.10.1           py37h8c2d366_0
tornado                   6.0.3            py37he774522_0
traitlets                 4.3.2                    py37_0
urllib3                   1.25.6                   py37_0    conda-forge
vc                        14.1                 h0510ff6_4
vs2015_runtime            14.16.27012          hf0eaf9b_0
wcwidth                   0.1.7                    py37_0
wheel                     0.33.6                   py37_0
win_inet_pton             1.1.0                    py37_0    conda-forge
wincertstore              0.2                      py37_0
zeromq                    4.3.1                h33f27b4_3
zlib                      1.2.11               h62dcd97_3
  1. What did you do?
    If possible, provide a recipe for reproducing the error.
    A complete runnable program is good.
from sqlalchemy import create_engine
from snowflake.sqlalchemy import URL
import pandas as pd
import snowflake.connector

ctx = snowflake.connector.connect(
    user='<your_user_name>',
    password='<your_password>',
    account='<your_account_name>'
    )

I also tried

from sqlalchemy import create_engine

engine = create_engine(
    'snowflake://{user}:{password}@{account}/'.format(
        user='<your_user_login_name>',
        password='<your_password>',
        account='<your_account_name>',
    )
)
try:
    connection = engine.connect()
    results = connection.execute('select current_version()').fetchone()
    print(results[0])
finally:
    connection.close()
    engine.dispose()

  1. What did you expect to see?
    I expected to see the snowflake version.

  2. What did you see instead?

---------------------------------------------------------------------------
APIException                              Traceback (most recent call last)
~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in validate_by_direct_connection(self, issuer, subject, telemetry_data, hostname, do_retry)
   1130             try:
-> 1131                 self.process_ocsp_response(issuer, cert_id, ocsp_response)
   1132                 err = None

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py in process_ocsp_response(self, issuer, cert_id, ocsp_response)
    279             ocsp_cert,
--> 280             tbs_response_data)
    281 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py in verify_signature(self, signature_algorithm, signature, cert, data)
    315     def verify_signature(self, signature_algorithm, signature, cert, data):
--> 316         pubkey = cert.public_key.unwrap().dump()
    317         rsakey = RSA.importKey(pubkey)

~\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py in unwrap(self)
   1064         raise APIException(
-> 1065             'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
   1066             'please use oscrypto.asymmetric.PublicKey().unwrap() instead')

APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

AttributeError                            Traceback (most recent call last)
~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in _request_exec(self, session, method, full_url, headers, data, token, catch_okta_unauthorized_error, is_raw_text, is_raw_binary, binary_data_handler, socket_timeout)
    789                 stream=is_raw_binary,
--> 790                 auth=SnowflakeAuth(token),
    791             )

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    464         send_kwargs.update(settings)
--> 465         resp = self.send(prep, **send_kwargs)
    466 

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py in send(self, request, **kwargs)
    572         # Send the request
--> 573         r = adapter.send(request, **kwargs)
    574 

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    369                     retries=self.max_retries,
--> 370                     timeout=timeout
    371                 )

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py in _validate_conn(self, conn)
    760         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 761             conn.connect()
    762 

~\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py in connect(self)
    237                                     server_hostname=hostname,
--> 238                                     ssl_version=resolved_ssl_version)
    239 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py in ssl_wrap_socket_with_ocsp(sock, keyfile, certfile, cert_reqs, ca_certs, server_hostname, ssl_version)
    394             use_fail_open=FEATURE_OCSP_MODE == OCSPMode.FAIL_OPEN
--> 395         ).validate(server_hostname, ret.connection)
    396         if not v:

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in validate(self, hostname, connection, no_exception)
    995 
--> 996         return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
    997 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in _validate(self, hostname, cert_data, telemetry_data, do_retry, no_exception)
   1001         results = self._validate_certificates_sequential(
-> 1002             cert_data, telemetry_data, hostname, do_retry=do_retry)
   1003 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in _validate_certificates_sequential(self, cert_data, telemetry_data, hostname, do_retry)
   1183             r = self.validate_by_direct_connection(
-> 1184                 issuer, subject, telemetry_data, hostname, do_retry=do_retry)
   1185             results.append(r)

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in validate_by_direct_connection(self, issuer, subject, telemetry_data, hostname, do_retry)
   1152             telemetry_data.set_error_msg(str(ex))
-> 1153             err = self.verify_fail_open(ex, telemetry_data)
   1154             SnowflakeOCSP.OCSP_CACHE.delete_cache(self, cert_id)

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py in verify_fail_open(self, ex_obj, telemetry_data)
   1165         else:
-> 1166             if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
   1167                 logger.debug(telemetry_data.generate_telemetry_data("RevokedCertificateError", True))

AttributeError: 'APIException' object has no attribute 'errno'

During handling of the above exception, another exception occurred:

RetryRequest                              Traceback (most recent call last)
~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in _request_exec_wrapper(self, session, method, full_url, headers, data, retry_ctx, no_retry, token, **kwargs)
    639                 token=token,
--> 640                 **kwargs)
    641             if return_object is not None:

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in _request_exec(self, session, method, full_url, headers, data, token, catch_okta_unauthorized_error, is_raw_text, is_raw_binary, binary_data_handler, socket_timeout)
    882                 exc_info=True)
--> 883             raise RetryRequest(err)
    884         except Exception as err:

RetryRequest: 'APIException' object has no attribute 'errno'

During handling of the above exception, another exception occurred:

OperationalError                          Traceback (most recent call last)
<ipython-input-14-1e172c53a212> in <module>
      4     user=sf_credentials["user"],
      5     password=sf_credentials["password"],
----> 6     role=sf_credentials["role"]
      7 )
      8 cs = ctx.cursor()

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\__init__.py in Connect(**kwargs)
     31 
     32 def Connect(**kwargs):
---> 33     return SnowflakeConnection(**kwargs)
     34 
     35 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\connection.py in __init__(self, **kwargs)
    185 
    186         self.converter = None
--> 187         self.connect(**kwargs)
    188         self._telemetry = TelemetryClient(self._rest)
    189         self.telemetry_enabled = False

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\connection.py in connect(self, **kwargs)
    482 
    483         self.__set_error_attributes()
--> 484         self.__open_connection()
    485 
    486     def close(self):

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\connection.py in __open_connection(self)
    698         if not auth.read_temporary_credential(
    699                 self.account, self.user, self._session_parameters):
--> 700             self.__authenticate(auth_instance)
    701         else:
    702             # set the current objects as the session is derived from the id

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\connection.py in __authenticate(self, auth_instance)
    929             mfa_callback=self._mfa_callback,
    930             password_callback=self._password_callback,
--> 931             session_parameters=self._session_parameters,
    932         )
    933 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\auth.py in authenticate(self, auth_instance, account, user, database, schema, warehouse, role, passcode, passcode_in_password, mfa_callback, password_callback, session_parameters, timeout)
    195                 url, headers, json.dumps(body),
    196                 timeout=self._rest._connection.login_timeout,
--> 197                 socket_timeout=self._rest._connection.login_timeout)
    198         except ForbiddenError as err:
    199             # HTTP 403

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in _post_request(self, url, headers, body, token, timeout, _no_results, no_retry, socket_timeout, _include_retry_params)
    519                          timeout=timeout, token=token,
    520                          no_retry=no_retry, socket_timeout=socket_timeout,
--> 521                          _include_retry_params=_include_retry_params)
    522         logger.debug(
    523             u'ret[code] = {code}, after post request'.format(

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in fetch(self, method, full_url, headers, data, timeout, **kwargs)
    598                 ret = self._request_exec_wrapper(
    599                     session, method, full_url, headers, data, retry_ctx,
--> 600                     **kwargs)
    601                 if ret is not None:
    602                     return ret

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in _request_exec_wrapper(self, session, method, full_url, headers, data, retry_ctx, no_retry, token, **kwargs)
    681                     else:
    682                         self.handle_invalid_certificate_error(
--> 683                             conn, full_url, cause)
    684                     return {}  # required for tests
    685             sleeping_time = retry_ctx.next_sleep()

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py in handle_invalid_certificate_error(self, conn, full_url, cause)
    711                 u'msg': u'Failed to execute request: {0}'.format(
    712                     cause),
--> 713                 u'errno': ER_FAILED_TO_REQUEST,
    714             })
    715 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\errors.py in errorhandler_wrapper(connection, cursor, errorclass, errorvalue)
     98             return
     99         elif connection is not None:
--> 100             connection.errorhandler(connection, cursor, errorclass, errorvalue)
    101             return
    102 

~\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\errors.py in default_errorhandler(connection, cursor, errorclass, errorvalue)
     71             sqlstate=errorvalue.get(u'sqlstate'),
     72             sfqid=errorvalue.get(u'sfqid'),
---> 73             done_format_msg=errorvalue.get(u'done_format_msg'))
     74 
     75     @staticmethod

OperationalError: 250003: Failed to execute request: 'APIException' object has no attribute 'errno'
  1. Can you set logging to DEBUG and collect the logs?
2019-10-03 14:40:48,273 - MainThread connection.py:178 - __init__() - INFO - Snowflake Connector for Python Version: 2.0.0, Python Version: 3.7.4, Platform: Windows-10-10.0.18362-SP0
2019-10-03 14:40:48,275 - MainThread connection.py:478 - connect() - DEBUG - connect
2019-10-03 14:40:48,275 - MainThread connection.py:715 - __config() - DEBUG - __config
2019-10-03 14:40:48,276 - MainThread connection.py:790 - __config() - INFO - This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2019-10-03 14:40:48,277 - MainThread converter.py:140 - __init__() - DEBUG - use_numpy: False
2019-10-03 14:40:48,278 - MainThread converter_issue23517.py:27 - __init__() - DEBUG - initialized
2019-10-03 14:40:48,279 - MainThread connection.py:641 - __open_connection() - DEBUG - REST API object was created: datalytyx.east-us-2.azure.snowflakecomputing.com:443
2019-10-03 14:40:48,279 - MainThread auth.py:129 - authenticate() - DEBUG - authenticate
2019-10-03 14:40:48,280 - MainThread auth.py:153 - authenticate() - DEBUG - assertion content: *********
2019-10-03 14:40:48,281 - MainThread auth.py:165 - authenticate() - DEBUG - account=datalytyx, user=WILLHOLTAM, database=None, schema=None, warehouse=None, role=DATABRICKS, request_id=694f6a53-445a-4d86-8bac-f4e3a57164d8
2019-10-03 14:40:48,282 - MainThread auth.py:191 - authenticate() - DEBUG - body['data']: {'CLIENT_APP_ID': 'PythonConnector', 'CLIENT_APP_VERSION': '2.0.0', 'SVN_REVISION': None, 'ACCOUNT_NAME': 'datalytyx', 'LOGIN_NAME': 'WILLHOLTAM', 'CLIENT_ENVIRONMENT': {'APPLICATION': 'PythonConnector', 'OS': 'Windows', 'OS_VERSION': 'Windows-10-10.0.18362-SP0', 'PYTHON_VERSION': '3.7.4', 'PYTHON_RUNTIME': 'CPython', 'PYTHON_COMPILER': 'MSC v.1915 64 bit (AMD64)', 'OCSP_MODE': 'FAIL_OPEN'}, 'SESSION_PARAMETERS': {'CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY': 900, 'CLIENT_PREFETCH_THREADS': 4}}
2019-10-03 14:40:48,283 - MainThread retry.py:155 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None)
2019-10-03 14:40:48,283 - MainThread retry.py:155 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None)
2019-10-03 14:40:48,285 - MainThread network.py:928 - _use_requests_session() - DEBUG - Active requests sessions: 1, idle: 0
2019-10-03 14:40:48,286 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 120, retry cnt: 1
2019-10-03 14:40:48,287 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:40:48,290 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (1): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:49,246 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:40:49,247 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:49,248 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:40:49,248 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:40:49,249 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:40:49,250 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:40:49,251 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:49,252 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:49,253 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:40:49,255 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:49,257 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:49,258 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:49,260 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:49,262 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:49,264 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:49,265 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:40:49,267 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:40:49,268 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:40:49,270 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:40:49,271 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:40:49,273 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=1, sleeping=2(s)
2019-10-03 14:40:51,273 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 118, retry cnt: 2
2019-10-03 14:40:51,274 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:40:51,275 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (2): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:51,573 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:40:51,574 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:51,574 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:40:51,575 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:40:51,575 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:40:51,576 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:40:51,577 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:51,577 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:51,579 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:40:51,581 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:51,585 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:51,587 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:51,589 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:51,590 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:51,592 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:51,593 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:40:51,594 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:40:51,595 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:40:51,595 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:40:51,596 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:40:51,600 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=2, sleeping=2(s)
2019-10-03 14:40:53,601 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 116, retry cnt: 3
2019-10-03 14:40:53,602 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:40:53,605 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (3): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:53,906 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:40:53,906 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:53,907 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:40:53,907 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:40:53,909 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:40:53,910 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:40:53,910 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:53,911 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:53,913 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:40:53,915 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:53,916 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:53,921 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:53,923 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:53,924 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:53,926 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:53,928 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:40:53,929 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:40:53,930 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:40:53,930 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:40:53,931 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:40:53,934 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=3, sleeping=1(s)
2019-10-03 14:40:54,936 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 115, retry cnt: 4
2019-10-03 14:40:54,936 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:40:54,939 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (4): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:55,234 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:40:55,235 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:55,236 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:40:55,238 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:40:55,239 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:40:55,239 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:40:55,240 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:55,241 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:55,243 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:40:55,246 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:55,248 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:55,251 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:55,254 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:55,257 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:55,259 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:55,260 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:40:55,261 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:40:55,262 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:40:55,263 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:40:55,265 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:40:55,268 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=4, sleeping=3(s)
2019-10-03 14:40:58,269 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 112, retry cnt: 5
2019-10-03 14:40:58,269 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:40:58,271 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (5): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:58,574 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:40:58,576 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:58,576 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:40:58,577 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:40:58,578 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:40:58,579 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:40:58,580 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:40:58,581 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:40:58,582 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:40:58,585 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:58,587 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:58,588 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:40:58,590 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:58,592 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:40:58,593 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:40:58,595 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:40:58,596 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:40:58,596 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:40:58,597 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:40:58,597 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:40:58,601 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=5, sleeping=7(s)
2019-10-03 14:41:05,602 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 105, retry cnt: 6
2019-10-03 14:41:05,604 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:41:05,607 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (6): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:05,911 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:41:05,912 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:05,912 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:41:05,913 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:41:05,913 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:41:05,914 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:41:05,914 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:05,916 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:05,918 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:41:05,923 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:05,924 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:05,925 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:05,927 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:05,928 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:05,929 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:05,931 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:41:05,933 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:41:05,934 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:41:05,934 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:41:05,935 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:41:05,937 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=6, sleeping=8(s)
2019-10-03 14:41:13,938 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 97, retry cnt: 7
2019-10-03 14:41:13,940 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:41:13,943 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (7): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:14,247 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:41:14,247 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:14,248 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:41:14,248 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:41:14,249 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:41:14,249 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:41:14,250 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:14,250 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:14,252 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:41:14,254 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:14,257 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:14,259 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:14,261 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:14,263 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:14,264 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:14,266 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:41:14,266 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:41:14,267 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:41:14,267 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:41:14,268 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:41:14,271 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=7, sleeping=10(s)
2019-10-03 14:41:24,271 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 87, retry cnt: 8
2019-10-03 14:41:24,273 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:41:24,277 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (8): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:24,583 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:41:24,584 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:24,585 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:41:24,586 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:41:24,587 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:41:24,587 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:41:24,588 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:24,589 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:24,591 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:41:24,593 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:24,595 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:24,599 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:24,601 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:24,603 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:24,604 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:24,606 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:41:24,607 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:41:24,607 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:41:24,608 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:41:24,608 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:41:24,611 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=8, sleeping=16(s)
2019-10-03 14:41:40,611 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 71, retry cnt: 9
2019-10-03 14:41:40,612 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:41:40,614 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (9): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:40,918 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:41:40,920 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:40,921 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:41:40,921 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:41:40,922 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:41:40,923 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:41:40,923 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:40,924 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:40,927 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:41:40,929 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:40,931 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:40,933 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:40,935 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:40,937 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:40,939 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:40,941 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:41:40,942 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:41:40,942 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:41:40,943 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:41:40,944 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:41:40,947 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=9, sleeping=16(s)
2019-10-03 14:41:56,947 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 55, retry cnt: 10
2019-10-03 14:41:56,948 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:41:56,951 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (10): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:57,248 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:41:57,249 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:57,250 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:41:57,251 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:41:57,252 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:41:57,254 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:41:57,254 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:41:57,260 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:41:57,262 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:41:57,264 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:57,267 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:57,271 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:41:57,274 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:57,277 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:41:57,280 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:41:57,282 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:41:57,284 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:41:57,284 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:41:57,285 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:41:57,286 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:41:57,289 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=10, sleeping=7(s)
2019-10-03 14:42:04,291 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 48, retry cnt: 11
2019-10-03 14:42:04,292 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:42:04,294 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (11): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:04,590 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:42:04,590 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:04,591 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:42:04,592 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:42:04,592 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:42:04,593 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:42:04,595 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:04,596 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:04,597 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:42:04,600 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:04,608 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:04,611 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:04,613 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:04,616 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:04,619 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:04,622 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:42:04,624 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:42:04,624 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:42:04,625 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:42:04,626 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:42:04,632 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=11, sleeping=16(s)
2019-10-03 14:42:20,634 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 32, retry cnt: 12
2019-10-03 14:42:20,634 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:42:20,636 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (12): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:20,942 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:42:20,942 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:20,943 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:42:20,943 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:42:20,944 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:42:20,944 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:42:20,945 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:20,947 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:20,948 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:42:20,950 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:20,951 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:20,955 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:20,956 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:20,959 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:20,960 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:20,963 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:42:20,964 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:42:20,965 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:42:20,965 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:42:20,966 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:42:20,969 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=12, sleeping=16(s)
2019-10-03 14:42:36,970 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 16, retry cnt: 13
2019-10-03 14:42:36,971 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:42:36,973 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (13): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:37,275 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:42:37,276 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:37,277 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:42:37,277 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:42:37,278 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:42:37,279 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:42:37,279 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:37,280 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:37,282 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:42:37,283 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:37,284 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:37,286 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:37,289 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:37,292 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:37,293 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:37,295 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:42:37,296 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:42:37,297 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:42:37,297 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:42:37,298 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:42:37,301 - MainThread network.py:694 - _request_exec_wrapper() - DEBUG - retrying: errorclass=<class 'AttributeError'>, error='APIException' object has no attribute 'errno', counter=13, sleeping=16(s)
2019-10-03 14:42:53,301 - MainThread network.py:627 - _request_exec_wrapper() - DEBUG - remaining request timeout: 0, retry cnt: 14
2019-10-03 14:42:53,303 - MainThread network.py:766 - _request_exec() - DEBUG - socket timeout: 60
2019-10-03 14:42:53,305 - MainThread connectionpool.py:735 - _new_conn() - INFO - Starting new HTTPS connection (14): datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:53,638 - MainThread ssl_wrap_socket.py:390 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2019-10-03 14:42:53,638 - MainThread ocsp_snowflake.py:422 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file://C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:53,639 - MainThread ocsp_snowflake.py:424 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 69
2019-10-03 14:42:53,639 - MainThread ocsp_snowflake.py:218 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2019-10-03 14:42:53,641 - MainThread ocsp_snowflake.py:252 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2019-10-03 14:42:53,642 - MainThread ocsp_snowflake.py:568 - check_ocsp_response_cache_lock_dir() - DEBUG - Failed to check OCSP response cache file. No worry. It will validate with OCSP server: file: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json, lock directory: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json.lck, error: [WinError 2] The system cannot find the file specified: 'C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json'
2019-10-03 14:42:53,643 - MainThread ocsp_snowflake.py:465 - read_ocsp_response_cache_file() - DEBUG - Failed to locate OCSP response cache file. No worry. It will validate with OCSP server: C:/Users/WilliamHoltam/AppData/Local/Snowflake/Caches/ocsp_response_cache.json
2019-10-03 14:42:53,644 - MainThread ocsp_snowflake.py:972 - validate() - DEBUG - validating certificate: datalytyx.east-us-2.azure.snowflakecomputing.com
2019-10-03 14:42:53,645 - MainThread ocsp_asn1crypto.py:340 - extract_certificate_chain() - DEBUG - # of certificates: 2
2019-10-03 14:42:53,647 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:53,649 - MainThread ocsp_asn1crypto.py:347 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:53,650 - MainThread ocsp_asn1crypto.py:369 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2019-10-03 14:42:53,653 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:53,656 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert SHA2 Secure Server CA')])
2019-10-03 14:42:53,658 - MainThread ocsp_snowflake.py:588 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Computing, Inc.'), ('organizational_unit_name', 'Snowflake Computing'), ('common_name', '*.east-us-2.azure.snowflakecomputing.com')])
2019-10-03 14:42:53,659 - MainThread ocsp_snowflake.py:1124 - validate_by_direct_connection() - DEBUG - using OCSP response cache
2019-10-03 14:42:53,660 - MainThread ocsp_asn1crypto.py:269 - process_ocsp_response() - DEBUG - Certificate is NOT attached in Basic OCSP Response. Using issuer's certificate
2019-10-03 14:42:53,661 - MainThread ocsp_asn1crypto.py:275 - process_ocsp_response() - DEBUG - Verifying the OCSP response is signed by the issuer.
2019-10-03 14:42:53,661 - MainThread ocsp_snowflake.py:1151 - validate_by_direct_connection() - DEBUG - OCSP Validation failed asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead
2019-10-03 14:42:53,662 - MainThread network.py:882 - _request_exec() - DEBUG - Hit retryable client error. Retrying... Ignore the following error stack: 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'
2019-10-03 14:42:53,664 - MainThread network.py:666 - _request_exec_wrapper() - ERROR - 'APIException' object has no attribute 'errno'
Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1131, in validate_by_direct_connection
    self.process_ocsp_response(issuer, cert_id, ocsp_response)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 280, in process_ocsp_response
    tbs_response_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_asn1crypto.py", line 316, in verify_signature
    pubkey = cert.public_key.unwrap().dump()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\asn1crypto\keys.py", line 1065, in unwrap
    'asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, '
asn1crypto._errors.APIException: asn1crypto.keys.PublicKeyInfo().unwrap() has been removed, please use oscrypto.asymmetric.PublicKey().unwrap() instead

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 790, in _request_exec
    auth=SnowflakeAuth(token),
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 465, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\sessions.py", line 573, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\adapters.py", line 370, in send
    timeout=timeout
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 544, in urlopen
    body=body, headers=headers)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 341, in _make_request
    self._validate_conn(conn)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connectionpool.py", line 761, in _validate_conn
    conn.connect()
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\botocore\vendored\requests\packages\urllib3\connection.py", line 238, in connect
    ssl_version=resolved_ssl_version)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ssl_wrap_socket.py", line 395, in ssl_wrap_socket_with_ocsp
    ).validate(server_hostname, ret.connection)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 996, in validate
    return self._validate(hostname, cert_data, telemetry_data, do_retry, no_exception)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1002, in _validate
    cert_data, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1184, in _validate_certificates_sequential
    issuer, subject, telemetry_data, hostname, do_retry=do_retry)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1153, in validate_by_direct_connection
    err = self.verify_fail_open(ex, telemetry_data)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\ocsp_snowflake.py", line 1166, in verify_fail_open
    if ex_obj.errno is ER_SERVER_CERTIFICATE_REVOKED:
AttributeError: 'APIException' object has no attribute 'errno'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 640, in _request_exec_wrapper
    **kwargs)
  File "C:\Users\WilliamHoltam\Miniconda3\envs\palladium\lib\site-packages\snowflake\connector\network.py", line 883, in _request_exec
    raise RetryRequest(err)
snowflake.connector.network.RetryRequest: 'APIException' object has no attribute 'errno'
2019-10-03 14:42:53,668 - MainThread network.py:941 - _use_requests_session() - DEBUG - Active requests sessions: 0, idle: 1
@smtakeda
Copy link
Contributor

smtakeda commented Oct 3, 2019

Duplicates snowflakedb/snowflake-connector-python#209

We'll release 2.0.1 including the patch.

Thanks for reporting the issue anyway.

@smtakeda smtakeda closed this as completed Oct 3, 2019
@LoicChesneau LoicChesneau mentioned this issue Sep 15, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@smtakeda @willh-cmyk