Bug #15775 "drop user" command does not refresh acl_check_hosts
Submitted: 15 Dec 2005 13:39 Modified: 4 Jan 2006 21:37
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.17 OS:
Assigned to: Magnus Blåudd CPU Architecture:Any

[15 Dec 2005 13:39] Magnus Blåudd
Description:
When running the whole testsuite with ./mysql-test-run.pl it will fail at rpl000001 with the error "'localhost' is not allowed to connect to this MySQL server"

How to repeat:
Run the whole test suite
[15 Dec 2005 14:42] Magnus Blåudd
Output from var/lof/master.err, with additional output from acl_check_host and compare_hostname.

The hash_search in in acl_check_host list does not return anything, thus it continues to the wild host list.

neptunus is the name of my machine and one can see that neptunus% is in the "acl_wild_hosts" list, it does  not match "localhost".

CURRENT_TEST: rpl000001
051215 17:17:17 [ERROR] host->hostname: localhost
051215 17:17:17 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
051215 17:17:17 [ERROR] 0
051215 17:17:17 [ERROR] host->hostname: neptunus%
051215 17:17:17 [ERROR] Host is not allowed
051215 17:17:17 [ERROR] acl_check_host failed localhost 127.0.0.1
051215 17:17:17 [ERROR] check connection error : 1130
check_connection error: 1130051215 17:17:19 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
051215 17:17:19 [ERROR] 0
051215 17:17:19 [ERROR] host->hostname: neptunus%
051215 17:17:19 [ERROR] Host is not allowed
051215 17:17:19 [ERROR] acl_check_host failed localhost 127.0.0.1
051215 17:17:19 [ERROR] check connection error : 1130
check_connection error: 1130051215 17:17:21 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
051215 17:17:21 [ERROR] 0
051215 17:17:21 [ERROR] host->hostname: neptunus%
051215 17:17:21 [ERROR] Host is not allowed
051215 17:17:21 [ERROR] acl_check_host failed localhost 127.0.0.1
051215 17:17:21 [ERROR] check connection error : 1130
check_connection error: 1130051215 17:17:23 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
051215 17:17:23 [ERROR] 0
051215 17:17:23 [ERROR] host->hostname: neptunus%
051215 17:17:23 [ERROR] Host is not allowed
051215 17:17:23 [ERROR] acl_check_host failed localhost 127.0.0.1
051215 17:17:23 [ERROR] check connection error : 1130
check_connection error: 1130051215 17:17:25 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
051215 17:17:25 [ERROR] 0
051215 17:17:25 [ERROR] host->hostname: neptunus%
051215 17:17:25 [ERROR] Host is not allowed
051215 17:17:25 [ERROR] acl_check_host failed localhost 127.0.0.1
051215 17:17:25 [ERROR] check connection error : 1130
check_connection error: 1130051215 17:17:27 [ERROR] acl_check_host: 'localhost' '127.0.0.1'
[21 Dec 2005 9:40] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/314
[21 Dec 2005 14:54] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/319
[21 Dec 2005 16:24] Magnus Blåudd
T@8944560: >check_connection
T@8944560: | info: New connection received on TCP/IP (16)
T@8944560: | info: Host: localhost  ip: 127.0.0.1
T@8944560: | >acl_check_host
T@8944560: | | info: acl_check_host: 'localhost' '127.0.0.1'
T@8944560: | | info: acl_check_hosts.records: 8
T@8944560: | | info:   0: 9 'localhost'
T@8944560: | | info:   1: 9 'localhost'
T@8944560: | | info:   2: 9 'neptunus%'
T@8944560: | | info:   3: 9 '127.0.0.1'
T@8944560: | | info:   4: 9 'localhost'
T@8944560: | | info:   5: 9 'localhost'
T@8944560: | | info:   6: 9 'localhost'
T@8944560: | | info:   7: 9 'localhost'
T@8944560: | | info: strlen(host): 9
T@8944560: | | info: strlen(ip): 9
T@8944560: | | >hash_search
T@8944560: | | | enter: key: 'localhost', length: 9
T@8944560: | | | info: calc_hash(): -592964982
T@8944560: | | | info: blength: 16, records: 8
T@8944560: | | | info: hash->charset->name: utf8_general_ci
T@8944560: | | | info: hash->charset->csname: utf8
T@8944560: | | | info: idx from hash_mask: 2
T@8944560: | | | info: idx: 2
T@8944560: | | | info: pos: 0xa7525c0
T@8944560: | | | >check_get_key
T@8944560: | | | | info: length: 9, name: 'neptunus%'
T@8944560: | | | <check_get_key
T@8944560: | | | info: flag set
T@8944560: | | | >check_get_key
T@8944560: | | | | info: length: 9, name: 'neptunus%'
T@8944560: | | | <check_get_key
T@8944560: | | | info: wrong link
T@8944560: | | | info: Didn't find any record
T@8944560: | | <hash_search
T@8944560: | | >hash_search
T@8944560: | | | enter: key: '127.0.0.1', length: 9
T@8944560: | | | info: calc_hash(): -504868932
T@8944560: | | | info: blength: 16, records: 8
T@8944560: | | | info: hash->charset->name: utf8_general_ci
T@8944560: | | | info: hash->charset->csname: utf8
[23 Dec 2005 17:18] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/390
[23 Dec 2005 18:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/391
[28 Dec 2005 8:23] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/437
[28 Dec 2005 13:44] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/441
[29 Dec 2005 9:54] Magnus Blåudd
Pushed to 4.1.17, 5.0.19 and 5.1.5
[4 Jan 2006 21:37] Mike Hillyer
Added to 4.1.17, 5.0.19, 5.1.5 changelogs:

      <listitem>
        <para>
          Issuing a <literal>DROP USER</literal> command could cause
          some users to encounter a <literal><replaceable>hostname</replaceable> is not allowed to connect to this MySQL
            server</literal> error. (Bug #15775)
        </para>
      </listitem>