Crash on selecting user in User manager
| User, date | Message |
|---|---|
|
Written by Plasm
1 year ago Category: General 63 posts since Fri, 10 Sep 10 |
Hi, I get crashes when I click on 2 users in the User manager. Both user have the same host. The Error Message says, that this user doesn´t have this privilege - but I don´t know which privilege is meant(?) I´m logged in as root@% which have all privileges. Here´s the report: date/time : 2012-03-21, 12:32:53, 15ms computer name : WSJH2 user name : jh <admin> registered owner : jh operating system : Windows 7 x64 Service Pack 1 build 7601 system language : German system up time : 3 hours 45 minutes program up time : 16 seconds processors : 2x Intel(R) Core(TM)2 Duo CPU E8500 @ 3.16GHz physical memory : 1233/3738 MB (free/total) free disk space : (C:) 205,34 GB display mode : 1600x1200, 32 bit process id : $125c allocated memory : 63,82 MB executable : heidisql.exe exec. date/time : 2012-03-21 08:59 version : 7.0.0.4098 compiled with : Delphi XE madExcept version : 3.0m beta 1 callstack crc : $18ba9f1b, $bb1cfa37, $bb1cfa37 exception number : 1 exception class : EDatabaseError exception message : SQL Error (1141): Für Benutzer 'root' auf Host 'mb2-0582fd' gibt es keine solche Berechtigung. main thread ($b0): 00710be2 heidisql.exe dbconnection 1267 +26 TMySQLConnection.Query 0071ab54 heidisql.exe dbconnection 3264 +3 TMySQLQuery.Execute 007138cd heidisql.exe dbconnection 1814 +5 TDBConnection.GetResults 007142f0 heidisql.exe dbconnection 1997 +1 TDBConnection.GetCol 00766e68 heidisql.exe usermanager 489 +44 TUserManagerForm.listUsersFocusChanged 0062680e heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange 0062ac34 heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown 004e9370 heidisql.exe Controls TControl.DoMouseDown 00622bac heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown 004e8d18 heidisql.exe Controls TControl.WndProc 004ed5dc heidisql.exe Controls TWinControl.WndProc 0062ef24 heidisql.exe VirtualTrees TBaseVirtualTree.WndProc 004ecc7c heidisql.exe Controls TWinControl.MainWndProc 004ab504 heidisql.exe Classes StdWndProc 761e7885 USER32.dll DispatchMessageW 00575bc7 heidisql.exe Forms TApplication.ProcessMessage 00575c0a heidisql.exe Forms TApplication.HandleMessage 00571569 heidisql.exe Forms TCustomForm.ShowModal 007cf150 heidisql.exe Main 2023 +1 TMainForm.actUserManagerExecute 004aae5f heidisql.exe Classes TBasicAction.Execute 004d7505 heidisql.exe ActnList TContainedAction.Execute 004d82c0 heidisql.exe ActnList TCustomAction.Execute 004aad23 heidisql.exe Classes TBasicActionLink.Execute 004e926c heidisql.exe Controls TControl.Click 0054a38c heidisql.exe ComCtrls TToolButton.Click 004e9729 heidisql.exe Controls TControl.WMLButtonUp 004e8d18 heidisql.exe Controls TControl.WndProc 004e893c heidisql.exe Controls TControl.Perform 004ecd74 heidisql.exe Controls GetControlAtPos 004ece3e heidisql.exe Controls TWinControl.ControlAtPos 004e893c heidisql.exe Controls TControl.Perform 004ecf08 heidisql.exe Controls TWinControl.IsControlMouseMsg 004ed458 heidisql.exe Controls TWinControl.WndProc 0054eddc heidisql.exe ComCtrls TToolBar.WndProc 004ecc7c heidisql.exe Controls TWinControl.MainWndProc 004ab504 heidisql.exe Classes StdWndProc 761e7885 USER32.dll DispatchMessageW 00575bc7 heidisql.exe Forms TApplication.ProcessMessage 00575c0a heidisql.exe Forms TApplication.HandleMessage 00575f35 heidisql.exe Forms TApplication.Run 007fe8fb heidisql.exe heidisql 67 +16 initialization 75da3398 kernel32.dll BaseThreadInitThunk |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
Line 489 in usermanager.pas fires a SHOW GRANTS FOR 'root'@'mb2-0582fd' You could try and fire that manually - and should end up with the same error message. I guess, there is some data broken in your mysql.user table, but I'm totally unsure. Which server version is it? |
|
Written by Plasm
1 year ago 63 posts since Fri, 10 Sep 10 |
Manually works. Server is 5.5.21. Seems that this is a user that MySQL inserted itself |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
The server inserts users? Well, the hostname does neither look as if it was manually entered nor it looks like a valid hostname. But I didn't knew there is some automatism on the server which does that. Do you know more? |
|
Written by Plasm
1 year ago 63 posts since Fri, 10 Sep 10 |
It´s been installed by mysql_install_db, a mysql-script that is used to create the first initial db. The server ist an embedded linux-device. I guess, the problem has todo with a mysql start-parameter. The database-server is stared with the -skip-name-resolve option, since it can´t be guaranteed that a DNS-Server is available. Here are the SQL-lines used in that script. Hope it helps: CREATE TEMPORARY TABLE tmp_user LIKE user; set @current_hostname= @@hostname; INSERT INTO tmp_user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); REPLACE INTO tmp_user SELECT @current_hostname,'root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','' FROM dual WHERE LOWER( @current_hostname) != 'localhost'; REPLACE INTO tmp_user VALUES ('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); REPLACE INTO tmp_user VALUES ('::1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); INSERT INTO tmp_user (host,user) VALUES ('localhost',''); INSERT INTO tmp_user (host,user) SELECT @current_hostname,'' FROM dual WHERE LOWER(@current_hostname ) != 'localhost'; INSERT INTO user SELECT * FROM tmp_user WHERE @had_user_table=0; DROP TABLE tmp_user; @hostname is set to MB2-0582fd in another script. |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
Hm ok. Only that does not explain the error message after "SHOW GRANTS FOR 'root'@'mb2-0582fd'". Can you reproduce that error, by the way? |
|
Written by Plasm
1 year ago 63 posts since Fri, 10 Sep 10 |
Yes, everytime I click (=select) the user in the User manager. If I then click "continue" in the exception dialog and then choose another user, HeidiSQL asks to save the changes (but there were none). |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
You could be so nice and send me a dump of your mysql database. Feel free to remove passwords, although these may cause the above problem. |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
[some pm's ...] Exception for non yet flushed users is caught in r4101. |
|
Written by ansgar
1 year ago 3949 posts since Fri, 07 Apr 06 |
[some pm's ...] --skip-name-resolve server option handled in r4120. |
|
Please login to leave a reply, or register at first. |