CODEWITHSUNDEEP
amazon-web-servicesamazon-ec2amazon-rdsamazon-data-pipelinedata-pipeline
Berra2k
Berra2k

Reputation: 328

"Connection timed out (Connection timed out)" Error for SQLActivity

I have a connection timed out error on my data pipeline job to run a simple sql script. The script is set up in my S3. The data pipeline itself is in the region of us-east-1. My database is in us-east-2. When I first ran the pipeline I got the error "waiting on runner" and it never ran. I figured I should change my EC2 to us-east-2 to be in the same region as the database the SQL script is running on. I no long got "waiting on runner" but now I continuously get the error "connection timed out".

What's weird is all the AWS forum questions and documents say this is what happens when you attempt to connect to a database from outside EC2 but since I'm using EC2 I have no idea what the issue could be. Any suggestions would be very helpful and I'm happy to provide more details as needed.

Getting this error now in my logs: The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256.

Upvotes: 1

Views: 1135

Answers (1)

Yogesh_D
Yogesh_D

Reputation: 18809

Typical issues with connectivity arise out of the following:

  1. Is your DB allowing incoming connection from you EC2.
  2. In your DB Security Group what is the source for the DB port.
  3. If the DB and the EC2 are in different VPC's, are the VPC's peered.

Upvotes: 0

Related Questions