| Bug #57984 | MySQL Workbench 5.2.29CE & MySQL 5.5 Admin Users Fails | ||
|---|---|---|---|
| Submitted: | 4 Nov 2010 16:18 | Modified: | 24 Nov 2010 17:57 |
| Reporter: | Deborah Dube | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S1 (Critical) |
| Version: | 5.2.29CE | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | MYSQL 5.5 Admin user fails from workbench | ||
[4 Nov 2010 20:49]
MySQL Verification Team
Thank you for the bug report. When you open the screen Manage Security The Database Server Status shows the server is running?.
[4 Nov 2010 20:57]
Deborah Dube
Yes it says: 2010-11-04 16:56:14 - Check server status: Server is running 2010-11-04 16:56:16 = Server is running And the screen footer says: Error in securityManager module: error calling WbAdmin.openSecurity Manager: see output for details
[8 Nov 2010 15:24]
MySQL Verification Team
Thanks for the feedback. Your connection is local or remote?.
[8 Nov 2010 16:20]
Deborah Dube
The connection is local
[23 Nov 2010 11:07]
MySQL Verification Team
Could you please try new version 5.2.30. Thanks in advance.
[23 Nov 2010 17:17]
Deborah Dube
Problem resolved with upgrade to version 5.2.30CE Thank You
[24 Nov 2010 17:57]
Valeriy Kravchuk
Not repeatable with 5.2.30.
[30 Dec 2010 4:43]
GOBINATH MANI
I am facing the same issue with the new version 5.2.31 CE. I have installed MySql Community Server 5.5 in my windows xp.
While Adding Account, i am getting the error. Below is the error from Output:
===============================================================================
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 ('test', '%', PASSWORD('test'), '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 test@%:
[11 Jan 2011 19:51]
Karl Chan
Using MySQL Workbench 5.2.31CE on Win2008 machine connected through localhost to a mySQL 5.5.8 DB Same error as previous user. error calling WbAdmin.openSecurityManager Can't add user, when adding, I get unhandled exception
[12 Jan 2011 7:51]
john nurdin
same with me, cannot add new user,5.2.31 ce rev 7115, i'm using windows 7
[13 Jan 2011 15:11]
Karl Chan
I uninstalled MySQL community server 5.5.8. Installed 5.1.54 (with exact same install profile) Launched workbench 5.2.31a and was able to create a user successfully.
[18 Jan 2011 18:01]
Tristan Chambers
Same problem as described above, running MySQL 5.5.8, Workbench 5.2.31 on Windows 2008.
Description: Unable to add new user or change any existing users. Server admin, manage security throws an error on click How to repeat: Open workbench, goto server administration, click on manage security and the error below occurs. Traceback (most recent call last): File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 319, in openSecurityManager tab.wait_server_check(4) File "D:\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 "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 653, in <lambda> __getattr__ = lambda self, name: _swig_getattr(self, Box, name) File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\mforms.py", line 34, in _swig_getattr raise AttributeError,name AttributeError: last_is_running_check Exception in thread Thread-1: Traceback (most recent call last): File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner self.run() File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run self.__target(*self.__args, **self.__kwargs) File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 444, in read_from_script if line[0] == 'C': IndexError: string index out of range Exception in thread Thread-3: Traceback (most recent call last): File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner self.run() File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run self.__target(*self.__args, **self.__kwargs) File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 567, in poll_sources cmd.poll() File "D:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 406, in poll self.ch.stdin.write("cpu\r\n") IOError: [Errno 22] Invalid argument