zkfan / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 0 forks source link

tungsten installer detects privileges for the wrong user #113

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Try to install with a database user which has different entries in the 
'user' table.
2. Give the 'Grants_priv' privilege the user that you intend to use. 
3. install

What is the expected output?
the installer recognizes that the current user has the grant privilege

What do you see instead?
The installer complains that the user has wrong privileges

What is the possible cause?
The installer assumes that there is only one user with this name, and fails the 
validation because it detects a "Grants_Priv = NO"

What is the proposed solution?
The installer should either check the result of "show grants for xxxx" where 
xxx is the result of "select user()", or restrict the query to identify the 
current user.

Original issue reported on code.google.com by g.maxia on 14 Jun 2011 at 8:18

GoogleCodeExporter commented 9 years ago

Original comment by jeffm...@gmail.com on 17 Jun 2011 at 12:50