[MDEV-7089] Test failures in main.failed_auth_unixsocket and plugins.unix_socket depending on environment Created: 2014-11-12  Updated: 2014-11-17  Resolved: 2014-11-12

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5.40, 10.0.14
Fix Version/s: 5.5.41, 10.0.15

Type: Bug Priority: Major
Reporter: Kristian Nielsen Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
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.



 Comments   
Comment by Kristian Nielsen [ 2014-11-12 ]

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).

Generated at Thu Feb 08 07:16:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.