Repository navigation
SSLError bad handshake #221
Description
Getting the following error when trying to connect to our warehouse:
from databricks import sql
your_token = '<token>'
connection = sql.connect(
server_hostname="<>cloud.databricks.com",
http_path="/sql/1.0/warehouses/<>",
access_token=your_token
)
MaxRetryError: HTTPSConnectionPool(host='<>.cloud.databricks.com', port=443): Max retries exceeded with url: /sql/1.0/warehouses/<> (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')])")))
We have tried:
connection = sql.connect(
server_hostname="<>.cloud.databricks.com",
http_path="/sql/1.0/warehouses/<>",
access_token=your_token,
_tls_no_verify=True)
and
connection = sql.connect(
server_hostname="<>.cloud.databricks.com",
http_path="/sql/1.0/warehouses/<>",
access_token=your_token,
_enable_ssl=False)
Activity
sokojh commentedon Sep 18, 2023
Can you tell what environment your Python script is running in?
If it's running on mac local, then you're experiencing the same environment problem as me.
Luckily, I was able to resolve this issue.
Cause:
Apparently python installed on a local mac sometimes doesn't come with an SSL certificate (I'm not sure).
Solution:
Go to your MAC terminal
/Applications/Python\ {local python version e.g: 3.11}/Install\ Certificates.commandEnter the command and wait for it to install.
Then try running the script again, it works!
susodapop commentedon Sep 18, 2023
Ditto @sokojh's comment. Depending on how you installed python on your mac, you can also find the
Install Certificates.commandwithin thePython 3.xdirectory in your/Applicationsfolder.dbarrundia-tiger commentedon Sep 20, 2023
Thanks @susodapop this is not on a Mac unfortunately, it's on a Windows machine. Any ideas on what to do with that? Thanks so much!
dbarrundia-tiger commentedon Sep 20, 2023
@susodapop also wouldn't
_tls_no_verifyand_enable_sslhelp us here?kravets-levko commentedon Oct 2, 2024
@dbarrundia-tiger Were you able to figure out your issue?
_tls_no_verifywould just disable cert verification, so use it carefully (e.g. I wouldn't recommend to use it in production). Also plese note that due to bug,_tls_no_verifywas ignored in some cases, so please try latest version of the library if it seems to be your case.deeksha-db commentedon Feb 27, 2025
@dbarrundia-tiger Can you confirm if this is resolved on your side? This doesn't seem to be an issue with the connector?