By using AWS re:Post, you agree to the Terms of Use

MySQL Aurora Error connecting to S3

0

I'm setting up a new Aurora cluster and followed the documentation to create the role and policy needed for Aurora/RDS to access a bucket. Role has been assigned in parameter list and on cluster. The error I'm getting doesn't feel like the normal "I messed up a json file" policy problem. It feels like more of a vpc access point problem but google was little help on the error. I don't know if there is an inbound or outbound rule missing somewhere?

mysql> SELECT * FROM DB.table INTO OUTFILE S3 's3://xyzbucketname/export.txt'
    ->     FIELDS TERMINATED BY '\t'
    ->     LINES TERMINATED BY '\n' ;
ERROR 63994 (HY000): S3 API returned error: Network Connection:Unable to connect to endpoint
mysql>

The VPC has an s3 endpoint setup: com.amazonaws.us-east-1.s3 Gateway

Many of the searches lead back here but it didn't provide any details: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Authorizing.Network.html

1 Answer
1
Accepted Answer

Found the problem. Aurora cluster was created on a subnet that wasn't assigned to the existing S3 vpc endpoint.

answered 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions