airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Potiuk (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AIRFLOW-3268) Cannot pass SSL dictionary to mysql connection via URL
Date Mon, 29 Oct 2018 13:41:00 GMT
Jarek Potiuk created AIRFLOW-3268:
-------------------------------------

             Summary: Cannot pass SSL dictionary to mysql connection via URL
                 Key: AIRFLOW-3268
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3268
             Project: Apache Airflow
          Issue Type: Bug
            Reporter: Jarek Potiuk
            Assignee: Jarek Potiuk


It is impossible to pass 'ssl' dictionary to MySql hook as an extra param via URL connection.
While there is a code to pass the 'ssl' extra query parameter, MySqldb requires this parameter
to be dictionary. When you want to create a connection via URL you can at most have ?ssl=
url-encoded string rather than dictionary and this is how it is passed (as string). What happens
then in MySqldb, is that all SSL parameters are ignored and MySQL establishes a non-SSL connection
silently. This is pretty bad. 

I am going to provide a fix soon - I will test if the 'ssl' parameter is string and if so,
I will do json.loads() to build dictionary from the string.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message