[Koha-bugs] [Bug 6416] koha-remove fails when dropping user

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6416

--- Comment #1 from Robin Sheat <robin at catalyst.net.nz> 2011-09-05 04:46:25 UTC ---
I've had a confirmation of this. FWIW, the removal line is:

DROP USER \`koha_$name\`;

There is a comment here:
http://dev.mysql.com/doc/refman/5.1/en/drop-user.html
saying:
As of 5.0.37, if the user does not exists, MySQL responds with: 'ERROR 1396
(HY000): Operation DROP USER failed for ...'

There could be funny version things happening.

Also:
http://dev.mysql.com/doc/refman/5.1/en/account-names.html
says that '%' is implied if not there, and is treated as a wildcard, so I'd
expect it should work.

I may have to do more testing at some stage.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.