Bug #17396 cant assign user access
Submitted: 14 Feb 2006 19:59 Modified: 5 Sep 2006 0:30
Reporter: Andrew Stolarz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.1.3 OS:MacOS (OSX 10.4.4 SERVER)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: User Management

[14 Feb 2006 19:59] Andrew Stolarz
Description:
After creating a schema (database), I go to create a user/ network access for my entire ip range (192.168.1.%).

I get the message accross the entire screen that says:

no account selected, please select an account to view its information

And it blocks the button to transfer the privliges.. there is one pixel on that button you can click on, right at the edge of the button. very hard to bypass that images overlapping the button.

it also wont allow me to transfer the execute privliage, it just stays in the available privlegde when you click somewhere else and go back into that schema.

after eventually assigning the privliges I can, I am unable to connect up with the administrators module with that new user I just created.

the entire user access/ privliges needs to be looked at.

this all works perfect on 10.4.4 client machines.. the only problem is when I do this on 10.4.4 server machines.

How to repeat:
please see above.
[14 Feb 2006 20:00] Andrew Stolarz
It also works on 10.3.9 Server.
[20 Feb 2006 21:13] Andrew Stolarz
OK, I found the exact bug and how to repliacte it.
First off I want to say I got it working on 10.4.4 server. (problem also happens in 10.4.4 client so its to do with the administrator module.)

when creating a user, you CAN NOT press save on that window without adding a host (and entering your IP) which you can connect from.

Then you select "schema priviliges" and it will tell you that you need to save, at this point you can save. and assign the priviliges.

and then access the database with the newly created user.

-----------

If you create a user and press save, then go and add a host for that user. and try to connect to the database. it says you dont have access priviliges.

I can repeat this over and over.

-----------

however, I do sometimes get the redraw issue when trying to select my privilages and transfering them over. sometime it works, sometimes the redraw of that image will not allow me to transfer the privilages becuase the button is being blocked. this happens much much more on 10.4.4 server rather then the 10.4 client.

hope this helps!
[3 Mar 2006 13:15] Domas Mituzas
a screenshot displaying unclickable region

Attachment: Picture 2.png (image/png, text), 125.60 KiB.

[3 Mar 2006 13:17] Domas Mituzas
Verified with 1.1.3 on MacOSX 10.4.5

The error label captures all clicks to the region, even lists are refreshed over it.
[28 Apr 2006 18:24] Alfredo Kojima
The problem of the big text blocking everything is solved, but I do not understand the other problem. If I add a user and click save, it will warn me that I have to "add at least one host from where it can connect from". If I then add a Host to that user and assign privileges, I can assign privileges and connect to the host, but only after Saving again.

Can you confirm whether you are saving after making all changes?
[4 May 2006 19:23] Andrew Stolarz
These are the exact steps I am doing. (please do not click anywhere
else unless I specified in the writing) as this is a sequence of
events issue.

1. I log into the administrator module using "localhost" and root. and press connect.

2. I go to the accounts option and press the add user button.
I put "andrew" as the user name and password, after I type in my confirm
password I select "save changes"

it gives me a message saying "no hosts defined for user"

3. After pressing OK on that message, I dropdown the andrew user using
the arrow option right next to it. I select ADD hosts and I used the
following IP "192.168.1.%" and press ADD.

4. right away I select "schema privileges" tab, (as you can see its
using "andrew@192.168.1.%" as the host).

5. I select my database and assign all the privileges to the user and
press "save changes"

6. I quit the administrator module, and reopen it up again.

7. for the hostname, I use the server IP address which is,
192.168.1.140, username and password are "andrew" and press connect.

8. I get a message saying "connection error, could not connect to
mysql instance at 192.168.1.140, error: access denied for user
andrew@192.168.1.140 etc etc

I know the working method around this, however its a really annoying
little bug if you do it in this order.
[5 Sep 2006 0:30] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html