Mailing-List: contact dev-help@airflow.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@airflow.incubator.apache.org
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: SSHHook and multiple connections
From: Alexander Alten-Lorenz <wget.null@gmail.com>
In-Reply-To: <5F358E6E-C8C4-452F-BB44-EB9AA74E326B@gmail.com>
Date: Wed, 6 Jul 2016 12:03:14 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <BA21BDF9-8C8D-4C97-A058-0C85DF237B39@gmail.com>
References: <5F358E6E-C8C4-452F-BB44-EB9AA74E326B@gmail.com>
To: dev@airflow.incubator.apache.org
archived-at: Wed, 06 Jul 2016 10:03:31 -0000

Just solved - the conn_id has to be in ' ', like ssh01 =3D =
SSHHook(conn_id=3D'ssh_01')

Works like a charm,
 --alex

> On Jul 6, 2016, at 11:54 AM, Alexander Alten-Lorenz =
<wget.null@gmail.com> wrote:
>=20
> Good morning,
>=20
> I try to use the SSHExecutors, but struggle with more than one =
connection (conn_id). I have different ssh connections in Airflow =3D> =
Admin =3D> Connections, but when I try to them in my SSH DAG I get (as =
example):
>=20
> name 'ssh_01' is not defined
>=20
> Here's my badly script:
>=20
> from airflow import DAG
> from airflow.operators.bash_operator import BashOperator
> from airflow.contrib.operators import SSHExecuteOperator
> from airflow.contrib.hooks import SSHHook
> from datetime import datetime, time delta
>=20
> default_args =3D {
>    'owner': 'me',
>    'depends_on_past': False,
>    'start_date': datetime(2016, 7, 5),
>    # 'email': ['airflow@airflow.com'],
>    'email_on_failure': False,
>    'email_on_retry': False,
>    'retries': 1,
>    'retry_delay': timedelta(minutes=3D5),
>    # 'queue': 'bash_queue',
>    # 'pool': 'backfill',
>    # 'priority_weight': 10,
>    # 'end_date': datetime(2016, 1, 1),
> }
>=20
> dag =3D DAG('ssh_test', default_args=3Ddefault_args, =
schedule_interval=3D'@weekly')
> ssh01 =3D SSHHook(conn_id=3Dssh_01)
>=20
> # SSH connect
> t1 =3D SSHExecuteOperator(
>        task_id=3D'check_01',
>        ssh_hook =3D ssh01,
>        bash_command=3D"/sbin/initctl list |grep fork-sec2",
>        dag=3Ddag)
>=20
> thanks for any advise,
> --alex
>=20
>=20