[google-cloud-sql-discuss] Re: Unable to connect to Cloud SQL from Node JS

Hi Fabrizio,

What Kenworth posted above is correct, you should only use either host/post to connect via TCP or you should use socketPath to connect with a UnixSocket. For AppEngine Standard you have to use a unix socket, for AppEngine Flex you can choose whichever is better for your situation. 

On Sunday, May 27, 2018 at 8:48:22 AM UTC-7, Lalit Indoria wrote:

Hi

I am trying to connect to node JS from my sails js app that's hosted on App Engine in the same project as Cloud SQL. I have tried multiple combinations but failed every time.

Here' what the log says:

name=AdapterError, adapterMethodName=create, modelIdentity=admin, name=Exception, code=badConnection, exit=badConnection, errorno=ETIMEDOUT, code=ETIMEDOUT, syscall=connect, fatal=true, host=35.230.110.241, port=3306, schema=true, adapter=sails-mysql, socketPath=/cloudsql/parsley-dev:us-west1:parsley-dev, user=parsley-dev, password=parsleyDevApi, database=parsley, identity=default, url=mysql://parsley-dev:parsleyDevApi@35.230.110.241:3306/parsley, isOperational=true, adapterMethodName=create, modelIdentity=admin, $ref=$["cause"]["raw"]

My sails JS adapter configuration:

adapter: 'sails-mysql',
socketPath: `/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}`,
user: process.env.SQL_USER,
password: process.env.SQL_PASSWORD,
host: '35.230.110.241',
database: 'parsley'

Would be great if someone can help me.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2d2b80dc-1b0b-41a8-91e5-4c7e86f908bf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.