I’m facing an OCSP error when trying to connect to...
# troubleshoot
l
I’m facing an OCSP error when trying to connect to snowflake. I have verified: • Snowflake network policy has IP added from datahub • port 80 and 443 are opened Below is a snippet of my error log. Any ideas?
Copy code
{datahub.cli.ingest_cli:120} - Starting metadata ingestion\n'
           '[2022-12-20 14:39:38,569] ERROR    {snowflake.connector.ocsp_snowflake:1490} - Failed to get OCSP response after 1 attempt. Consider '
           'checking for OCSP URLs being blocked\n'
           '[2022-12-20 14:39:38,570] ERROR    {snowflake.connector.ocsp_snowflake:1065} - WARNING!!! Using fail-open to connect. Driver is '
           'connecting to an HTTPS endpoint without OCSP based Certificate Revocation checking as it could not obtain a valid OCSP Response to use '
           'from the CA OCSP responder. Details: \n'
           " {'driver': 'PythonConnector', 'version': '2.9.0', 'eventType': 'RevocationCheckFailure', 'eventSubType': "
           "'OCSPResponseFailedToConnectCacheServer|OCSPResponseFetchFailure', 'sfcPeerHost':
❄️ 1
h
Hey @lemon-lock-89160 While we are debugging this, you can use insecure_mode to turn of OCSP checking temporarily.
Copy code
connect_args:
    insecure_mode: True
The logs message looks incomplete. can you share the complete details ? It looks like the source is not able to connect to OCSP cache server.
l
Thanks for your input @hundreds-photographer-13496 I’ll investigate further