| Bug #59389 | Error message from Manage Security link | ||
|---|---|---|---|
| Submitted: | 10 Jan 2011 8:01 | Modified: | 20 Jun 2011 19:16 |
| Reporter: | Dave Kelly | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S3 (Non-critical) |
| Version: | 5.2.31 CE GA | OS: | Windows (7 Pro x64, XP) |
| Assigned to: | Maksym Yehorov | CPU Architecture: | Any |
| Tags: | error, Manage security, Security, securityManager, WbAdmin.openSecurityManager, workbench | ||
[10 Jan 2011 8:04]
Dave Kelly
FYI: Forgot to mention this--I'm using Native Windows Remote Management in the Connection settings of the Server Instance. Not sure if this has anything to do with it.
[10 Jan 2011 8:30]
Valeriy Kravchuk
Thank you for the bug report. Verified also on 32-bit Windows XP SP3 while working with local 5.1.54 server.
[17 Jan 2011 17:22]
Michael Stern
I am getting a very similar error when trying to upload a (known working) .sql backup using the Import From Disk feature of Workbench. This is under 5.5.8.
Traceback (most recent call last):
File "/Applications/MySQL Tools/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 305, in openExportImport
tab.wait_server_check(4)
File "/Applications/MySQL Tools/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 133, in wait_server_check
while self.configuration.last_is_running_check is None and time.time() - t < timeout:
File "/Applications/MySQL Tools/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 665, in <lambda>
__getattr__ = lambda self, name: _swig_getattr(self, Box, name)
File "/Applications/MySQL Tools/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 34, in _swig_getattr
raise AttributeError,name
AttributeError: last_is_running_check
12:18:44 Restoring /Volumes/monkeybrigade/Documents/msdbdevelDump.sql
Running: /Applications/MySQL Tools/MySQLWorkbench.app/Contents/Resources/mysql --defaults-extra-file="/var/folders/ef/efF6AhfmEC816htnKky5OU+++TI/-Tmp-/tmpvYWkRB/extraparams" --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments < "/Volumes/monkeybrigade/Documents/msdbdevelDump.sql"
[25 Jan 2011 20:21]
James Sweeny
I receive the same error (roughly). Running XP SP3. WB 5.2.31 CE Revision 7115.
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 319, in openSecurityManager
tab.wait_server_check(4)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 133, in wait_server_check
while self.configuration.last_is_running_check is None and time.time() - t < timeout:
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 665, in <lambda>
__getattr__ = lambda self, name: _swig_getattr(self, Box, name)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 34, in _swig_getattr
raise AttributeError,name
AttributeError: last_is_running_check
ctrl_be: Query Error Error executing 'Field 'authentication_string' doesn't have a default value'
INSERT INTO mysql.user (User, Host, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, max_questions, max_updates, max_connections, max_user_connections, ssl_cipher, x509_issuer, x509_subject) VALUES ('report', '%', PASSWORD('R3p*r7'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 0, 0, 0, 0, '', '', '').
SQL Error: 1364
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 628, in commit
self._selected_user.save()
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 656, in save
raise Exception("Error adding account %s@%s: %s"%(self.username, self.host, e))
Exception: Error adding account report@%:
WMIShell: Set filters for local windows cli
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 319, in openSecurityManager
tab.wait_server_check(4)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 133, in wait_server_check
while self.configuration.last_is_running_check is None and time.time() - t < timeout:
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 665, in <lambda>
__getattr__ = lambda self, name: _swig_getattr(self, Box, name)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 34, in _swig_getattr
raise AttributeError,name
AttributeError: last_is_running_check
[20 Jun 2011 19:16]
Paul DuBois
Noted in 5.2.34 changelog. Clicking the Manage Security link in the MySQL Workbench Home screen opened the Admin screen in the Startup tab rather than the Accounts tab and produced an error.
Description: After clicking the Manage Security link in the MySQL Workbench Home screen, the Admin screen opens in the Startup tab (instead of the Accounts tab) and the following error message appears in the window status bar (bottom, lower left): 'Error in securityManager module: error calling WbAdmin.openSecurityManager: see output for details' Here's the contents of the output window: Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 319, in openSecurityManager tab.wait_server_check(4) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 133, in wait_server_check while self.configuration.last_is_running_check is None and time.time() - t < timeout: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 665, in <lambda> __getattr__ = lambda self, name: _swig_getattr(self, Box, name) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 34, in _swig_getattr raise AttributeError,name AttributeError: last_is_running_check Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 319, in openSecurityManager tab.wait_server_check(4) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 133, in wait_server_check while self.configuration.last_is_running_check is None and time.time() - t < timeout: File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 665, in <lambda> __getattr__ = lambda self, name: _swig_getattr(self, Box, name) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 34, in _swig_getattr raise AttributeError,name AttributeError: last_is_running_check How to repeat: Open MySQL Workbench, click Manage Security (under Server Administration on Home screen). Suggested fix: No clue.