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)

Reply via email to