Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.40, 10.0.14
-
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.