spectacles icon indicating copy to clipboard operation
spectacles copied to clipboard

[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1002)

Open May1234 opened this issue 1 year ago • 2 comments

When running spectacles command with Cloudflare WARP turning on, I am getting SSL certificate error. Can someone please give some advice?

spectacles sql --config-file configs/config.yaml --project abc

Connected to Looker version 24.14.35 using Looker API 4.0 Completed SQL validation in .

Encountered unexpected SSLCertVerificationError: "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1002)" Full error traceback logged to file.

For support, please create an issue at https://github.com/spectacles-ci/spectacles/issues

May1234 avatar Oct 07 '24 18:10 May1234

Hi @May1234. Could you confirm that when you don't have Cloudflare WARP on that this works as expected?

I expect there's something incorrect in the SSL certificate in the setup. I believe you would either need to remedy that issue or fork Spectacles to turn off SSL verification.

DylanBaker avatar Oct 10 '24 07:10 DylanBaker

Hi @DylanBaker, thanks for the reply. There is no issue when turning off CloudFlare WARP. I tried many ways to resolve the problem, but all failed. Since I thought Spectacles is python utility, I tried this way as well, but it didn't work. https://developers.cloudflare.com/cloudflare-one/connections/connect-devices/warp/user-side-certificates/install-cloudflare-cert/#python

May1234 avatar Oct 10 '24 13:10 May1234