Tuesday 16 May 2017

AWS Lambda node.js ETIMEDOUT when accessing MySQL or MS SQL in RDS

I am trying to a connect a AWS Lambda function to a database in RDS, I followed a few posts that have surggested they both need to be inside the same VPC, but have been told by Amazon support that this is not the case. Although I have tried a multi subnet VPC with nat gateway and security groups alllowing aceess to each, with no provail.

I am able to talk to the Database instances in SQL management studio or MySQL workbench without a problem.

10:13:00 2017-05-16T10:13:00.509Z Callback connection.connect() 10:13:00 2017-05-16T10:13:00.547Z Error ETIMEDOUT

I have tried a few different methods of connection now, I used an example as seen in the post, the only difference is this databases wasnt in RDS.

Querying a MySQL database from a NodeJS AWS Lambda Function

I have tried a MSSQL and MSSQL databases instances, both experiences a timeout on connection. I have attached all relvant policys to the lambda fucntion.



via RickWeb

No comments:

Post a Comment