Your message dated Thu, 09 Aug 2012 22:26:38 +0100 with message-id <[email protected]> and subject line forwaded and closed has caused the Debian Bug report #328287, regarding mysql-server-4.1: mysql_setpermission is broken to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 328287: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=328287 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: mysql-server-4.1 Version: 4.1.11a-4 mysql_setpermission is broken in this package. Attempting to use menu option #4 (``Create/append database administrative privileges for an existing database and host combination'') causes the script to crash with Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at /usr/bin/mysql_setpermission line 260, <STDIN> line 15. Transcript as follows: ious:/etc/apt# mysql_setpermission Password for user to connect to MySQL: ###################################################################### ## Welcome to the permission setter 1.3 for MySQL. ## made by Luuk de Boer ###################################################################### What would you like to do: 1. Set password for an existing user. 2. Create a database + user privilege for that database and host combination (user can only do SELECT) 3. Create/append user privilege for an existing database and host combination (user can only do SELECT) 4. Create/append broader user privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE) 5. Create/append quite extended user privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX, LOCK TABLES,CREATE TEMPORARY TABLES) 6. Create/append database administrative privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES, CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS) 7. Create/append full privileges for an existing database and host combination (user has FULL privilege) 8. Remove all privileges for for an existing database and host combination. (user will have all permission fields set to N) 0. exit this program Make your choice [1,2,3,4,5,6,7,0]: 2 Which database would you like to add: fishsoup The new database fishsoup will be created What username is to be created: fishsoup Username = fishsoup Would you like to set a password for fishsoup [y/n]: n We won't set a password so the user doesn't have to use it We now need to know from what host(s) the user will connect. Keep in mind that % means 'from any host' ... The host please: localhost Would you like to add another host [yes/no]: no Okay we keep it with this ... The following host(s) will be used: localhost. ###################################################################### That was it ... here is an overview of what you gave to me: The database name : fishsoup The username : fishsoup The host(s) : localhost ###################################################################### Are you pretty sure you would like to implement this [yes/no]: yes Okay ... let's go then ... Everything is inserted and mysql privileges have been reloaded. ###################################################################### ## Welcome to the permission setter 1.3 for MySQL. ## made by Luuk de Boer ###################################################################### What would you like to do: 1. Set password for an existing user. 2. Create a database + user privilege for that database and host combination (user can only do SELECT) 3. Create/append user privilege for an existing database and host combination (user can only do SELECT) 4. Create/append broader user privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE) 5. Create/append quite extended user privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX, LOCK TABLES,CREATE TEMPORARY TABLES) 6. Create/append database administrative privileges for an existing database and host combination (user can do SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES, CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS) 7. Create/append full privileges for an existing database and host combination (user has FULL privilege) 8. Remove all privileges for for an existing database and host combination. (user will have all permission fields set to N) 0. exit this program Make your choice [1,2,3,4,5,6,7,0]: 6 Which database from existing databases would you like to select: You can choose from: - fishsoup - mysql Which database will it be (case sensitive). Type * for any: fishsoup The database fishsoup will be used. What username is to be created: fishsoup Username = fishsoup Would you like to set a password for fishsoup [y/n]: n We won't set a password so the user doesn't have to use it We now need to know from what host(s) the user will connect. Keep in mind that % means 'from any host' ... The host please: localhost Would you like to add another host [yes/no]: no Okay we keep it with this ... The following host(s) will be used: localhost. ###################################################################### That was it ... here is an overview of what you gave to me: The database name : fishsoup The username : fishsoup The host(s) : localhost ###################################################################### Are you pretty sure you would like to implement this [yes/no]: yes Okay ... let's go then ... Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at /usr/bin/mysql_setpermission line 260, <STDIN> line 15. -- ``... one of the main causes of the fall of the Roman Empire was that, lacking zero, they had no way to indicate successful termination of their C programs.'' (Robert Firth)
--- End Message ---
--- Begin Message ---forwarded 328287 http://bugs.mysql.com/bug.php?id=14618
--- End Message ---
