Re: [sqlalchemy] Airflow > Configuring A SQL Alchemy Connection String To Use Unix Sockets

2017-11-10 Thread Mike Bayer
hi - work with mysqlclient first so you can determine if this is an error: import MySQLdb conn = MySQLdb.connect(user='user', passwd='passwd', db='dbname', unix_socket='/cloudsql/myproject:europe-west1:airflowinstance') cursor = conn.cursor() cursor.execute("select 1") see

[sqlalchemy] Airflow > Configuring A SQL Alchemy Connection String To Use Unix Sockets

2017-11-09 Thread james . lloyd
Hello. I'm using the SQL Cloud Proxy on a Compute engine VM instance. I'm then configuring Airflow (which uses SQL Alchemy). I've setup a unix socket like this: /opt/cloud_sql_proxy/cloud_sql_proxy -instances=myproject:europe-west1:airflowinstance -dir=/cloudsql & I can connect to the Cloud