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 SQL Proxy using this socket without any trouble. 
i.e.,

mysql -u airflowuser -p -S /cloudsql/myproject:europe-west1:airflowinstance

But I can't get Airflow to connect using the below connection string:

sql_alchemy_conn = mysql://airflowuser:xxx@/airflowdatabase?unix_socket=
/cloudsql/myproject:europe-west1:airflowinstance

I get a 'connection refused' error.

Any help much appreciated!



-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to