Issue 1048 in tungsten-replicator: Installation fails if MySQL master or slave login lacks SUPER privilege

[tungsten-...@googlecode.com]

Status: Accepted
Owner: jeff.m...@continuent.com
CC: csaba.si...@continuent.com
Labels: Type-Defect Priority-Medium FoundIn-3.0.0 FixedIn-3.0.0

New issue 1048 by csaba.si...@continuent.com: Installation fails if MySQL
master or slave login lacks SUPER privilege
https://code.google.com/p/tungsten-replicator/issues/detail?id=1048

What steps will reproduce the problem?

1. Create a MySQL account according to instructions in 3.0 documentation:


https://docs.continuent.com/tungsten-replicator-3.0/prerequisite-mysql.html#prerequisite-mysql-users-unprivileged

2. Set up master/slave replication with a non-privileged account using tpm
--privileged-master=false or --privileged-slave=false to tell replicator it
should not depend on presence of SUPER privilege.

tpm install myservice \
...
--replication-user=tungsten_lite \
--replication-password=secret \
--privileged-master=false \
...
--start-and-report

What is the expected output?

Install succeed and the nodes are online.

What do you see instead?

Install fails with the following error:
ERROR >> host1 >> The database user is missing some privileges or the grant
option. Run 'mysql -utungsten_lite -psecret -hhost1 -e"GRANT ALL ON *.* to
tungsten@host1 WITH GRANT OPTION"'

What is the possible cause?

If --skip-validation-check=MySQLPermissionsCheck is specified install
succeed. However when --privileged-master=false or --privileged-slave=false
is specified the user shouldn't specify the --skip-validation-check
parameter also.

What is the proposed solution?

--privileged-master=false or --privileged-slave=false should be enough. No
need for --skip-validation-check.



--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[tungsten-...@googlecode.com]

Updates:
Owner: eric.har...@continuent.com
Labels: -FixedIn-3.0.0 FixedIn-3.0.1

Comment #1 on issue 1048 by jeff.m...@continuent.com: Installation fails if

MySQL master or slave login lacks SUPER privilege
https://code.google.com/p/tungsten-replicator/issues/detail?id=1048

(No comment was entered for this change.)

[tungsten-...@googlecode.com]

Comment #4 on issue 1048 by jan.zeis...@wimdu.com: Installation fails if

MySQL master or slave login lacks SUPER privilege
https://code.google.com/p/tungsten-replicator/issues/detail?id=1048

Is it possible to see the changes for 4.0.1? We would like to use
tungsten-replicator to replicate from AWS RDS MySQL to AWS Redshift and
need to turn off the privilege checks for the master.
Is it possible to have a look on the version 4.0.1?

Thanks in advance.