Bug #49573 Workbench crashes with errors on clicking 'cancel' for password when no password
Submitted: 10 Dec 2009 8:02 Modified: 15 Feb 2010 23:02
Reporter: Nidhi Shrotriya Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.10, 5.2.14 OS:Linux (ubuntu 9.04, 9.10)
Assigned to: CPU Architecture:Any

[10 Dec 2009 8:02] Nidhi Shrotriya
Description:
Installed workbench 5.2.10 from
http://dev.mysql.com/downloads/select.php?id=8 on Ubuntu 9.04.

Launched mysql-workbench.

server is not running 
Server Administration -> choose connection -> ok -> gives an alarm window as 
Could not connect to Mysql server at None@None 
click cancel

** Message: function call error

glibmm-ERROR **: 
unhandled exception (type std::exception) in signal handler:
what: error calling WbAdmin.openSecurityManager: see output for details

aborting...
Aborted

Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 197, in openSecurityManager
    tab = do_open_administrator(server)
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 109, in do_open_administrator
    adminTab = AdministratorTab(server_instance)
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 70, in __init__
    self.ctrl_be = wb_admin_control_be.MyCtrl(server_instance_settings)
  File "/usr/lib/mysql-workbench/modules/wb_admin_control_be.py", line 377, in __init__
    self.connect_sql()
  File "/usr/lib/mysql-workbench/modules/wb_admin_control_be.py", line 389, in connect_sql
    self.db_connection = wb_admin_utils.get_db_connection(self.settings)
  File "/usr/lib/mysql-workbench/modules/wb_admin_utils.py", line 39, in get_db_connection
    raise MySQLError("")
TypeError: __init__() takes exactly 4 arguments (2 given)

How to repeat:
As mentioned in description.
[10 Dec 2009 10:17] MySQL Verification Team
I couldn't repeat on Ubuntu 9.10 X86_64, on my side the message that the Server is not running is displayed.
[10 Dec 2009 14:46] Susanne Ebrecht
Same here. I am not able to repeat this.

Please give a step by step description what you did.
[14 Dec 2009 12:52] Nidhi Shrotriya
Steps to reproduce:
----------------------
Server is not running.

Create a connection connection-socket with 
Local Socket/pipe
/tmp/mysql.sock
root 

Manage server instances -> New -> server-socket -> choose the above connection-socket 

Click -> Server administration -> throws up a window (attaching the file). -> click 'continue anyway' -> shows server is not running. 

Click -> Server administration -> throws up a window (attaching the file). -> click 'cancel' -> closes workbench with the above errors.
[14 Dec 2009 12:54] Nidhi Shrotriya
Screenshot

Attachment: Screenshot-cancel.png (image/png, text), 21.62 KiB.

[18 Dec 2009 8:28] Nidhi Shrotriya
As also mentioned in my steps my connection is, 'localhost' with 'root' user.
Create a connection 'connection-socket' with 
Local Socket/pipe 
/tmp/mysql.sock
root 

In the above Local Socket/pipe means localhost so it would not ask specifically. 

Showing up None@none is another issue, though closing workbench on clicking the cancel button on the pop up window is more serious.
[28 Dec 2009 10:45] Susanne Ebrecht
Nobody of us is able to repeat this.

Do you still have this problem with correct start/stop setup settings by using Workbench 5.2.11?

Do you use SSH connection or so?
[21 Jan 2010 10:54] Nidhi Shrotriya
I am able to reproduce the issue with 5.2.14 on ubuntu 9.10 too.

Manage Server Instances ->
------------------------
Add new connection as below

conn1. 
Local Socket/Pipe
Socket/Pipe -> /tmp/mysql.sock
User -> root
Password -> empty (no password given)

System Profile tab:
---------------------
Profile template -> Custom
Path to configuration file -> empty (removed)
Section from config file -> empty (removed)
home/nidhi/mysql-builds/mysql-5.1.41/bin/msqld_safe --no-defaults &
/home/nidhi/mysql-builds/mysql-5.1.41/bin/msqladmin --user=root --socket=/tmp/mysql.sock shutdown

