Fokko Driesprong resolved AIRFLOW-48.
       Resolution: Fixed
    Fix Version/s: 2.0.0

Issue resolved by pull request #3292

> can't pass extra parameters via a connection URI when using environment 
> variables (and therefore can't tell Postgres to use SSL)
> --------------------------------------------------------------------------------------------------------------------------------
>                 Key: AIRFLOW-48
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-48
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: hooks
>    Affects Versions: Airflow 1.7.0
>         Environment: Ubuntu 14.04.3
>            Reporter: Matt Prast
>            Priority: Major
>             Fix For: 1.10.0, 2.0.0
> We're trying to use a postgres connection to hook into our Redshift backend 
> (which has sslmode set to 'require'). Since we're using chef to deploy we've 
> got the connection string stored in an environment variable, but it looks 
> like the Connection model doesn't parse any connection parameters when it 
> gets initialized with a uri 
> (https://github.com/airbnb/airflow/blob/3c3f5a67ff80f3e8942aef441f481c62baf97184/airflow/models.py#L529).
>  We can't find a way to tell postgres to use SSL without setting sslmode via 
> the connection string, but airflow doesn't seem to allow this, even though 
> you can do it through the UI. Is there something we're missing? Has anybody 
> else run into this using Chef + Postgres + SSL? Thanks for your help!

This message was sent by Atlassian JIRA

Reply via email to