| 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 |
show variables like 'pam_use_%'; |
| 8 |
Variable_name Value |
| 9 |
pam_use_cleartext_plugin ON |
| 10 |
# |
| 11 |
# same test as in pam.test now fails |
| 12 |
# |
| 13 |
# |
| 14 |
# success |
| 15 |
# |
| 16 |
user() current_user() database() |
| 17 |
test_pam@localhost pam_test@% NULL |
| 18 |
# |
| 19 |
# failure |
| 20 |
# |
| 21 |
drop user test_pam; |
| 22 |
drop user pam_test; |
| 23 |
uninstall plugin pam; |