This repository was archived by the owner on Aug 19, 2025. It is now read-only.
Repository navigation
This repository was archived by the owner on Aug 19, 2025. It is now read-only.
SSL handshake failed #537
Description
Activity
Hi @nitanmarcel,
Based on the information in your question, I believe you are using Django ORM (correct me if I'm wrong).
I would suggest using SQLAlchemy for many, some of it is described in the following article https://djangostars.com/blog/merging-django-orm-with-sqlalchemy-for-easier-data-analysis/First of all, you need to create a global variable with Engine.
create_engineaccepts additional configuration for connection, which needs to be used in that case.You can prepare the database string as the following example:
db_connect_string='mysql://<user>:<pswd>@<db server>:3306/<database>'After that SSL certificates along with engine creation could be defined as it's listed below:
ssl_args = { "sslrootcert": "server-ca.pem", "sslcert": "client-cert.pem", "sslkey": "client-key.pem" } create_engine(db_connect_string, connect_args=ssl_args)
I'm trying to connect to planetscale's mysql database, but I can't get the connection working.
They offer a snippet of code, on how to connect to them using different programming languages.
For example in python:
I have no idea where to pass the ca thing. My database string is the following:
mysql://8jdabgcbksmalfucug29:************@eu-central.connect.psdb.cloud/default?ssl=trueThere's a similar string for nodejs, in their documentation similar to mine:
mysql://8jdabgcbksmalfucug29:************@eu-central.connect.psdb.cloud/default?ssl={"rejectUnauthorized":true}