mysql_sha2 different maturity level realted test failures

mysql_sha2.tcp_nossl                     w1 [ fail ]

        Test ended at 2025-11-07 14:28:23

CURRENT_TEST: mysql_sha2.tcp_nossl

mysqltest: At line 19: query 'connect con1, localhost,test1,pwd,,,,TCP NOSSL' failed with wrong errno ER_ACCESS_DENIED_ERROR (1045): 'Plugin caching_sha2_password could not be loaded: /var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/p

lugins/caching_sha2_password.so: cannot open shared object file: No such file or directory', instead of <Unknown> (2061)...

The result from queries just before the failure was:

< snip >

GLOBAL_VALUE_PATH       NULL

VARIABLE_NAME   CACHING_SHA2_PASSWORD_PUBLIC_KEY_PATH

SESSION_VALUE   NULL

GLOBAL_VALUE    public_key.pem

GLOBAL_VALUE_ORIGIN     COMPILE-TIME

DEFAULT_VALUE   public_key.pem

VARIABLE_SCOPE  GLOBAL

VARIABLE_TYPE   VARCHAR

VARIABLE_COMMENT        A path to the public RSA key used for authentication

NUMERIC_MIN_VALUE       NULL

NUMERIC_MAX_VALUE       NULL

NUMERIC_BLOCK_SIZE      NULL

ENUM_VALUE_LIST NULL

READ_ONLY       YES

COMMAND_LINE_ARGUMENT   REQUIRED

GLOBAL_VALUE_PATH       NULL

create user test3@'%' identified via caching_sha2_password using 'pwd';

ERROR HY000: Password hash should be 70 characters long

create user test3@'%' identified via caching_sha2_password using '0000000000000000000000000000000000000000000000000000000000000000000000';

ERROR HY000: Invalid password hash

More results from queries before failure can be found in /var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/1/log/tcp_nossl.log

Warnings from just before the error:

Error 1372 Invalid password hash

 - saving '/var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/1/log/mysql_sha2.tcp_nossl/' to '/var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/log/mysql_sha2.tcp_nossl/'

***Warnings generated in error logs during shutdown after running tests: mysql_sha2.tcp_nossl

2025-11-07 14:28:23 0 [Warning] Plugin 'caching_sha2_password' is of maturity level gamma while the server is stable

2025-11-07 14:28:23 0 [ERROR] mariadbd: caching_sha2_password: failed to read private_key.pem: 2 "No such file or directory"