| 1 |
install plugin pam soname 'auth_pam.so'; |
| 2 |
create user test_pam identified via pam using 'mariadb_mtr'; |
| 3 |
grant all on test.* to test_pam; |
| 4 |
create user pam_test; |
| 5 |
grant all on test.* to pam_test; |
| 6 |
grant proxy on pam_test to test_pam; |
| 7 |
# |
| 8 |
# athentication is successful, challenge/pin are ok |
| 9 |
# note that current_user() differs from user() |
| 10 |
# |
| 11 |
Challenge input first. |
| 12 |
Enter: ************************* |
| 13 |
Now, the magic number! |
| 14 |
PIN: 9225 |
| 15 |
select user(), current_user(), database(); |
| 16 |
user() current_user() database() |
| 17 |
test_pam@localhost pam_test@% test |
| 18 |
# |
| 19 |
# athentication is unsuccessful |
| 20 |
# |
| 21 |
Challenge input first. |
| 22 |
Enter: ************************* |
| 23 |
Now, the magic number! |
| 24 |
PIN: 9224 |
| 25 |
# |
| 26 |
# athentication is unsuccessful |
| 27 |
# |
| 28 |
Challenge input first. |
| 29 |
Enter: **************** |
| 30 |
Now, the magic number! |
| 31 |
PIN: 616 |
| 32 |
# |
| 33 |
# athentication is successful |
| 34 |
# |
| 35 |
Now, the magic number! |
| 36 |
PIN: 9212 |
| 37 |
select user(), current_user(), database(); |
| 38 |
user() current_user() database() |
| 39 |
test_pam@localhost pam_test@% test |
| 40 |
# |
| 41 |
# athentication is unsuccessful |
| 42 |
# |
| 43 |
Now, the magic number! |
| 44 |
PIN: 9212 |
| 45 |
# |
| 46 |
# MDEV-26339 Account specifics to be handled before proxying |
| 47 |
# |
| 48 |
alter user pam_test account lock; |
| 49 |
alter user pam_test require subject 'foobar'; |
| 50 |
alter user pam_test password expire; |
| 51 |
Now, the magic number! |
| 52 |
PIN: 9212 |
| 53 |
select user(), current_user(), database(); |
| 54 |
user() current_user() database() |
| 55 |
test_pam@localhost pam_test@% test |
| 56 |
alter user pam_test account unlock; |
| 57 |
alter user pam_test require none; |
| 58 |
alter user pam_test identified by ''; |
| 59 |
show create user pam_test; |
| 60 |
CREATE USER for pam_test@% |
| 61 |
CREATE USER `pam_test`@`%` |
| 62 |
alter user test_pam account lock; |
| 63 |
Now, the magic number! |
| 64 |
PIN: 9212 |
| 65 |
alter user test_pam account unlock; |
| 66 |
alter user test_pam require subject 'foobar'; |
| 67 |
Now, the magic number! |
| 68 |
PIN: 9212 |
| 69 |
alter user test_pam require none; |
| 70 |
alter user test_pam password expire; |
| 71 |
Now, the magic number! |
| 72 |
PIN: 9212 |
| 73 |
select user(), current_user(), database(); |
| 74 |
drop user test_pam; |
| 75 |
drop user pam_test; |
| 76 |
create user PAM_TEST identified via pam using 'mariadb_mtr'; |
| 77 |
grant all on test.* to PAM_TEST; |
| 78 |
# |
| 79 |
# athentication is unsuccessful |
| 80 |
# |
| 81 |
Challenge input first. |
| 82 |
Enter: ************************* |
| 83 |
Now, the magic number! |
| 84 |
PIN: 9225 |
| 85 |
set global pam_winbind_workaround=1; |
| 86 |
# |
| 87 |
# athentication is successful |
| 88 |
# |
| 89 |
Challenge input first. |
| 90 |
Enter: ************************* |
| 91 |
Now, the magic number! |
| 92 |
PIN: 9225 |
| 93 |
select user(), current_user(), database(); |
| 94 |
user() current_user() database() |
| 95 |
PAM_TEST@localhost PAM_TEST@% test |
| 96 |
drop user PAM_TEST; |
| 97 |
# |
| 98 |
# MDEV-27341 Use SET PASSWORD to change PAM service |
| 99 |
# |
| 100 |
create user pam_test identified via pam using 'mariadb_mtr'; |
| 101 |
grant all on test.* to pam_test; |
| 102 |
Challenge input first. |
| 103 |
Enter: ************************* |
| 104 |
Now, the magic number! |
| 105 |
PIN: 9225 |
| 106 |
select user(), current_user(), database(); |
| 107 |
user() current_user() database() |
| 108 |
pam_test@localhost pam_test@% test |
| 109 |
set password='foo'; |
| 110 |
ERROR HY000: SET PASSWORD is not applicable for users authenticating via pam plugin |
| 111 |
show create user; |
| 112 |
CREATE USER for pam_test@% |
| 113 |
CREATE USER `pam_test`@`%` IDENTIFIED VIA pam USING 'mariadb_mtr' |
| 114 |
drop user pam_test; |
| 115 |
uninstall plugin pam; |