DMS Connection issues

0

Hi All, I am trying to migrate mysql on ec2 to mysql on RDS. Source db user has the following privilege.

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON . TO ‘adminsource’@‘%’; GRANT SELECT, RELOAD, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON . TO ‘adminsource’@‘%’; GRANT BACKUP_ADMIN ON . TO ‘adminsource’@‘%’;

my.cnf file has required config as https://docs.aws.amazon.com/dms/latest/userguide/dm-data-providers-source-mysql.html

!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ [mysqld] server-id=1 log-bin=mysql-bin.log binlog_format=ROW expire_logs_days=1 binlog_checksum=NONE binlog_row_image=FULL log_slave_updates=TRUE

Migration tasks fails with the error “The prerequisites for DMS to use the source database have not been met. Configure the user account permissions or privileges for DMS and restart the migration”. It is the same error for Full load and Full load + CDC.

Any help appreciated

Satish
asked 4 months ago194 views
2 Answers
0

Have you configured the user details in secrets manager and referenced them in DMS?

profile picture
EXPERT
answered 4 months ago
  • Yes. Secret Mgr is configured

0

Hello,

Could you pls. follow the https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SupportScripts.MySQL.html This would help you to understand what pre-requisite might be missing.

AWS
answered 4 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