mysql_setpermission broken

[hackel]

Package: mysql-server-5.0
Version: 5.0.18-8.1

mysql_setpermission dies with the following error:

Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at /usr/bin/mysql_setpermission line 260, <STDIN> line 8.

When trying to set any permissions for an existing db/user combination.

This was reported here and here:
http://bugs.debian.org/328287
http://bugs.mysql.com/bug.php?id=14618

[Christian Hammers (ch)]

retitle 328287 mysql-server-4.1: mysql_setpermission is broken
thanks

[Christian Hammers (ch)]

notfound 328287 mysql-server-5.0 5.0.18
thanks

I've just tried it, this is really only for Sarge's 4.1.

bye,

-christian-

[hackel (hackel)]

Package: mysql-server-5.0
Version: 5.0.18-8.1

mysql_setpermission dies with the following error:

Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at /usr/bin/mysql_setpermission line 260, <STDIN> line 8.

When trying to set any permissions for an existing db/user combination.

This was reported here and here:
http://bugs.debian.org/328287
http://bugs.mysql.com/bug.php?id=14618

[Matt Zimmerman (mdz)]

The Debian bug report says it only affects mysql 4.1, and the upstream bug report has been closed due to a lack of response from the reporter

[Matt Zimmerman (mdz)]

       $sth = $dbh->do("GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS ON $db.* TO $user@\"$host\" IDENTIFIED BY \'$pass\'") || die $dbh->errstr;

[Martin Pitt (pitti)]

Does not affect 5.0 according to Debian bug.

[Martin Pitt (pitti)]

Whoops, upstream seems to disagree. Reopening.

[Henri Cook (henricook)]

Problem confirmed, fix on the way

[Henri Cook (henricook)]

Attached - I have only just joined the team so have no idea how to get this into the distribution - anyone who has more info on how i'm meant to do this would be most welcome to contact me.

To apply this patch for now:

cd /usr/bin
sudo patch -p0 < /path/to/mysql_setpermission.patch

Let me know if there's any problems,

ph8

[Mathias Gug (mathiaz)]

Thanks for your patch.

Can you provide a simple test case to reproduce the problem ?

[Henri Cook (henricook)]

The test case I used is visible at the mysql bug page http://bugs.mysql.com/bug.php?id=14618

There's a lot of text but it's relatively simple step (the offending one is towards the end so you might want to just skip straight there) (Option Six)

The patch does involve changing the next of the option 6 command, which may mean it does something other than what was originally intended, I believe i've captured the original intentions but if you disagree let me know

[Mathias Gug (mathiaz)]

Thanks for you patch.

Upstream has committed another patch which remove the option:
  Remove option 6 - trying to grant global privileges at the database
    level does not work. The spirit of the program appears to be aimed
    at database privileges, so do not give the option of granting global
    privileges as it may be unexpected.

 I think that what should be done is to grant privileges at the database level, and don't grant any privilege at the global level.

[Henri Cook (henricook)]

Sounds sensible

[Mathias Gug (mathiaz)]

Upstream has committed a patch that fixes this bug into their trees (4.1 and 5.0).

Could you have a look at integrating their patch ?

[Chuck Short (zulcss)]

Looking at backporting the patch for hardy.

[Mathias Gug (mathiaz)]

On Mon, Feb 04, 2008 at 01:39:04PM -0000, Chuck Short wrote:
> Looking at backporting the patch for hardy.
>

I think MySQL has committed a patch in their tree. Thus it should be
fixed in 5.0.51 (which should be uploaded soon).

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

[Chuck Short (zulcss)]

It has been included.

Thanks
chuck