Bug #84876 Creating and modifying users with auth_socket fails

• Submitted: 8 Feb 2017 9:36
• Modified: 8 Feb 2017 10:33
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 6.3.9
• OS: Any
• CPU Architecture: Any
• Tags: auth_socket, authentication plugins, unix domain socket

[8 Feb 2017 9:36] Daniël van Eeden

Description:
- I can't change the authentication method for an existing user with auth_socket
- Creating a new user with auth_socket fails (see below for details)
- It warns me about the security hazard of creating an account without password, which doesn't make sense when using auth_socket.

How to repeat:
10:31:43 [ERR][       pymforms]: Unhandled exception in Python code: 'auth_socket'
<traceback object at 0x7f2fed7b25a8>
10:31:43 [ERR][         python]: Error forwarding notification to PythonTraceback (most recent call last):
10:31:44 [ERR][         python]:   File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 31, in _the_observer
10:31:44 [ERR][         python]:     for obs, nam, obj in self.observers:
10:31:44 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/wb_admin_security.py", line 2012, in commit
10:31:44 [ERR][         python]:     if self._selected_user.auth_plugin and AUTHENTICATION_PLUGIN_TYPES[self._selected_user.auth_plugin]["auth_string_label"]:
10:31:44 [ERR][         python]: KeyError: 'auth_socket'

Suggested fix:
Test with WB with auth_socket

[8 Feb 2017 10:33] MySQL Verification Team

Hello Daniël,

Thank you for the report.
Verified as described.

Thanks,
Umesh