Use sudo to execute start/stop commands -> unchecked

close. 

Go to Server Administration -> choose server1 -> 

Issues-
1. Asks for password (This is wrong, shouldn't ask as there is no password given)
2. click cancel -> says Could not connect to mysql server at None@None with 2 buttons 'continue anyway' , 'cancel'. This is wrong too as it should say root@localhost probably.
3. Click 'cancel' button---crashes workbench. This should not happen at all

(mysql-workbench-bin:2319): Gtk-CRITICAL **: gtk_list_store_get_path: assertion `iter->stamp == GTK_LIST_STORE (tree_model)->stamp' failed
** Message: function call error

glibmm-ERROR **: 
unhandled exception (type std::exception) in signal handler:
what: error calling WbAdmin.openSecurityManager: see output for details

aborting...
Aborted

_view_impl has NULL ptr at 14
_app_impl has NULL ptr at 5
/usr/lib/mysql-workbench/modules/wb_admin_grt.py:115: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
  if exc.message:
Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 206, in openSecurityManager
    tab.wait_server_check(4)
AttributeError: 'int' object has no attribute 'wait_server_check'
[22 Jan 2010 12:05] Susanne Ebrecht
Nidhi,

you have some typos in here:

home/nidhi/mysql-builds/mysql-5.1.41/bin/msqld_safe --no-defaults &
/home/nidhi/mysql-builds/mysql-5.1.41/bin/msqladmin --user=root --socket=/tmp/mysql.sock
shutdown

one / and some y are missing. This should be correct:

/home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld_safe --no-defaults &

/home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin --user=root --socket=/tmp/mysql.sock shutdown
[28 Jan 2010 12:23] Nidhi Shrotriya
Sorry, but it is not related to typos here. 
I am trying to put the steps here once again.

Outside workbench:
---------------------
cd /home/nidhi/mysql-builds/mysql-5.1.41
scripts/mysql_install_db --no-defaults --datadir=$PWD/data 
nidhi@nidhi-laptop:~$ /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld --no-defaults --basedir=/home/nidhi/mysql-builds/mysql-5.1.41 --datadir=/home/nidhi/mysql-builds/mysql-5.1.41/data --port=3309
nidhi@nidhi-laptop:~$ /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin --user=root --socket=/tmp/mysql.sock shut

Within workbench:
---------------------
Workbench Home -> Manage server instances -> server2 -> edit connection -> 
conn1
Local Socket/Pipe
Socket -> /tmp/mysql.sock
user -> root
password -> don't give (empty) 

Issue :
1) Test connection -> asks for password as "Enter password to connect to MySQL server at as ". ok or cancel -> click cancel -> close 
Issue:
The string "Enter password to connect to MySQL server at as " doesn't show localhost and root. 

System Profile tab ->
Custom
No config file. 
Start Mysql -> /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqld --no-defaults --basedir=/home/nidhi/mysql-builds/mysql-5.1.41 --datadir=/home/nidhi/mysql-builds/mysql-5.1.41/data --port=3309
Stop Mysql -> /home/nidhi/mysql-builds/mysql-5.1.41/bin/mysqladmin --user=root --socket=/tmp/mysql.sock shut

Use sudo is unchecked. ->close

Go to Server administration -> choose server2 -> ok -> asks for password with the same string above -> ok or cancel -> click cancel -> shows up another screen that says Couldn't connect to server at None@None. 'continue anyway' or 'cancel' 

Issues:
1) None@None ?
2) click on cancel -> crashes workbench.

'continue anyway' works fine and shows that 'server is not running'. You can also start the server from workbench now -> asks for password again with the above string. ok or cancel. click ok -> server starts from within workbench. 
Issue:

If you click cancel above -> crashes workbench.

_view_impl has NULL ptr at 14
_app_impl has NULL ptr at 5
/usr/lib/mysql-workbench/modules/wb_admin_grt.py:115: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
  if exc.message:
Traceback (most recent call last):
  File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 206, in openSecurityManager
    tab.wait_server_check(4)
AttributeError: 'int' object has no attribute 'wait_server_check'
[3 Feb 2010 7:02] Nidhi Shrotriya
On doing step 1) & 2) the above mentioned error occurs that closes workbench.

On clicking 'continue anyway' -> says 'Server is not running' -> click 'Start Server' -> asks for password -> ok or cancel -> click 'cancel' -> 
This gives Segmentation fault as below -
_view_impl has NULL ptr at 14
_app_impl has NULL ptr at 5
Query Error Error executing 'show global status':
MySQL server has gone away
*** Segmentation fault
Register dump:

 EAX: 00000000   EBX: 0044aff4   ECX: bfd62a60   EDX: 00000047
 ESI: 00000000   EDI: bfd62a60   EBP: bfd629b8   ESP: bfd62940

 EIP: 0041df1c   EFLAGS: 00210202

 CS: 0073   DS: 007b   ES: 007b   FS: 0000   GS: 0033   SS: 007b

 Trap: 0000000e   Error: 00000004   OldMask: 00000000
 ESP/signal: bfd62940   CR2: 00000050

 FPUCW: ffff037f   FPUSW: ffff0022   TAG: ffffffff
 IPOFF: 004d055e   CSSEL: 0073   DATAOFF: 09393110   DATASEL: 007b

 ST(0) 0000 0000000000000000   ST(1) 0000 e800000000000000
 ST(2) 0000 0000000000000000   ST(3) 0000 0000000000000000
 ST(4) 0000 d280000000000000   ST(5) 0000 df00000000000000
 ST(6) 0000 c8c0000000000000   ST(7) 0000 8000000000000000

Backtrace:
/lib/libSegFault.so[0x58d06f]
??:0(??)[0x802400]
/usr/lib/libgtk-x11-2.0.so.0[0x31ae1fe]
/usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk15Container_Class21check_resize_callbackEP13_GtkContainer+0xad)[0x108803d]
/usr/lib/libgobject-2.0.so.0(g_cclosure_marshal_VOID__VOID+0x7c)[0x7009fc]
/usr/lib/libgobject-2.0.so.0[0x6f16f9]
/usr/lib/libgobject-2.0.so.0(g_closure_invoke+0x1b2)[0x6f3072]
/usr/lib/libgobject-2.0.so.0[0x70849e]
/usr/lib/libgobject-2.0.so.0(g_signal_emit_valist+0x7bd)[0x709b2d]
/usr/lib/libgobject-2.0.so.0(g_signal_emit+0x26)[0x709fb6]
/usr/lib/libgtk-x11-2.0.so.0(gtk_container_check_resize+0x8a)[0x2fe331a]
/usr/lib/libgtk-x11-2.0.so.0[0x2fe3370]
/usr/lib/libgdk-x11-2.0.so.0[0x3ccf78]
/lib/libglib-2.0.so.0[0x3f5f101]
/lib/libglib-2.0.so.0(g_main_context_dispatch+0x1f8)[0x3f60e88]
/lib/libglib-2.0.so.0[0x3f64730]
/lib/libglib-2.0.so.0(g_main_loop_run+0x1bf)[0x3f64b9f]
/usr/lib/libgtk-x11-2.0.so.0(gtk_main+0xb9)[0x3071419]
/usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main8run_implEv+0x17)[0x10b75e7]
/usr/lib/libgtkmm-2.4.so.1(_ZN3Gtk4Main3runEv+0x22)[0x10b73e2]
/usr/bin/mysql-workbench-bin(main+0x89b)[0x816c16b]
/lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6)[0x2dbdb56]
??:0(??)[0x816b661]
[15 Feb 2010 23:02] Alfredo Kojima
Problem about None@None and incorrect username has been fixed.
The bug reported here itself is a duplicate of bug #51088
which has already been fixed.