ASF subversion and git services commented on AIRFLOW-48:

Commit b17a99d714310cd05577a6d1b3b4baa101aec674 in incubator-airflow's branch 
refs/heads/master from inytar
[ https://git-wip-us.apache.org/repos/asf?p=incubator-airflow.git;h=b17a99d ]

[AIRFLOW-48] Parse connection uri querystring

Closes #3292 from inytar/extras-in-uri

> 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
> 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