Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for using RDS IAM with canal #879

Open
samongyr-sq opened this issue May 14, 2024 · 2 comments
Open

Add support for using RDS IAM with canal #879

samongyr-sq opened this issue May 14, 2024 · 2 comments

Comments

@samongyr-sq
Copy link

Attempting to use canal with RDS IAM Auth tokens results in ERROR 1105

ERRO[0013] canal start sync binlog err: start sync replication at binlog (mysql-bin-changelog.000003, 267160) error ERROR 1105 (HY000): Failed to register slave; too long 'report-password'
ERRO[0013] canal has failed. error: start sync replication at binlog (mysql-bin-changelog.000003, 267160) error ERROR 1105 (HY000): Failed to register slave; too long 'report-password'
panic: canal has failed

Is the mysql_clear_password auth plugin not supported?

@samongyr-sq samongyr-sq changed the title Support for mysql_clear_password for compatibility with RDS IAM Support mysql_clear_password for compatibility with RDS IAM May 14, 2024
@samongyr-sq
Copy link
Author

According to #757, it should already be supported. But it might not actually be because of this line

@samongyr-sq samongyr-sq changed the title Support mysql_clear_password for compatibility with RDS IAM Add support for using RDS IAM with canal May 15, 2024
@samongyr-sq
Copy link
Author

Judging by MySQL Bug #43439, it appears this is an old (but unexpected) limitation of CHANGE MASTER

The password used for a replication user account in a CHANGE MASTER TO statement is limited to 32 characters in length. Trying to use a password of more than 32 characters causes CHANGE MASTER TO to fail (see MySQL docs)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant