summaryrefslogtreecommitdiff
path: root/mysql-test/main/failed_auth_unixsocket.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-01-12 15:56:25 +0100
committerSergei Golubchik <serg@mariadb.org>2019-02-04 15:54:10 +0100
commitc94ec9fc6721f50fadb1d86d1d0bf004b39c69d2 (patch)
treee94a46af346c4386fc712319be5ba2f1014a11a1 /mysql-test/main/failed_auth_unixsocket.result
parent3742f6f9aadc363fb83e3775066c33ba420fe97b (diff)
downloadmariadb-git-c94ec9fc6721f50fadb1d86d1d0bf004b39c69d2.tar.gz
MDEV-17950 SHOW GRANTS FOR does not work for a user identified with non-existing plugin
Revert the side effect of 7c40996cc866. Do not convert password hash to its binary representation when a user entry is loaded. Do it lazily on the first authenticatation attempt. As a collateral - force all authentication plugins to follow the protocol and read_packet at least once before accessing info->username (username is not available before first client handshake packet is read). Fix PAM and GSSAPI plugins to behave.
Diffstat (limited to 'mysql-test/main/failed_auth_unixsocket.result')
-rw-r--r--mysql-test/main/failed_auth_unixsocket.result9
1 files changed, 2 insertions, 7 deletions
diff --git a/mysql-test/main/failed_auth_unixsocket.result b/mysql-test/main/failed_auth_unixsocket.result
index b2081c9ba84..690476cd753 100644
--- a/mysql-test/main/failed_auth_unixsocket.result
+++ b/mysql-test/main/failed_auth_unixsocket.result
@@ -1,13 +1,8 @@
update mysql.global_priv set priv=json_insert(priv, '$.plugin', 'unix_socket');
flush privileges;
-Warnings:
-Warning 1524 Plugin 'unix_socket' is not loaded
-Warning 1524 Plugin 'unix_socket' is not loaded
-Warning 1524 Plugin 'unix_socket' is not loaded
-Warning 1524 Plugin 'unix_socket' is not loaded
connect(localhost,USER,,test,MASTER_PORT,MASTER_SOCKET);
-ERROR 28000: Access denied for user 'USER'@'localhost' (using password: NO)
-ERROR 28000: Access denied for user 'USER'@'localhost' (using password: NO)
+ERROR HY000: Plugin 'unix_socket' is not loaded
+ERROR HY000: Plugin 'unix_socket' is not loaded
install plugin unix_socket soname 'auth_socket.so';
flush privileges;
connect(localhost,USER,,test,MASTER_PORT,MASTER_SOCKET);