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
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.40, 10.0.14
    • Fix Version/s: 10.0.15, 5.5.41
    • 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.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            knielsen Kristian Nielsen added a comment -

            Pushed to 5.5.41:

            http://lists.askmonty.org/pipermail/commits/2014-November/006934.html

            (Should be merged to 10.0 in time for 10.0.15).

            Show
            knielsen Kristian Nielsen added a comment - Pushed to 5.5.41: http://lists.askmonty.org/pipermail/commits/2014-November/006934.html (Should be merged to 10.0 in time for 10.0.15).

              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: