The Wayback Machine - https://web.archive.org/web/20201121005255/https://github.com/github/gh-ost/issues/840
Skip to content

/ gh-ost

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

Jump to bottom

Aws rds for MySQL5.7 execute gh-ost error #840

Open
axiaochen opened this issue Apr 17, 2020 · 5 comments
Open

Aws rds for MySQL5.7 execute gh-ost error #840

axiaochen opened this issue Apr 17, 2020 · 5 comments

Comments

@axiaochen
Copy link

@axiaochen axiaochen commented Apr 17, 2020

This is the place to report a bug, ask a question, or suggest an enhancement.

This is also the place to make a discussion before creating a PR.

If this is a bug report, please provide a test case (e.g., your table definition and gh-ost command) and the error output.

Please use markdown to format code or SQL: https://guides.github.com/features/mastering-markdown/

Please label the issue on the right (bug, enhancement, question, etc.).

And please understand if this issue is not addressed immediately or in a timeframe you were expecting.

Thank you!
@axiaochen
Copy link
Author

@axiaochen axiaochen commented Apr 17, 2020

This is the error message:
[root@ip-172-31-27-46 scripts]# gh-ost --user='vdadmin' --password='xxxxxx' --host='vd-test-db.xxxxxxxxxxxx-1.rds.amazonaws.com' --port=4417 --database="xxxxxx" --table="xxxxxx" --verbose --allow-on-master --alter="ADD COLUMN rdsonlineddl_test varchar(10) DEFAULT NULL" --assume-rbr
2020-04-17 03:38:26 INFO starting gh-ost 1.0.49
2020-04-17 03:38:26 INFO Migrating xxxxxx.xxxxxxxx
2020-04-17 03:38:26 INFO connection validated on vd-test-db.xxxxxxxxxxxx-1.rds.amazonaws.com:xxxx
2020-04-17 03:38:26 INFO User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on xxxxxx.*
2020-04-17 03:38:26 INFO binary logs validated on vd-test-db.xxxxxxxxxxxx-1.rds.amazonaws.com:xxxx
2020-04-17 03:38:26 INFO Inspector initiated on ip-10-7-2-122:4417, version 5.7.25-log
2020-04-17 03:38:26 INFO Table found. Engine=InnoDB
2020-04-17 03:38:26 INFO Estimated number of rows via EXPLAIN: 439127
2020-04-17 03:38:26 INFO Recursively searching for replication master
2020-04-17 03:38:26 ERROR Error 1045: Access denied for user 'vdadmin'@'ip-172-31-27-46.ap-northeast-1.compute.internal' (using password: YES)
2020-04-17 03:38:26 INFO Tearing down inspector
2020-04-17 03:38:26 FATAL Error 1045: Access denied for user 'vdadmin'@'ip-172-31-27-46.ap-northeast-1.compute.internal' (using password: YES)
@axiaochen
Copy link
Author

@axiaochen axiaochen commented Apr 17, 2020 •
edited

I created the user 'vdadmin'@'ip-172-31-27-46.ap-northeast-1.compute.internal', but I still get the above error.
I can use the user 'vdadmin'@'ip-172-31-27-46.ap-northeast-1.compute.internal' to connect to aws rds. as follows:
[root@ip-172-31-27-46 scripts]# mysql -uvdadmin -hvd-test-db.xxxxxxxxxxxx-1.rds.amazonaws.com -Pxxxx -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 732
Server version: 5.7.25-log Source distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

vdadmin@vd-test-db.xxxxxxxxxxxx-1.rds.amazonaws.com : (none) 03:58:22>
@axiaochen
Copy link
Author

@axiaochen axiaochen commented Apr 17, 2020

Can anyone help me solve the above problem? I will be very grateful
@elijahchancey
Copy link

@elijahchancey elijahchancey commented May 7, 2020

When you create the user make sure you use wildcards for the hostname.
@shlomi-noach
Copy link
Contributor

@shlomi-noach shlomi-noach commented May 8, 2020

Did you create the user account on the master? (you should). It seems to me like you may have created the account directly on the replica.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
3 participants
@elijahchancey @shlomi-noach @axiaochen
You can’t perform that action at this time.