RE: Error While Storing User Information

Hi Lynn:

This is maybe a little embarrassing, but here goes.  I'll bet you are
not going into the GUI-administrator as root.  I was logging in as
"myself" and thought that I had given "myself" all the privileges I
needed to fully administer the databases and the MySQL Server.

Note that in the GUI Administrator you only get a list of 12 privileges
(ie select; update etc.) and these are only "implemented" at the
individual database level.  But, in the Mysql.user table there is a list
of 21 privileges, one of which is Reload_priv -- this gives you the
right to issue the "flush privileges" command which must be run after
the user tables are changed.

So, long story short!  "Myself" was allowed to add the new user (don't
know why I was allowed to do this -- might be considered a bug -- why
should I be allowed to add the user, but, not be allowed to "flush
privileges"); but "myself" was NOT allowed to "reload" the privileges.
Since the user information is stored in memory; and since "myself" could
not reload the user privileges; none of the user changes came into
"effect" until I either stopped and restarted the MYSQL service; or;
until I logged in as root and ran a "flush privileges" command.  So,
until one of the two "reloads" by the methods noted above; it appeared
that the user information had not changed.  In fact, it had changed at
the user table level, but the new information had not been reloaded into
memory.

I believe the "Error While Storing User Information" error caused by
pressing the "Apply changes" in the GUI Administrator; was caused by
"myself" not having the rights to let the GUI administrator "flush"
(reload) the privileges information. Not a very informative error, to
say the least!

Well, I wanted "myself" to have all privileges, so I logged into the GUI
administrator as root.  I then deleted the "myself" user account.  I
highlighted the "root" user and then "right clicked".  One of the
pulldown options was "clone user".  I selected this option and then
named the new account "myself".  I looked in the mysql.user table and
sure enough "myself" had the same privileges as "root".  I closed the
administrator and then went back in as "myself".  I can now add, delete,
and modify users without getting the error box.  As well, the changes
are immediately evident in that I can login as the new user.

I would be very interested to hear from you about whether this solves
your problem.  Hope it helps!

Cliff




-----Original Message-----
From: Lynn Eriksen [mailto:[email protected]] 
Sent: Tuesday, March 22, 2005 1:25 PM
To: Cliff J. Cox
Cc: [email protected]
Subject: RE: Error While Storing User Information

I'm running 4.1.10 and 1.0.19.

I'm thinking that the issues are somehow related to the new character
sets in the 4.1.8 and above. I didn't experience the problem in 4.1.7
and below. There was a problem with 4.1.9 that really made the database
drag and caused major problems with Connector/Net. I had to produce a
temp fix for it, though the problem seemed to disappear with 4.1.10.

Some one else reported a similar bug and the guys recommended changing
the char sets to UTF8 for the table. I did for my user, user_info and db
tables, but I still get the problem. Part of the issue is also that the
error info is too ambiguous. I've turned on query logging and they are
sending out an advanced query to make the changes, but I cannot localize
the bug. If better bug info was returned from the DB (if it is a DB
problem), that would be greatly appreciated. 

Cliff, perhaps if you report the bug maybe they'll listen.

I'm submitting this to the gui-tools in hopes it will cause action.



-----Original Message-----
From: Cliff J. Cox [mailto:[email protected]] 
Sent: Tuesday, March 22, 2005 12:13 PM
To: Lynn Eriksen
Subject: RE: Error While Storing User Information

Hi Lynn:

I'm a little surprised that we haven't heard more about this issue.  Is
it only us?  Hard to imagine!  

I'm running 4.1.10 and Admin 1.0.19 (I think).  Are you running the
same. My problems seem to have started when I dropped one of my
"schemas"; but I can't really be sure.  Dropping and rebuilding the
schema is the only change I can think of as we moved through the
development phase.  The one thing I'm sure of is I used to be able to
administer user rights and add and remove users with the administrator.
BUT, I'm not exactly sure when my problems started.

I'll keep my eyes and ears open and if I hear anything I will let you
know.  

To escalate this I would assume we would have to open a bug report.
Sounds like you tried this and they removed it from the "bug" database.


Cliff






-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]