Bug #69539 plugin_auth tests fail on systems with no hostname other than localhost

• Submitted: 21 Jun 2013 11:01
• Modified: 27 Sep 2013 13:37
• Reporter: Mark Leith
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.5+
• OS: Any
• CPU Architecture: Any

[21 Jun 2013 11:01] Mark Leith

Description:
plugin_auth and plugin_auth_qa_2 both expect that more than one hostname will be defined for root level privileges, rather than allowing for the fact that only localhost may be defined:

CURRENT_TEST: main.plugin_auth_qa_2
--- /home/pomyk/s/ma/5.5/mysql-test/r/plugin_auth_qa_2.result   2013-04-09 21:22:04.966444000 +0200
+++ /home/pomyk/s/ma/5.5/mysql-test/r/plugin_auth_qa_2.reject   2013-06-21 10:50:03.134736687 +0200
@@ -103,7 +103,6 @@
 root
 root
 root
-root
 exec MYSQL -h localhost -P MASTER_MYPORT --user=qa_test_6_user  --password=qa_test_6_dest test_user_db -e "SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;" 2>&1
 ERROR 1045 (28000): Access denied for user 'qa_test_6_user'@'localhost' (using password: YES)
 GRANT PROXY ON qa_test_6_dest TO root IDENTIFIED WITH qa_auth_interface AS 'qa_test_6_dest';
...

CURRENT_TEST: main.plugin_auth
--- /home/pomyk/s/ma/5.5/mysql-test/r/plugin_auth.result        2013-04-09 21:22:04.966444000 +0200
+++ /home/pomyk/s/ma/5.5/mysql-test/r/plugin_auth.reject        2013-06-21 10:50:05.040736619 +0200
@@ -15,7 +15,6 @@
 SELECT * FROM mysql.proxies_priv;
 Host   User    Proxied_host    Proxied_user    With_grant      Grantor Timestamp
 xx     root                    1               xx
-xx     root                    1               xx
 xx     plug    %       plug_dest       0       root@localhost  xx
 test mysql.proxies_priv;
 SHOW CREATE TABLE mysql.proxies_priv;

How to repeat:
Run plugin_auth / plugin_auth_qa_2 on a system that only has localhost defined as a hostname.

[24 Sep 2013 12:27] Laurynas Biveinis

Is the "Verified" status correct?

5.5$ bzr log -r 4446
------------------------------------------------------------
revno: 4446
committer: Sneha Modi <[e-mail]>
branch nick: mysql-5.5
timestamp: Wed 2013-08-21 15:24:38 +0530
message:
  Bug#16995954 : PLUGIN_AUTH TESTS FAIL ON SYSTEMS WITH NO HOSTNAME OTHER
  THAN LOCALHOST
  
        This is a test bug and the explanation for the behaviour can be found
  on the bug page.Modifying the select to select user where user!=root for the line where
  failure is encountered on machines with no hostname other than the localhost.

[27 Sep 2013 13:37] Paul DuBois

Changes to test suite. No changelog entry needed.