| 1 |
|
| 2 |
--source include/have_plugin_auth.inc |
| 3 |
--source include/not_embedded.inc |
| 4 |
|
| 5 |
if (!$SERVER_AUDIT_SO) { |
| 6 |
skip No SERVER_AUDIT plugin; |
| 7 |
} |
| 8 |
if (!$AUTH_ED25519_SO) { |
| 9 |
skip No auth_ed25519 plugin; |
| 10 |
} |
| 11 |
--disable_ps2_protocol |
| 12 |
|
| 13 |
let $MYSQLD_DATADIR= `SELECT @@datadir`; |
| 14 |
let SEARCH_FILE= $MYSQLD_DATADIR/server_audit.log; |
| 15 |
|
| 16 |
--echo # |
| 17 |
--echo # MDEV-35507 and MDEV-35522 |
| 18 |
--echo # |
| 19 |
|
| 20 |
install plugin ed25519 soname 'auth_ed25519'; |
| 21 |
install plugin server_audit soname 'server_audit'; |
| 22 |
|
| 23 |
|
| 24 |
set global server_audit_file_path='server_audit.log'; |
| 25 |
set global server_audit_output_type=file; |
| 26 |
set global server_audit_logging=on; |
| 27 |
|
| 28 |
--echo # unsafe to log passwords (pwd-123) |
| 29 |
|
| 30 |
CREATE USER u1 IDENTIFIED BY 'pwd_123'; |
| 31 |
create user u2 IDENTIFIED VIA ed25519 USING PASSWORD('pwd_123'); |
| 32 |
CREATE OR REPLACE USER u1 IDENTIFIED BY 'pwd_123'; |
| 33 |
SET PASSWORD FOR u1 = PASSWORD('pwd_123'); |
| 34 |
ALTER USER u1 IDENTIFIED BY 'pwd_123'; |
| 35 |
ALTER USER if exists u1 IDENTIFIED BY 'pwd_123'; |
| 36 |
SET STATEMENT max_statement_time=10 FOR ALTER USER u1 IDENTIFIED BY 'pwd_123'; |
| 37 |
alter user u2 identified VIA ed25519 USING password('pwd_123'); |
| 38 |
GRANT ALL ON test TO u1 IDENTIFIED BY "pwd_123"; |
| 39 |
GRANT ALL ON test TO u1 identified VIA ed25519 as password('pwd_123') or ed25519 using password('pwd_123'); |
| 40 |
CREATE SERVER s1 FOREIGN DATA WRAPPER mariadb OPTIONS ( PASSWORD "pwd_123"); |
| 41 |
CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mariadb OPTIONS ( PASSWORD "pwd_123"); |
| 42 |
CREATE OR REPLACE SERVER s1 FOREIGN DATA WRAPPER mariadb OPTIONS ( PASSWORD "pwd_123"); |
| 43 |
--let SEARCH_PATTERN=pwd_123 |
| 44 |
--echo # pattern should not be found |
| 45 |
--source include/search_pattern_in_file.inc |
| 46 |
--echo # pattern should not be found |
| 47 |
|
| 48 |
--echo # cleaunup |
| 49 |
DROP SERVER s1; |
| 50 |
DROP USER u1; |
| 51 |
DROP USER u2; |
| 52 |
set global server_audit_logging=off; |
| 53 |
--remove_file $SEARCH_FILE |
| 54 |
--disable_warnings |
| 55 |
UNINSTALL PLUGIN ed25519; |
| 56 |
UNINSTALL PLUGIN server_audit; |
| 57 |
--enable_warnings |
| 58 |
|
| 59 |
--echo # |
| 60 |
--echo # MDEV-35604: SIGSEGV in filter_query_type | log_statement_ex / auditing |
| 61 |
--echo # |
| 62 |
|
| 63 |
INSTALL PLUGIN server_audit SONAME 'server_audit'; |
| 64 |
SET GLOBAL server_audit_logging=ON; |
| 65 |
|
| 66 |
--ERROR ER_PARSE_ERROR |
| 67 |
SET STATEMENT max_error_count=1 SELECT 1; |
| 68 |
|
| 69 |
# Cleanup |
| 70 |
SET GLOBAL server_audit_logging=OFF; |
| 71 |
--disable_warnings |
| 72 |
UNINSTALL SONAME 'server_audit'; |
| 73 |
--enable_warnings |
| 74 |
|
| 75 |
--echo # end of 10.5 tests |