Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.8.2
-
None
-
Gentoo
-
Not for Release Notes
Description
I am working on 11.8.2 version bump in gentoo, but the main.information_schema_db test fails with following error message:
CURRENT_TEST: main.information_schema_db
|
--- /var/tmp/portage/dev-db/mariadb-11.8.2/work/mysql/mysql-test/main/information_schema_db.result 2025-05-21 14:08:34.000000000 -0000
|
+++ /var/tmp/portage/dev-db/mariadb-11.8.2/work/mysql/mysql-test/main/information_schema_db.reject 2025-06-26 09:42:11.607473209 -0000
|
@@ -397,47 +397,43 @@
|
alter user naughty_user password expire interval 10 day;
|
select * from information_schema.users;
|
USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME
|
-'mariadb.sys'@'localhost' 0 0000-00-00 00:00:00
|
+'mariadb.sys'@HOSTNAME 0 0000-00-00 00:00:00
|
'naughty_user'@'%' 0 2020-01-12 02:03:04
|
'nice_user'@'%' 0 NULL
|
'root'@'127.0.0.1' NULL NULL
|
'root'@'::1' NULL NULL
|
-'root'@'localhost' NULL NULL
|
-'root'@HOSTNAME 0 NULL
|
+'root'@HOSTNAME NULL NULL
|
alter user nice_user password expire interval 10 day;
|
select * from information_schema.users;
|
USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME
|
-'mariadb.sys'@'localhost' 0 0000-00-00 00:00:00
|
+'mariadb.sys'@HOSTNAME 0 0000-00-00 00:00:00
|
'naughty_user'@'%' 0 2020-01-12 02:03:04
|
'nice_user'@'%' 0 2020-01-12 02:03:04
|
'root'@'127.0.0.1' NULL NULL
|
'root'@'::1' NULL NULL
|
-'root'@'localhost' NULL NULL
|
-'root'@HOSTNAME 0 NULL
|
+'root'@HOSTNAME NULL NULL
|
connect(localhost,naughty_user,wrong_passwd,test,MASTER_PORT,MASTER_SOCKET);
|
connect con1, localhost, naughty_user, wrong_passwd;
|
ERROR 28000: Access denied for user 'naughty_user'@'localhost' (using password: YES)
|
select * from information_schema.users;
|
USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME
|
-'mariadb.sys'@'localhost' 0 0000-00-00 00:00:00
|
+'mariadb.sys'@HOSTNAME 0 0000-00-00 00:00:00
|
'naughty_user'@'%' 1 2020-01-12 02:03:04
|
'nice_user'@'%' 0 2020-01-12 02:03:04
|
'root'@'127.0.0.1' NULL NULL
|
'root'@'::1' NULL NULL
|
-'root'@'localhost' NULL NULL
|
-'root'@HOSTNAME 0 NULL
|
+'root'@HOSTNAME NULL NULL
|
connect(localhost,naughty_user,wrong_passwd,test,MASTER_PORT,MASTER_SOCKET);
|
connect con1, localhost, naughty_user, wrong_passwd;
|
ERROR 28000: Access denied for user 'naughty_user'@'localhost' (using password: YES)
|
select * from information_schema.users;
|
USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME
|
-'mariadb.sys'@'localhost' 0 0000-00-00 00:00:00
|
+'mariadb.sys'@HOSTNAME 0 0000-00-00 00:00:00
|
'naughty_user'@'%' 2 2020-01-12 02:03:04
|
'nice_user'@'%' 0 2020-01-12 02:03:04
|
'root'@'127.0.0.1' NULL NULL
|
'root'@'::1' NULL NULL
|
-'root'@'localhost' NULL NULL
|
-'root'@HOSTNAME 0 NULL
|
+'root'@HOSTNAME NULL NULL
|
# Show all users that are blocked due to max_password_errors reached.
|
select user from information_schema.users
|
where password_errors >= @@global.max_password_errors;
|
@@ -448,13 +444,12 @@
|
connection default;
|
select * from information_schema.users;
|
USER PASSWORD_ERRORS PASSWORD_EXPIRATION_TIME
|
-'mariadb.sys'@'localhost' 0 0000-00-00 00:00:00
|
+'mariadb.sys'@HOSTNAME 0 0000-00-00 00:00:00
|
'naughty_user'@'%' 0 2020-01-12 02:03:04
|
'nice_user'@'%' 0 2020-01-12 02:03:04
|
'root'@'127.0.0.1' NULL NULL
|
'root'@'::1' NULL NULL
|
-'root'@'localhost' NULL NULL
|
-'root'@HOSTNAME 0 NULL
|
+'root'@HOSTNAME NULL NULL
|
disconnect con1;
|
# test FLUSH PRIVILEGES
|
connect(localhost,naughty_user,wrong_passwd,test,MASTER_PORT,MASTER_SOCKET);
|
 |
Result length mismatch
|
 |
- saving '/var/tmp/portage/dev-db/mariadb-11.8.2/temp/var-tests/2/log/main.information_schema_db/' to '/var/tmp/portage/dev-db/mariadb-11.8.2/temp/var-tests/log/main.information_schema_db/'
|
I bisected the issue to the commit 173edf607d35 ("MDEV-32218 PASSWORD_EXPIRATION_TIME column") which is part of MariaDB 11.5.1 release.
The issue is related to network sandbox, because the test passes when the sandbox is disabled. Gentoo network sandbox contains only lo interface and the hostname is set to localhost.
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is caused by
-
MDEV-32218 message to notify end-user N-days prior the password get expired
-
- Closed
-