MySQL Bugs: #15775: "drop user" command does not refresh acl_check

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

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

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'

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

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

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

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

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

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

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

Pushed to 4.1.17, 5.0.19 and 5.1.5

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>