AWS DMS connection error ("password authentication failed")

Question

I configured source and target endpoint for DMS services, both of them are postgresDB one on EC2 machine, one on RDS.

When I test connection on both of them, I got the following error:

Operation:testEndpointDetails:[errType=ERROR_RESPONSE, status=122500, errMessage=Cannot connect to ODBC provider [122500] ODBC unkown error., errDetails= RetCode: SQL_ERROR SqlState: 28P01 NativeError: 210 Message: [unixODBC]FATAL: password authentication failed for user "docker" [122502] ODBC general error.]

What does that mean ? How could I possibly debug this ?

Answer 1

you need to grant permission to user docker and / or use correct password when you defined the endpoints.