| 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: | |
| 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
[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.
