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
preguntada hace 5 meses206 visualizaciones
2 Respuestas
0

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

profile picture
EXPERTO
respondido hace 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 hace 4 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas