Uploaded image for project: 'Apache Airflow'
  1. Apache Airflow
  2. AIRFLOW-3268

Cannot pass SSL dictionary to mysql connection via URL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.10.1
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                potiuk Jarek Potiuk
                Reporter:
                potiuk Jarek Potiuk
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: