airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRFLOW-48) can't pass extra parameters via a connection URI when using environment variables (and therefore can't tell Postgres to use SSL)
Date Wed, 16 May 2018 08:54:00 GMT

    [ https://issues.apache.org/jira/browse/AIRFLOW-48?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16477090#comment-16477090
] 

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
(v7.6.3#76005)

Mime
View raw message