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

[BUG] --skip-definer doesn't appear to affect views #716

Closed
CWDN opened this issue Jun 9, 2022 · 0 comments · Fixed by #736
Closed

[BUG] --skip-definer doesn't appear to affect views #716

CWDN opened this issue Jun 9, 2022 · 0 comments · Fixed by #736
Labels

Comments

@CWDN
Copy link

CWDN commented Jun 9, 2022

Describe the bug
We are trying to run a restore to an AWS RDS Instance and have the --skip-definer option applied however we still see the error:

11:51:10.275: Error restoring: CREATE ALGORITHM=UNDEFINED DEFINER=`*************`@`%` SQL SECURITY DEFINER VIEW `****` AS select `****`.`uuid`... ));
 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Anything with a * is something I've had to mask.

We do use the AWS RDS Auth Token to authenticate and I added the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1 env variable to ensure the cleartext plugin is loaded.

To Reproduce

Command executed:

Technically these commands are executed from a Go script however it seems to have the same effect as running it from the command line.

  • mydumper with all the parameters
mydumper -u *** --port=3306 -h *** --password=** --database=** --compress --triggers --routines --less-locking --outputdir=export --lock-all-tables --ssl --ssl-mode=PREFERRED --ca=/etc/ssl/certs/aws-rds.pem
  • myloader with all the parameters
myloader --skip-definer --ssl --ssl-mode=PREFERRED --ca=/etc/ssl/certs/aws-rds.pem --user=*** --port=3306 --host=*** --password=*** --database=*** --directory=export

What mydumper and myloader version has been used?

We install the below version:

v0.12.3-3/mydumper_0.12.3-3-zstd.bullseye_amd64.deb

Expected behavior
The restore is success.

Environment (please complete the following information):

  • OS version: Debian
  • MyDumper version: v0.12.3-3
@CWDN CWDN added the bug label Jun 9, 2022
@davidducos davidducos changed the title [BUG] --skip-definer doesn't appear to affect this SQL statement (AWS RDS) [BUG] --skip-definer doesn't appear to affect views Jun 20, 2022
@davidducos davidducos added this to the Release 0.12.5-1 milestone Jun 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants