Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7089

Test failures in main.failed_auth_unixsocket and plugins.unix_socket depending on environment

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.40, 10.0.14
    • Fix Version/s: 5.5.41, 10.0.15
    • Component/s: Tests
    • Labels:
      None

      Description

      main.failed_auth_unixsocket              [ fail ]
              Test ended at 2014-11-11 20:27:23
       
      CURRENT_TEST: main.failed_auth_unixsocket
      --- /«PKGBUILDDIR»/mysql-test/r/failed_auth_unixsocket.result	2014-09-24 22:29:46.000000000 +0000
      +++ /«PKGBUILDDIR»/mysql-test/r/failed_auth_unixsocket.reject	2014-11-11 20:27:23.184614979 +0000
      @@ -5,8 +5,8 @@
       ERROR HY000: Plugin 'unix_socket' is not loaded
       install plugin unix_socket soname 'auth_socket.so';
       connect(localhost,USER,,test,MASTER_PORT,MASTER_SOCKET);
      -ERROR 28000: Access denied for user 'USER'@'localhost'
      -ERROR 28000: Access denied for user 'USER'@'localhost'
      +ERROR 28000: Access denied for USER 'USER'@'localhost'
      +ERROR 28000: Access denied for USER 'USER'@'localhost'
       update mysql.user set plugin='';
       flush privileges;
       uninstall plugin unix_socket;

      plugins.unix_socket                      [ fail ]
              Test ended at 2014-11-11 20:32:30
       
      CURRENT_TEST: plugins.unix_socket
      mysqltest: Could not open connection 'default': 1045 Access denied for user 'foobar'@'localhost' (using password: NO)
      mysqltest: Could not open connection 'default': 1698 Access denied for user 'foobar'@'localhost'
      --- /«PKGBUILDDIR»/mysql-test/suite/plugins/r/unix_socket.result	2014-09-24 22:29:47.000000000 +0000
      +++ /«PKGBUILDDIR»/mysql-test/suite/plugins/r/unix_socket.reject	2014-11-11 20:32:29.884614402 +0000
      @@ -2,17 +2,17 @@
       #
       # with named user
       #
      -create user USER identified via unix_socket;
      +create USER USER identified via unix_socket;
       #
       # name match = ok
       #
      -select user(), current_user(), database();
      -user()	current_user()	database()
      +select USER(), current_USER(), database();
      +USER()	current_USER()	database()
       USER@localhost	USER@%	test
       #
       # name does not match = failure
       #
      -drop user USER;
      +drop USER USER;
       #
       # and now with anonymous user
       #
      @@ -20,8 +20,8 @@
       #
       # name match = ok
       #
      -select user(), current_user(), database();
      -user()	current_user()	database()
      +select USER(), current_USER(), database();
      +USER()	current_USER()	database()
       USER@localhost	@%	test
       #
       # name does not match = failure

      This failure happened in the Debian build farm environment. The problem is
      that the test suite is run as the unix account 'user'. This causes replace of
      $USER to replace too much.

      The fix should be to make the replacements more specific, so they only match
      the stuff that actually should be replaced, regardless of the value of $USER.

        Attachments

          Activity

            People

            • Assignee:
              knielsen Kristian Nielsen
              Reporter:
              knielsen Kristian Nielsen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: