You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Matt Prast (JIRA)" <ji...@apache.org> on 2016/05/04 17:56:12 UTC
[jira] [Created] (AIRFLOW-48) can't pass extra parameters via a
connection URI when using environment variables (and therefore can't tell
Postgres to use SSL)
Matt Prast created AIRFLOW-48:
---------------------------------
Summary: 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
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
(v6.3.4#6332)