Bug #68978 Admin / Users & Privileges / UI rejects host specification with subnet

• Submitted: 16 Apr 2013 22:13
• Modified: 12 Jun 2013 4:54
• Reporter: Michael Skora
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 5.2.47
• OS: MacOS
• CPU Architecture: Any

[16 Apr 2013 22:13] Michael Skora

Description:
The 5.2.47 UI is rejecting an ip/subnetmask specification that works correctly if the user table is updated via command line. The UI errors out with the following error.

Invalid host specification
The host specification "10.0.1.0/255.255.254.0" is not valid. Please correct it and try again.

Note: It does accept ip/bits (10.0.1.0/23), but that doesn't work on the server (5.0.95).

How to repeat:
Create a user with an ip/subnetmask and try to apply.

[17 Apr 2013 0:13] MySQL Verification Team

Thank you for the bug report. Command line accepts.

mysql> grant all on *.* to "user2"@"10.0.1.0/255.255.254.0" identified by "user2";
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.2.10                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.6.10-log                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | osx10.7                      |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)

[12 Jun 2013 4:54] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.0.2 release, and here's the changelog entry:

Specifying an ip/subnetmask as a host specification would be rejected. For
example, "10.0.1.0/255.255.254.0" would fail to validate as a host.

Thank you for the bug report.