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
feita há 5 meses207 visualizações
2 Respostas
0

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

profile picture
ESPECIALISTA
respondido há 5 meses
  • 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
respondido há 4 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas